SQL Server Interview Questions
Questions Answers Views Company eMail

What is a NOLOCK?

3 17178

How do SQL server 2000 and XML linked?

2 6008

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

7 11840




Explain what are db_options used for?

InterGraph,

1 7238

how to know description of a table in sqlserver 2000

8 6081

plz send every query in sql server2000

Infosys,

1 3318

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

3 5591

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

2 8910




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

Infosys,

3 6491

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

13 17099

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

4 3875

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

3 5503

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 3137

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 3420

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

2 3225


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

810


How do use Having,Group by,Group function in SQL?

671


can any body tell me how to know the password of current user in sql server

919


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

940


How do you Implement SSIS Packages in your Project?

834






What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1578


which backup strategy you are following at ur company

993


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4769


how to do partition in sqlserver

1304


sql database suspect We have a sql database that is showing as suspect. How can we recover?

710


How to convert a table data in XML format in sql server?

1399


application server is slow what may be the problem

1084


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2676


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

714


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.

1263