What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
No Answer is Posted For this Question
Be the First to Post Answer
What is transactional replication?
What are the requirements on sql server network connections?
How can we get count of the number of records in a table?
What is function of CUBE ?
What is the difference between the application object and session object?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
How to find the login name linked to a given user name?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
Explain Geography datatype in SQL Server
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?
What is conditional split?
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)