SQL Server Interview Questions
Questions Answers Views Company eMail

syntax for deleting the database in T SQL

5 3835

How are SQL Server databases physically stored under Windows 2000?

1 2219

internal language used in sql server 2000?

2 1952




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

1 2951

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

1 2795

Which virtual table does a trigger use?

3 5841

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

1 2239

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 7804




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

3 2232

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

4 2901

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 10400

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 4996

what is difference between having and where clause ?

3 3065

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

4 5485

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

10 11325


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

If we delete pack Spec what will be the status of pack Body ?

147


What is the difference between online clustering and Offline clustering?

1197


application server is slow what may be the problem

1065


role of sql sever 2005 in database rather than any other database

855


You are doing log shipping due to some reasons it is failing. How you will proceed from there

792






Why we need to use secondry database file? though, we can do same work using primary database file also.

4174


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1072


Comment,Datatypes are unlimited

894


How to trouble shoot if unable to connect SQL Server

743


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

748


SQL Server Architecture ?

1101


what exactly sql injuction.how to overcome.....

1285


plss anybody specify tha constrian management system in dbms

788


how to take backup bcp out for a column in table in sql server?

820


what is difference between view and Dip.

1165