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

IBM, HCL,

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?

670


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

768


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

828


query processing

956


Delete duplicate rows without using rowid.

135






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?)

669


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.

315


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

264


how to overcome kernel isssues

435


whats new about truncate in sql server 2008?

1255


whats the maximum size of view state??

892


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

1450


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

131


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?

908


SQL Server Architecture ?

1080