Is it possible for a stored procedure to call itself or recursive stored procedure?
What is full outer join in sql server joins?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
explain different levels of normalization? : Sql server database administration
How to apply cascading referential integrity in place of triggers?
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???
What happens if you are trying to access a schema not owned by you?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What are difference between Cluster index and Non-Cluster index?
how to retrive only second row from table in sql server 2000?
what is the disadvantage of SQL Loder?
What do you mean by tablesample?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?