1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category
SQL Server Interview Questions
Questions Answers Views Company eMail

syntax for deleting the database in T SQL

 5 3913

How are SQL Server databases physically stored under Windows 2000?

 1 2262

internal language used in sql server 2000?

 2 2009



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

1 3011

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

 1 2841

Which virtual table does a trigger use?

 3 5903

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

 1 2287

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 7853



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

 3 2290

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

 4 2956

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

IBM, HCL,

17 10555

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 5074

what is difference between having and where clause ?

 3 3114

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

 4 5544

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

 10 11409

Post New SQL Server Questions






Un-Answered Questions { SQL Server }

role of sql sever 2005 in database rather than any other database

883

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

936

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., }

1062

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

904

If user is owning any SQL Objects, can we drop that user

853




what are the critical issues you have resloved in your company

823

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

1648

SQL Server Architecture ?

1133

optimization techinques

1330

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

940

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

949

how to do partition in sqlserver

1305

Issues related in upgrading SQL Server 2000 to 2005 / 2008

768

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

671

application server is slow what may be the problem

1084

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