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 6564

How are SQL Server databases physically stored under Windows 2000?

 1 3473

internal language used in sql server 2000?

 2 3553

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

1 4054

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

 1 3852

Which virtual table does a trigger use?

 3 7479

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

 1 3285

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 8902

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

 3 3841

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

 4 4805

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

HCL, IBM,

17 16922

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 6704

what is difference between having and where clause ?

 3 4586

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

 4 7726

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

 10 15526

Un-Answered Questions { SQL Server }

Comment,Datatypes are unlimited

1620

What is difference between sql and sql server?

535

Is ssrs support other database except ms sql server?

96

What are click through reports?

99

Explain a differential backup?

566




What is exporting utility?

535

is it important for a database administrator to understand the operating system and file access? : Sql server administration

577

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

559

What is tempdb database? : SQL Server Architecture

591

What are the types of database schema? : sql server analysis services, ssas

596

How to drop an existing user defined function in ms sql server?

556

How to create function with parameter in sql server?

545

What is a bit datatype?

554

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

100

What is dknf in normalization form?

550

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