SQL Server Interview Questions
Questions Answers Views Company eMail

What is a NOLOCK?

3 17064

How do SQL server 2000 and XML linked?

2 5946

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

7 11770




Explain what are db_options used for?

InterGraph,

1 7152

how to know description of a table in sqlserver 2000

8 5960

plz send every query in sql server2000

Infosys,

1 3245

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

3 5535

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

2 8865




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

Infosys,

3 6387

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

13 16964

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

4 3810

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

3 5447

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 3093

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 3370

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

2 3165


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

628


If a stored procedure is taking a table data type, how it looks?

4588


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

848


What is RMS migrations?

922


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

826






You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1019


what is package and it uses and how can u call a package

851


your distribution database is full what will u do

927


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

852


Issues related in upgrading SQL Server 2000 to 2005 / 2008

740


Delete duplicate rows without using rowid.

156


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1321


How retrieve field names from the table in SQL through JAVA code?

672


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

790


Why we need to use secondry database file? though, we can do same work using primary database file also.

4175