1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

What are the triggers in sql?

 553

How to use “drop” keyword in sql server and give an example?

 681

What are the advantages of user-defined functions over stored procedures in sql server?

 457

Are null values the same as that of zero or a blank space?

 570

What is the temp table?

 541

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

 706

List some advantages and disadvantages of stored procedure?

 557

What factors you will consider calculating the storage requirement for that view?

 538

List out different types of normalizations in sql server and explain each of them?

 547

What are the different authentication modes in sql server? How can it be changed?

 565

What are the different types of locks in the database?

 486

Why use “pivot” in sql server?

 618

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

 845

What is built-in/administrator?

 572

What is the difference between a unique key and primary key?

 511

Un-Answered Questions { SQL Server }

Can you edit the .rdl code associated with a linked report?

109

Indexes are updated automatically is the full-text index also updated automatically?

619

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

618

What are trace flags and mention a few common trace flags used with sql server?

542

What is trigger and different types of Triggers?

568




Explain what is the difference between union and union all?

545

Name the different type of indexes in sql?

529

How to automatically create a log when an exception is being received into SQL Server?

731

What is Federation Root Database?

90

What is a trigger and its types?

524

Can I save my report as html, excel or word? : sql server management studio

541

What is a sql join?

570

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

1352

What is the difference between Stored Procedures and triggers?

569

Explain view in sql server?

615

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