SQL Server Interview Questions
Questions Answers Views Company eMail

What is INTVAL( )and where we use Plz any body help me

1 4005

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.


What is the difference between a stored procedure and a user defined function in sql server?


2 5070

could u plz explain about joins and views?

2 2436

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 2627

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 4440

what is the sql equivaent of the dataset relation object ?


How To delete duplicate record from a particular table?

eXensys, Foxfire,

12 15257

What is the difference between Drop and Truncate

IBM, GT Nexus,

20 23908

Anyone please explain me the concept of Serialization?

3 2515

What is transaction ? Give me one example.

Wipro, Melstar,

11 18388

UPDATE statement can on a single table or on the multiple table?

TCS, iGate,

7 7736

What is difference between TRUNCATE and DELETE statement


12 13103

can any one please send sql quries most used in applications.

2 2079

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;


13 11405

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

What is the difference between online clustering and Offline clustering?


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?


Does any body please help me what question's have asked for SSRS in the interview?


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


what are the Prerequisites for Replication?


SQL Server Architecture ?


How to trouble shoot if unable to connect SQL Server


Working with TLogs


How can we call UDF(User Define Function) using C# code in ASP.net ?


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.


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?


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


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


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


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .