What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
No Answer is Posted For this Question
Be the First to Post Answer
What are the two virtual tables SQL Server maintains for triggers?
Which databases are part of SQL server default installation? Explain the usage of each?
What is a stored procedure?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
How to see the event list of an existing trigger using sys.trigger_events?
What are the OS services that the SQL Server installation adds?
Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.
What are the difference between data length and length in SQL Server-2008?
What is plan freezing?
How can sql injection be stopped? : sql server security
Is it ok to shrink transaction log?
What is the difference between a stored procedure and a user defined function?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)