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
Do you know exporting and importing utility?
What is partition in sql server?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
What is an expensive query?
What is 'write-ahead log' in sql server 2000 ?
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?
Which index created when Create Index on table(col), Why
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is oltp (online transaction processing)?
A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?
Define right outer join in sql server joins?
List the various tools available for performance tuning?
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)