SQL Server Interview Questions
Questions Answers Views Company eMail

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

Aviva,

1 1784

how to generate XML out of QUERY?

McAfee,

1 3387

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

Infosys, McAfee,

5 6562




How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

Intelenet,

8 26084

hi i gone though satyam interview. what is Acid Properties?

Satyam,

2 3632

what are batch in sql server?

Satyam,

2 7133

Difference Between varchar and nvarchar datatype?

Satyam,

3 11012

Difference between sql server 2000 and sql server 2005?

NIIT, GE, IBM, HCL, Satyam, Aditi Tech, eInfochips, Masim Infotech, Systems Domain,

11 45159




what is normalization? what is denormalization?

Satyam,

9 28412

what is extended StoreProcedure ?

Satyam,

3 3715

Different Types of Functions ?

Satyam,

2 10541

CLR Integration ? what is Notification services ?

HCL, Satyam,

1 3420

what is replication? where do u use Go Keyword?

Satyam,

1 3146

how do u do Performance tunning ?

Satyam, Infodat Technologies,

1 3504

How to find the date and time of last updated table?

3 6248


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

853


How retrieve field names from the table in SQL through JAVA code?

772


System variable and temporary variables

1051


What is best institute to Learn DotNET And SQL in chennai?

1042


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

937






whats new about truncate in sql server 2008?

1385


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1319


plss anybody specify tha constrian management system in dbms

885


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

1182


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1331


what is the sql equivaent of the dataset relation object ?

905


If the job running very slow what is the action you do

780


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1582


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

771


on line cluster can we make if yes tell me the procedure

911