Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

SQL Server Interview Questions
Questions Answers Views Company eMail

syntax for deleting the database in T SQL

5 4742

How are SQL Server databases physically stored under Windows 2000?

1 2659

internal language used in sql server 2000?

2 2542

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

1 3414

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

1 3228

Which virtual table does a trigger use?

3 6461

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

1 2630

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 8245

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

3 2804

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

4 3561

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 12797

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 to select the repeated values only.i.e 3,5,6 should alone come.

3 5679

what is difference between having and where clause ?

3 3642

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

4 6325

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

10 12808

Un-Answered Questions { SQL Server }

What are statistics?


Find columns used in stored procedure?


What is the difference between seek predicate and predicate?


What are the different types of data sources in ssrs?


What is table value parameters (tvp)?


Why transaction is important?


What are the properties of primary key?


Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?


Differentiate between ms sql server reporting services vs crystal reports?


Explain features and concepts of analysis services?


What is a trigger what are the advantages of trigger?


What is a trace frag? Where do we use it?


What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?


How to encrypt Strored Procedure in SQL SERVER?


What is temporary table in sql server? Why we use temp table?