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


SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

3 11801

What are functions

 3 9341

how to get the automatic backup of the database in the sql server

 4 34334

What command do we use to rename a db?

IBM,

5 11595

What are the four main query statements?

Wipro,

7 19492

Which command using Query Analyzer will give you the version of SQL server and operating system?

 3 14674

What is the STUFF function and how does it differ from the REPLACE function?

 2 19258

What is SQL server agent?

HCL, SAP Labs,

2 8406

What is the purpose of UPDATE STATISTICS?

 2 12011

What is de-normalization and when do you do it?

 3 7412

Difference between Function and Stored Procedure?

C1 India, NA,

9 18935

What is data integrity? Explain constraints?

Thinksoft,

1 24917

Explain some DBCC commands?

 6 17776

What are tasks?

Wipro,

3 11029

What is the purpose of using COLLATE in a query?

 1 17850

Un-Answered Questions { SQL Server }

What is the recommended total size of your memory optimized tables?

519

How do you use a subquery to find records that exist in one table and do not exist in another?

540

What are sub reports?

149

What is the difference between functions and stored procedures?

610

How many levels of sp nesting is possible?

575




What is the difference between having clause and where clause in sql server?

564

How to create an identity column?

628

How to disable a login name in ms sql server?

581

You want to use a perspective in an mdx query. How do you select the perspective?

157

What is sql server english query?

533

Explain left outer join and right outer join?

546

How many ways to create table-valued functions?

571

What is primary key, unique key, and foreign key?

529

What is difference between joins and subqueries?

527

How can we get count of the number of records in a table?

535

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