Wednesday, 5 April 2017

What are the limitations of triggers in Sql Server?

 These are the limitations of triggers in  Sql server

1. We can not pass the parameters for triggers  like Stores procedure , function etc....
2. can not perform COMMIT or ROLLBACK.



-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Table size and rows of tables in sql server

Below query  will help us, to know tables size and now  of rows in a table.  SELECT     SCHEMA_NAME(t.schema_id) AS SchemaName,     t.name A...