Name three version of sql server 2000 and also their
differences?
What is self contained multi valued query?
Can we use custom code in ssrs?
What are character string data types in ms sql server?
How do I find the sql server instance name?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Can group functions be used in the order by clause in ms sql server?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
what is the difference between group and having give an example with query and sample output
How do use Having,Group by,Group function in SQL?
write sql program to get the detail of student in a class?
Do you know what is a trace frag? Where do we use it?
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
Oracle (3253)
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)