Why use identity in sql server?
What is a coalesce function?
What are the different subsets of sql?
List the ways in which dynamic sql can be executed?
What is subquery in sql?
List some case manipulation functions in sql?
Which sql server table is used to hold the stored procedure script?
What is the significance of master, tempdb and model databases?
Explain alternate key, candidate key and composite key in sql server?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
How to find the second highest salary of an employee?
What is the main difference between ‘between’ and ‘in’ condition operators?
How to make a remote connection in a database?
Can we write a distributed query and get some data which is located on other server and oracle database?
Explain the first normal form(1nf)?