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?


1 7397

how to know description of a table in sqlserver 2000

8 6268

plz send every query in sql server2000


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?


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?


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?


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


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


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


your distribution database is full what will u do


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


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


application server is slow what may be the problem


What is the difference between online clustering and Offline clustering?


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


Delete duplicate rows without using rowid.


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.


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


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


SQL Server Architecture ?