Explain various On-Delete options in a DB table. Which is the default option?
No Answer is Posted For this Question
Be the First to Post Answer
Where are SQL server users names and passwords are stored in sql server?
What is attribute? : sql server analysis services, ssas
What is indexed view?
List some advantages and disadvantages of stored procedure?
What is data compression?
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???
Difference between rowid and rownum in SQL?
How to list all user defined functions in the current database?
Can we have more than one NULL in a column having unique constraint?
How to implement service broker?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What are the different types of Indexes available in SQL Server?