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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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

For More Un-Answered { SQL Server } Questions Click Here