NEED SOME SCENARIO ORIENTED SQL QUERIES FOR SQL SERVER

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts

How to get the exact property name while getting error (0)
PDB file is not showing Line Number in dot net application hosted on server (0)
Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different (0)
how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON) (1)
can't receive data after success login ? (1)
Implement Multi-Tenant in Azure Logic Apps (0)
Why ASP.Net Core 7.0 Web API showing as Connection refused? (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
More ...