How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Can we use trigger new in before insert?
Is the primary key column of a table an index in ms sql server?
What are the transaction properties?
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)
Explain temporary table vs table variable by using cursor alternative?
What is the contrast between sql and mysql?
What are the differences between substr and charindex in sql server.
Explain couple pf features of SQL server
What objects does the fn_my_permissions function reports on? : sql server security
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
How to Check if table exists 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?