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.


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


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 ?


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


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;


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.


System variable and temporary variables


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.


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


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.


How do you Implement SSIS Packages in your Project?


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


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


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


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?


SQL Server Architecture ?


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?


How much memory that we are using in Logshipping Concept?


plss anybody specify tha constrian management system in dbms


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