Explain the commands in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
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?
Define constraints and give an example of their use?
How to find out what is the default collation in a database?
What is a trigger? Why we need it?
How many types of Cursor in SQL SERVER?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What is table join?
Are resultset updatable?
Does partitioning help performance?
What are the different ways of moving data/databases between servers and databases in SQL Server?
How to use old values to define new values in update statements in ms sql server?
Explain the relational database management system (rdbms)?
Oracle (3253)
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)