Is sql server implemented as a service or an application? : Sql server database administration
What is difference between rownum and row_number?
Explain the steps to create and execute a user-defined function in the sql server?
What's the difference between a primary key and a unique key?
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
What is primary key, unique key, and foreign key?
What is rolap and its advantage? : sql server analysis services, ssas
Explain user defined views?
How to write a script for upate the data in prod , i have 50000 row are there
how do we find every fifth record in a table
How can a user-defined datatype be created?
What is sql sandbox in sql server?
If the job running very slow what is the action you do