SQL Server Interview Questions
Questions Answers Views Company eMail

what is the disadvantage of SQL Loder?

TCS,

1 4334

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

TCS,

7 6067

what is difference between Enterprise Manager and Query Analyer

CTS,

6 4749




WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

Synergy,

1 4563

what is DTS what are tasks available

Wipro,

1 2005

Normalization and denormalization

Wipro,

3 3614

Diffrent types of function

Wipro,

1 2448

diffrence between function and procedure

Wipro,

4 3355




diffrence between Cluster Index and non Cluster Index

Wipro,

3 3325

System variable and temporary variables

Wipro,

1015

optimization techinques

Wipro,

1388

user defined datatypes

Wipro,

1 2826

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

852

Magic Tables ?

Thomson Reuters,

2 3584

Diffrences between sql server 2000 vs 2005

Thomson Reuters,

2 2805


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what are the Prerequisites for Replication?

8605


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

1088


How to trouble shoot if unable to connect SQL Server

810


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

973


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.

701






What is the difference between NOROW and LOCKROW?

1340


how can u get last observation in an unknown dataset ?

1192


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4826


What is data modeling and Reterminal integrity?

704


How much memory that we are using in Logshipping Concept?

749


what is checksum in sql server.........???

432


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

1148


Comment,Datatypes are unlimited

958


your distribution database is full what will u do

995


how to take backup bcp out for a column in table in sql server?

886