SQL Server Interview Questions
Questions Answers Views Company eMail

syntax for deleting the database in T SQL

5 3996

How are SQL Server databases physically stored under Windows 2000?

1 2311

internal language used in sql server 2000?

2 2091




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

1 3067

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

1 2889

Which virtual table does a trigger use?

3 5956

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

1 2321

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 7909




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

3 2346

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

4 3000

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 10781

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 5152

what is difference between having and where clause ?

3 3162

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

4 5612

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

10 11546


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what are the Prerequisites for Replication?

8605


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.

816


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2778


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

1675


sql database suspect We have a sql database that is showing as suspect. How can we recover?

745






in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

350


your distribution database is full what will u do

994


how can u get last observation in an unknown dataset ?

1192


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

4301


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

733


How do use Having,Group by,Group function in SQL?

705


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2716


How do you Implement SSIS Packages in your Project?

869


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1540


on line cluster can we make if yes tell me the procedure

871