SQL Server Interview Questions
Questions Answers Views Company eMail

What is a NOLOCK?

3 17393

How do SQL server 2000 and XML linked?

2 6159

What is the difference between HAVING clause and the WHERE clause?

7 11980




Explain what are db_options used for?

InterGraph,

1 7397

how to know description of a table in sqlserver 2000

8 6268

plz send every query in sql server2000

Infosys,

1 3452

How to Execute an Operating System Command From Within SQL Server ?

3 5723

How can I create a plain-text flat file from SQL Server as input to another application?

2 9038




Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

Infosys,

3 6695

The Difference between 'Count' and 'Count(*)'

13 17469

How do I list the available tables in a database I'm querying?

4 4048

How to count the number of duplicate items in a table?

3 5688

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 3258

How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?

GE,

1 3507

Is it possible to create tables in stored procedures using a variable for the table name?

2 3364


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

1021


You are doing log shipping due to some reasons it is failing. How you will proceed from there

899


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

251


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

673


your distribution database is full what will u do

1033






Which is the best place or learning center for MS SQL?????In Bangladesh?????

946


Why do you want to join software field as you have done your BE in Electronics?

1092


application server is slow what may be the problem

1151


What is the difference between online clustering and Offline clustering?

1286


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

874


Delete duplicate rows without using rowid.

266


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1319


If user is owning any SQL Objects, can we drop that user

919


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

379


SQL Server Architecture ?

1205