SQL Server Interview Questions
Questions Answers Views Company eMail

What is the difference between cross join and Full outer join?

Standard Bank, HP,

1 5438

What are indexes? When do you need to create Indexes?

HP, CarrizalSoft Technologies,

4 4162

In which situation you use Self joins?

HP, CarrizalSoft Technologies, TCS,

1 5207




Describe about first three Normal forms.

HP,

1 4312

Write the Syntax for Cursors.

HP, CarrizalSoft Technologies,

2 3682

How to avoid cursors?

HP, CarrizalSoft Technologies,

3 5121

What are the various Isolation levels?

HP,

2 8166

wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

TCS, Wipro,

2 3705




wat is mean by normalization?......programing defination i need...(i know basic defination)

Wipro,

4 5038

If we use where clause in the left outer join then how the query would behave/act?

1 2295

write sql program to get the detail of student in a class?

2 6427

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

Infosys, Cognizant,

10 11133

What is Pointer ?

Cap Gemini, CarrizalSoft Technologies,

3 3317

what is call by value & call by reference ?

Cap Gemini,

2 10156

What is trigger ?

Cap Gemini, SQL,

7 5465


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is data modeling and Reterminal integrity?

619


can any body tell me how to know the password of current user in sql server

878


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

1047


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

876


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

734






Delete duplicate rows without using rowid.

135


Which is the best place or learning center for MS SQL?????In Bangladesh?????

829


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


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

264


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

998


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?

817


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1251


where the connection string store in the database

758


what are the Prerequisites for Replication?

8233


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

605