Follow Our FB Page << CircleMedia.in >> 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

HCL, IBM,

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 times.how 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?

133


Find columns used in stored procedure?

125


What is the difference between seek predicate and predicate?

138


What are the different types of data sources in ssrs?

39


What is table value parameters (tvp)?

139






Why transaction is important?

135


What are the properties of primary key?

99


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

19


Differentiate between ms sql server reporting services vs crystal reports?

113


Explain features and concepts of analysis services?

129


What is a trigger what are the advantages of trigger?

99


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

146


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

135


How to encrypt Strored Procedure in SQL SERVER?

165


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

148