What happens when converting big values to integers?
What are synonyms?
How can we Use Linked Server? Uses of Linked server
Can you name a few encryption mechanisms in sql server?
What is the difference between a fill factor of 100 and 0?
difference between Clustered index and non clustered index ?
What is clr ddl trigger?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What are window functions in sql server?
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
What is a ddl statement?
Write down the syntax and an example for create, rename and delete index?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?