Answer Posted / kmbkrishnan
Triggers use magic tables - Inserted and Deleted
updated or update table not available.
| Is This Answer Correct ? | 57 Yes | 5 No |
Post New Answer View All Answers
How to include date and time values in sql statements?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
what's new in sql server 2016?
Tell me what is difference between view and materialized view?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Can select statements be used on views in ms sql server?
Differentiate sql server reporting services vs. Crystal reports?
What are the built in functions in sql server?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is measure group, measure? : sql server analysis services, ssas
What is a scheduled job or what is a scheduled task?
Are null values the same as that of zero or a blank space?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Explain different backup plans?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
