SQL Server Interview Questions
Questions Answers Views Company eMail

syntax for deleting the database in T SQL

5 3796

How are SQL Server databases physically stored under Windows 2000?

1 2198

internal language used in sql server 2000?

2 1917

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

1 2921

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

1 2769

Which virtual table does a trigger use?

3 5802

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

1 2215

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 7775

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

3 2200

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

4 2858

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


17 10281

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 4949

what is difference between having and where clause ?

3 3023

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

4 5435

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

10 11274

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

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


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?


Which is the best place or learning center for MS SQL?????In Bangladesh?????


query processing


Delete duplicate rows without using rowid.


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.


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


how to overcome kernel isssues


whats new about truncate in sql server 2008?


whats the maximum size of view state??


Any one plz send me SQL Server Developer/DBA resume for 4 years experience


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


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?


SQL Server Architecture ?