Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How to define and use table alias names in ms sql server?
What is table-valued sub query?
Explain what are the restrictions while creating batches in sql server?
What is the size of transaction log file?
explain different types of constraints? : Sql server database administration
What is your recommendation for a query running very slow? : sql server database administration
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What is database normalization?
7 Answers Deloitte, Digicel, JPMorgan Chase, Verifone,
What is SQL Profiler what is the use of it?
2 Answers 247Customer, Steria,
Is sql different from sql server?
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)