SQL Server Interview Questions
Questions Answers Views Company eMail

Why we need a group by clause?

4 6524

What is a join and their types?

Challenger Financial,

2 4935

What is the difference between referencing and joining?

1 2183

What is the difference between constraints and triggers?


9 24548

What is ACID Property of Transaction?

10 29620

What is an index?

Yardi Software,

8 9552

What is normalization and its forms?

Challenger Financial,

4 10166

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

8 13523

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

11 45425

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

3 3542

What are the magic tables in SQL Server 2000?

Merrill Lynch, Infogain,

7 19784

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

13 42755

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

Infosys, HCL, TCS, College School Exams Tests,

25 95893

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 3641

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

2 8854

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.


Call by value and call by reference in procedure and function, with NOCOPY.


SQL Server Architecture ?


role of sql sever 2005 in database rather than any other database


how to use DTS package in 2000,2005,2008 in sql server


Working with TLogs


what is the sql equivaent of the dataset relation object ?


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you


How do use Having,Group by,Group function in SQL?


optimization techinques


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?


What is Lock table in SQL?


Delete duplicate rows without using rowid.


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?