Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between Triggers and store procedure?
- 2 Answers
- 5557 Views
- I also Faced
- E-Mail Answers
Answer Posted / vidit tyagi
triggers are events which fires automaticaly when any insert
,update or delete command execute
but in case of stored procedure we have to manualy
execute / fire to procedure
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is the different types of backups available in sql server? : Sql server database administration
What is optimization and its types?
How retrieve field names from the table in SQL through JAVA code?
Is sql server implemented as a service or an application? : Sql server database administration
Can you move the resources after pausing the node? : sql server database administration
What are diverse clauses that form a part of sql?
What is nonclustered index on computed columns?
What are the restrictions that views have to follow? : SQL Server Architecture
What samples and sample databases are provided by microsoft?
What are subqueries in sql server? Explain its properties.
What is factless fact table? : sql server analysis services, ssas
How do you manipulate data?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
what is the difference between a primary key and a unique key? : Sql server database administration
