Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
No Answer is Posted For this Question
Be the First to Post Answer
How to see existing views in ms sql server?
What is global temp table?
What is Pointer ?
3 Answers Cap Gemini, CarrizalSoft Technologies,
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is a sub-query? When would you use one?
How to use subqueries in the from clause in ms sql server?
Can you explain the types of Joins that we can have with Sql Server?
How do I edit a stored procedure in sql server?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
What happens when converting big values to numeric data types?
If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?
What is set nocount on and what is set nocount off?
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)