SQL Server Interview Questions
Questions Answers Views Company eMail

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

1 4106

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 5182

could u plz explain about joins and views?

2 2559

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

3 2734

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

1 4529

what is the sql equivaent of the dataset relation object ?


How To delete duplicate record from a particular table?

eXensys, Foxfire,

12 15774

What is the difference between Drop and Truncate

IBM, GT Nexus,

20 24302

Anyone please explain me the concept of Serialization?

3 2615

What is transaction ? Give me one example.

Wipro, Melstar,

11 18917

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

TCS, iGate,

7 7997

What is difference between TRUNCATE and DELETE statement


12 13538

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

2 2152

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


13 11724

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

What is Lock table in SQL?


what is isolation level at dead lock?


tell me the disaster recovery plan


How you trouble shoot when any job fails


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance


optimization techinques


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.


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.


query processing


Call by value and call by reference in procedure and function, with NOCOPY.


how can u get last observation in an unknown dataset ?


Working with TLogs


what is the Ticketing tool used in Wipro technologies at Bangalore...???


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions