SQL Server Interview Questions
Questions Answers Views Company eMail

Why we need a group by clause?

4 6621

What is a join and their types?

Challenger Financial,

2 5019

What is the difference between referencing and joining?

1 2264




What is the difference between constraints and triggers?

Wipro,

9 25057

What is ACID Property of Transaction?

10 29848

What is an index?

Yardi Software,

8 9717

What is normalization and its forms?

Challenger Financial,

4 10321

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

8 13663




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

11 45611

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

3 3653

What are the magic tables in SQL Server 2000?

Merrill Lynch, Infogain,

7 19951

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

13 43065

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

Infosys, HCL, TCS, College School Exams Tests,

25 96348

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 3727

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

2 8960


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

last function used in MS Access to convert sql what function will use in sql

853


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

883


Why do you want to join software field as you have done your BE in Electronics?

1024


how many no of arguments can be passed in procedures and functions

3493


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1040






what are the Prerequisites for Replication?

8457


which backup strategy you are following at ur company

993


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1103


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.

1618


application server is slow what may be the problem

1084


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

671


what is package and it uses and how can u call a package

886


How much memory that we are using in Logshipping Concept?

705


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

864


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

811