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.

671

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

Millennium,

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 ?

826

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

CTS,

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;

Patni,

13 11724


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is Lock table in SQL?

246


what is isolation level at dead lock?

999


tell me the disaster recovery plan

1273


How you trouble shoot when any job fails

674


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

1131






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

864


optimization techinques

1306


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.

1334


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.

648


query processing

991


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

134


how can u get last observation in an unknown dataset ?

1124


Working with TLogs

675


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

4961


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

864