What command do we use to rename a db, a table and a column?
can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?
Will count(column) include columns with null values in its count?
Is truncate a dml command?
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
your distribution database is full what will u do
Explain important index characteristics?
How extra digits are handled with numeric data type literals?
Do you know the different ddl commands in sql?
How many categories of functions based their return modes?
What are the advantages of passing name-value pairs as parameters?
What will be the maximum number of index per table?
How to find the list of fixed hard drive and free space on server?