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

SQL Server Interview Questions
Questions Answers Views Company eMail

Why we need a group by clause?

4 7304

What is a join and their types?

Challenger Financial,

2 5611

What is the difference between referencing and joining?

1 2720

What is the difference between constraints and triggers?


9 29078

What is ACID Property of Transaction?

10 32249

What is an index?

Yardi Software,

8 11040

What is normalization and its forms?

Challenger Financial,

4 11319

What is a cursor in SQL Server 2000 and their types?

8 14755

How do we get month name in SQL Server 2000, Oracle, MS Access?

11 47758

How do we return a record set from a Stored Procedure in SQl server 2000?

3 4365

What are the magic tables in SQL Server 2000?

Infogain, Merrill Lynch,

7 21245

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 45658

What are the differences between stored procedure and functions in SQL Server 2000?

College School Exams Tests, HCL, Infosys, TCS,

25 100304

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 4402

Which is best Subquery (or) joins in sql server? explain why

2 9505

Un-Answered Questions { SQL Server }

What is the difference between varchar and nvarchar?


What stored by the msdb? : sql server database administration


How to use column default values in insert statements in ms sql server?


How to drop existing indexes in ms sql server?


What are difference between Cluster index and Non-Cluster index?


How to create an index on an existing table in ms sql server?


What is conditional split?


Why use triggers?


Define inner join in sql server joins?


How to disable triggers using "disable trigger"?


How to create a user to access a database in ms sql server using "create user" statements?


You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?


What is an sql server agent?


Is it possible to call a stored procedure within a stored procedure?


Explain the use of containers in ssis?