Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
No Answer is Posted For this Question
Be the First to Post Answer
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What are policy management terms?
Do you know sql server 2008 backup compression?
What is BLOCK statements in SQL?
Can a database be shrunk to 0 bytes, if not, why?
What is the sql server agent?
A trigger can reference objects outside the current database? State true or false.
What is default constraint?
Do you know the policy based administration feature of sql server 2008?
What is a collation in ms sql server?
What is live lock and deadlock? what is Lock escalation?
How can I change procedure name in sql server?
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)