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

Post New Answer

More SQL Server Interview Questions

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,


What is attribute? : sql server analysis services, ssas

0 Answers  


What is indexed view?

0 Answers  


List some advantages and disadvantages of stored procedure?

0 Answers  


What is data compression?

0 Answers  






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???

3 Answers  


Difference between rowid and rownum in SQL?

1 Answers   Virtusa,


How to list all user defined functions in the current database?

0 Answers  


Can we have more than one NULL in a column having unique constraint?

12 Answers   247Customer,


How to implement service broker?

0 Answers  


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?

1 Answers  


What are the different types of Indexes available in SQL Server?

0 Answers  


Categories