Which are ddl commands?
What do you understand by mirroring and mention the advantages of the mirroring?
What is partition, how will you implement it? : sql server analysis services, ssas
what is a correlated sub-query? : Sql server database administration
Delete duplicate records from the table?(Table must have unique id)
7 Answers TCS, Thomson Reuters,
How to verify a login name with sqlcmd tool?
What is extended stored procedures?
What are the different types of upgrades that can be performed in sql server?
Why olap is used?
Is it possible to create tables in stored procedures using a variable for the table name?
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?
How to get a list all databases on the sql server?
you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required