List some major differences between triggers and stored procedures?
No Answer is Posted For this Question
Be the First to Post Answer
Can we call future method from queueable?
What is the filtered index?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Which database stores information about replication?
Explain cross join or cartesian product in sql?
Detail about the hardware which is supported by SQL server?
What is ddl and dml commands?
What is the benefit of normalization?
How do you set a trace flag in sql server?
How to filter out duplications in the returning rows in ms sql server?
What is sub-query in sql server? Explain its properties.
1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?
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)