SQL Server Interview Questions
Questions Answers Views Company eMail

syntax for deleting the database in T SQL

5 4073

How are SQL Server databases physically stored under Windows 2000?

1 2358

internal language used in sql server 2000?

2 2156




What types of integrity are enforced by a foreign-key constraint

1 3117

How do you find the error, how can you know the number of rows effected by last SQL statement?

1 2928

Which virtual table does a trigger use?

3 6024

Name three version of sql server 2000 and also their differences?

1 2363

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 7957




can you any body tell me which service pack is installed in the sql server?

3 2411

can you any body tell me the how to decrease the logfile

4 3047

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

IBM, HCL,

17 10977

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 5216

what is difference between having and where clause ?

3 3211

Accidentally i deleted my table. How can i get that table?

4 5697

how can i view structure of table in sql server? tell me that query.

10 11647


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

can any body tell me how to know the password of current user in sql server

982


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

946


what is isolation level at dead lock?

1083


whats new about truncate in sql server 2008?

1385


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1320






SQL Server Architecture ?

1206


plss anybody specify tha constrian management system in dbms

886


Working with TLogs

751


where the connection string store in the database

898


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

876


How to trouble shoot if unable to connect SQL Server

854


what is difference between view and Dip.

1273


how many no of arguments can be passed in procedures and functions

3635


what is checksum in sql server.........???

467


what is package and it uses and how can u call a package

961