Answer Posted / Payal Agrawal
"To create an INSERT-only trigger in MS SQL Server, you can use the `CREATE TRIGGER` command. Here is an example:nn```sqlnCREATE TRIGGER tr_InsertOnly ON [table_name]nAFTER INSERTnASnBEGINnIF EXISTS(SELECT * FROM inserted)nBEGINn-- Your code to perform operations based on the inserted datanENDnEND;n```
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Can one drop a column from a table?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
do you know how to configure db2 side of the application? : Sql server database administration
What is the difference between upgrade and migration in sql server?
Disadvantages of the indexes?
What is sql or structured query language?
Can sql servers link to other servers like oracle?
What are the different SQL Server Versions you have worked on?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is subquery? Explain the properties of a subquery?
What is temporary table in sql server? Why we use temp table?
What is in place upgrade in sql server?
What are wait types?
What is standby servers? Explain types of standby servers.
