How to find out what is the default collation in a database?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

how will add additional conditions in sql?

0 Answers   Amdocs, Apps Associates,


What is sql service broker?

0 Answers  


What is save transaction and save point?

0 Answers  


How to select some specific columns from a table in a query in ms sql server?

0 Answers  


table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  






Explain intellisense for query editing

0 Answers  


What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  


Where sql server user names and passwords are stored in sql server? : sql server database administration

0 Answers  


Can we check locks in database? If so, how can we do this lock check?

0 Answers  


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  


Does sql server use t sql?

0 Answers  


What is difference between count (*) and count 1?

0 Answers  


Categories