Can two different columns be merged into single column? Show practically?
How to check status of stored procedure in sql server?
i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?
When I delete any data from a table, does the sql server reduce the size of that table?
What command is used to rename the database?
What are the operating modes in which database mirroring runs?
What is repeatable read?
What are different types of subquery?
What is meant by datasource?
How to configure odbc dsn with different port numbers?
What is transaction server distributed transaction?
Explain the truncate command? : SQL Server Architecture
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?