Answer Posted / shalini
trigger is a block of code that constitutes a set of T-sql
statements activated to response in certain action.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
role of sql sever 2005 in database rather than any other database
What is a join in sql? What are the types of joins?
What is the use of commit?
What is the language structure to add a record to a table?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What do you understand by the denormalisation?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What are the different types of stored procedures?
how many no of arguments can be passed in procedures and functions
What is difference between index seek vs. Index scan?
How do you send email on SQL Server?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Explain various On-Delete options in a DB table. Which is the default option?
Can foreign key be deleted?
Explain what are page splits? : SQL Server Architecture