Tell me about Triggers?
Answers were Sorted based on User's Feedback
Answer / pradeep
Triggers in DB are analogus to the triggers in hand
grenades.
It are reffered a stored procedure call that initiates its
action on any event occures such as insert, update or
delete query.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / praveen ch
trigger is nothing but a logic, this logic like a stored
procedure and which is uesd to represented as before
updation of table or after updation of the table
thank u
Is This Answer Correct ? | 0 Yes | 0 No |
when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql
Tell me can we use custom code in ssrs?
How do you load large data to the SQL server database?
What is an sql server agent?
how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.
What is RMS migrations?
What is lookup override?
What is the recursive stored procedure in sql server?
What is BCP? When do we use it?
How to create a local temporary stored procedure?
What about UPDATESTATISTICS ?
Explain what is dbcc?