Why do we use stored procedures in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
How data can be copied from one table to another table?
How to make a remote connection in a database?
What is normalization?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Why main is user defined function?
What is sql server agent and what are the two modes of authentication in sql server?
Explain table valued parameters in sql server? Why tvp used?
How to count the number of duplicate items in a table?
Do you know what is lock escalation?
What number sorts of privileges are accessible in sql?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
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)