1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

What is a NOLOCK?

NA,

3 19356

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 8742

how to know description of a table in sqlserver 2000

8 9086

plz send every query in sql server2000

Infosys,

1 4860

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

 3 7371

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

 2 10459

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

Infosys,

3 8754

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

 13 25016

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

 4 5994

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

 3 7504

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 4563

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

 2 4689

Un-Answered Questions { SQL Server }

What happens when transaction log is full?

513

Explain about link server in sql server?

533

Who is the owner of a schema in ms sql server?

544

Explain the difference between primary keys and foreign keys?

509

Explain the use of keyword with encryption. Create a store procedure with encryption?

539




Explain what is log shipping?

578

What is faster join or union?

597

How do I run sql server 2014?

506

Will sql server 2005 allow you to reduce the size of a column?

550

What are scalar functions?

504

What is the difference between char, varchar and nvarchar?

570

What are the dis_advantages of stored procedures, triggers, indexes?

1686

What does indexation mean?

529

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

481

what is hash nonclustered index

535

For More Un-Answered { SQL Server } Questions Click Here