How fixed length strings are truncated and padded?
Do you know what is openxml in sql server?
I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
How to disable triggers using "disable trigger"?
What is the use of floor function in sql server?
What is deploy, process and build? : sql server analysis services, ssas
What is BCP? When do we use it?
Explain different types of locks in sql server.
You want to implement the one-to-many relationship while designing tables. How would you do it?
How to find which stored procedure is currently running in sql server?
What do you understand by recursive stored procedures?
How to create a simple table to test triggers in ms sql server?