SQL Server Interview Questions
Questions Answers Views Company eMail

What is a NOLOCK?

NA,

3 19354

How do SQL server 2000 and XML linked?

2 7458

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

7 14442

Explain what are db_options used for?

InterGraph,

1 8740

how to know description of a table in sqlserver 2000

8 9079

plz send every query in sql server2000

Infosys,

1 4855

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

3 7368

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

2 10458

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

Infosys,

3 8749

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

13 25013

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

4 5992

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

3 7500

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 4528

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 4561

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

2 4685


Un-Answered Questions { SQL Server }

Are null values the same as that of zero or a blank space?

574


What is a partition key?

520


What is log in sql server?

589


What is the difference between varchar and varchar types?

562


What are the database objects? : SQL Server Architecture

551






Which command is used for user defined error messages?

559


What are the approximate numeric data types?

531


What stored by the master? : sql server database administration

575


How to create database with physical files specified in ms sql server?

539


What is the purpose of forms?

493


What is side by side migration in sql server?

532


What is page-level compression?

551


How to connect ms access to sql servers through odbc?

545


Can you type more than one query in the query editor screen at the same time?

572


What are indexes in sql?

575