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 19375

How do SQL server 2000 and XML linked?

 2 7476

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

 7 14460

Explain what are db_options used for?

InterGraph,

1 8754

how to know description of a table in sqlserver 2000

8 9110

plz send every query in sql server2000

Infosys,

1 4875

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

 3 7384

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

 2 10470

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

Infosys,

3 8773

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

 13 25054

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

 4 6013

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

 3 7512

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 4543

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 4576

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

 2 4697

Un-Answered Questions { SQL Server }

How to define and use table alias names in ms sql server?

565

Ms sql server index?

546

What is the purpose of sql profiler in sql server?

519

How do you size a resultset?

504

What causes index fragmentation?

584




What are the source of constraints?

512

How to achieve Paging of records in SQL SERVER?

594

Can truncate be rolled back?

547

Which table keeps the locking information?

530

What do you mean by tablesample?

643

Can group by be used without aggregate functions?

485

How to execute stored procedure in select statement sql server?

539

Mention the uses of stored procedures.

575

What are the difference between “where” and “having” clause in sql server?

589

Explain relational data?

552

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