Difference between Triggers and Stored Procedure
Answer Posted / rajani kant
stored procedure
Definition
please give me Answer
| Is This Answer Correct ? | 34 Yes | 36 No |
Post New Answer View All Answers
What is indexing explain it with an example?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How to disable triggers using "disable trigger"?
How we can compare two database data?
List the data types available in mssql?
Can you pass expressions to function parameters?
What are information schema views?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is a file group?
How to convert numeric expression data types by assignment operations?
What are the Advantages of using CTE in sql server?
What is the contrast between sql and mysql?
What’s the distinction between dropping a info and taking a info offline?
What is Service Broker in sql server 2012?