NEED SOME SCENARIO ORIENTED SQL QUERIES FOR SQL SERVER

Posted by balajirnaukri-12656 under Sql Server on 11/19/2012 | Points: 10 | Views : 1724 | Status : [Member] | Replies : 1
Hi all,

I need some scenario oriented queries that will be asked in the interview in sql server and it should cover all the areas

Thanks and Regards
Balaji.R
ASP.NET Devloper
Solve-IT corp



Responses

Posted by: Krv on: 11/19/2012 [Member] Starter | Points: 25

Up
0
Down
a. Removing duplicate records from a large database
b. Methods available to get total rows in a table
c. Self Join and cross join
d. CTE, Table Value Variable, Temp Table

Thanks,
R.Vasanth
MCTS(SQL Server & BI)
http://bigdatatech.blogspot.com

balajirnaukri-12656, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response