Explain the categories of stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
Explain powershell included in sql server 2008?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
Is it ok to shrink transaction log?
Can we passed multiple recordset(set of records) using a Stored Procedure
What are views used for?
Explain sql server authentication modes?
Explain the different types of joins?
What is the STUFF function and how does it differ from the REPLACE function?
What is msdb database? : SQL Server Architecture
Can you explain what are commit and rollback in sql?
What is a select query statement in ms sql server?
Why I am getting this error when dropping a database in ms 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)