SQL Server Interview Questions
Questions Answers Views Company eMail

What is a NOLOCK?

NA,

3 19296

How do SQL server 2000 and XML linked?

2 7418

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

7 14363

Explain what are db_options used for?

InterGraph,

1 8713

how to know description of a table in sqlserver 2000

8 8989

plz send every query in sql server2000

Infosys,

1 4820

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

3 7314

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

2 10414

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

Infosys,

3 8670

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

13 24853

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

4 5929

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

3 7451

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 4484

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 4528

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

2 4650


Un-Answered Questions { SQL Server }

What options are available to audit login activity? : sql server security

601


How to get the definition of a stored procedure back?

507


What is the difference between the application object and session object?

571


What are the pre-defined functions in the sql server?

499


Where is trigger in sql server?

520






If the job running very slow what is the action you do

1405


What are the different methods available under sqlcommand class to access the data?

664


Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

610


What is factless fact table? : sql server analysis services, ssas

538


How can I add Reporting Services reports to my application?

91


Explain data warehousing in sql server?

584


How to Insert multiple rows with a single insert statement?

531


What is the difference between the 2 operating modes of database mirroring?

552


What are recommended options to be used while using db mirroring? : sql server database administration

546


Find columns used in stored procedure?

511