SQL Server Interview Questions
Questions Answers Views Company eMail

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

1 4219

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

804

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

Millennium,

2 5337




could u plz explain about joins and views?

2 2698

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

3 2902

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

1 4678

what is the sql equivaent of the dataset relation object ?

918

How To delete duplicate record from a particular table?

eXensys, Foxfire,

12 16420




What is the difference between Drop and Truncate

IBM, GT Nexus,

20 24882

Anyone please explain me the concept of Serialization?

3 2806

What is transaction ? Give me one example.

Wipro, Melstar,

11 19655

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

TCS, iGate,

7 8368

What is difference between TRUNCATE and DELETE statement

CTS,

12 14164

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

2 2265

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

Patni,

13 12258


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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.

783


System variable and temporary variables

1064


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2762


If we delete pack Spec what will be the status of pack Body ?

264


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.

757






How do you Implement SSIS Packages in your Project?

911


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1390


role of sql sever 2005 in database rather than any other database

949


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

688


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?

1343


SQL Server Architecture ?

1217


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

958


How much memory that we are using in Logshipping Concept?

786


plss anybody specify tha constrian management system in dbms

899


wat wil hapn if we give the both read and deny read permission to user?

1041