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

SQL Server Interview Questions
Questions Answers Views Company eMail

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 5687

Which command displays the SQL command in the SQL buffer, and then executes it?


3 10229

Which system tables contain information on privileges granted and privileges obtained

1 5815

Which system table contains information on constraints on all the tables created?

2 5642

what command is used to create a table by copying the structure of another table?

7 10702

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 7946

What is the use of CASCADE CONSTRAINTS?

3 8818

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

Crown Solutions,


What are the type of Indexes? which one is best, why?

6 6483

How to work on DTS?what is the main requirement?

Getit, ivan,

1 3812

I have student marks in a student table. I need second highest mark .Then what will the query for this?

NetCore, Patni, SAP Labs, Temenos, Wipro,

34 46631

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 140038

About types of indexes in SQL server ?


2 5759

Difference between writing SQL query and stored procedure ?

Cognizant, Infosys, TCS, Veritas,

15 66917

About DTS usage ?

Cognizant, Wipro,

2 6022

Un-Answered Questions { SQL Server }

Explain the relational database management system (rdbms)?


List all types of constraints in sql server?


Write query to return all rows sql?


Can an entity have two primary keys?


Explain difference between cross join and full outer join?


What are the different SQL Server Versions you have worked on?


Do you know what are different types of replication in sql server?


how can u get last observation in an unknown dataset ?


What are magic tables in sql server?


Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security


What is create statement?


How do I run sql server 2014?


What are the different normalization forms?


Can I disable or restrict ssrs export formats (rendering formats)?


When should you use an instead of trigger?