1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category
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

For More Un-Answered { SQL Server } Questions Click Here