SQL Server Interview Questions
Questions Answers Views Company eMail

syntax for deleting the database in T SQL

5 3734

How are SQL Server databases physically stored under Windows 2000?

1 2158

internal language used in sql server 2000?

2 1882

What types of integrity are enforced by a foreign-key constraint

1 2868

How do you find the error, how can you know the number of rows effected by last SQL statement?

1 2720

Which virtual table does a trigger use?

3 5734

Name three version of sql server 2000 and also their differences?

1 2177

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 7724

can you any body tell me which service pack is installed in the sql server?

3 2164

can you any body tell me the how to decrease the logfile

4 2812

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000


17 10127

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 4876

what is difference between having and where clause ?

3 2948

Accidentally i deleted my table. How can i get that table?

4 5368

how can i view structure of table in sql server? tell me that query.

10 11181

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

on line cluster can we make if yes tell me the procedure


Scalability, Availability, Integration with internet, etc.)?


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


how to do partition in sqlserver


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


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


Does any body please help me what question's have asked for SSRS in the interview?


query processing


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.


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.


What is data modeling and Reterminal integrity?


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


Call by value and call by reference in procedure and function, with NOCOPY.


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }