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?

Wipro,

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.

1524


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

99


SQL Server Architecture ?

1080


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

834


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

733






Working with TLogs

640


what is the sql equivaent of the dataset relation object ?

792


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

530


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

622


optimization techinques

1236


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

1192


What is Lock table in SQL?

199


Delete duplicate rows without using rowid.

135


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., }

1019


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

2579