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


SQL Server Interview Questions
Questions Answers Views Company eMail

What is a job?

 3 5129

What are primary keys and foreign keys?

 3 4544

How would you Update the rows which are divisible by 10, given a set of numbers in column?

 3 10288

If a stored procedure is taking a table data type, how it looks?

 1 5794

How m-m relationships are implemented?

 2 7399

How do you know which index a table is using?

 4 11166

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

 3 7195

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

 2 8045

How can you get @@error and @@rowcount at the same time?

 9 21698

What are sub-queries? Give example? In which case sub-queries are not feasible?

Infosys,

4 10262

What are the type of joins? When do we use Outer and Self joins?

 3 9079

Which virtual table does a trigger use?

TCS,

8 24633

How do you measure the performance of a stored procedure?

Infosys,

3 14762

Questions regarding Raiseerror?

 1 6142

Questions on identity?

Infosys,

2 6040

Un-Answered Questions { SQL Server }

Explain acid?

599

What are “phantom rows”?

1235

What is the difference between osql and query analyzer?

539

What is SQL Azure Firewall?

116

Explain about sql server login?

585




How to get a list of columns using the "sp_help" stored procedure in ms sql server?

578

What is the difference between stored procedure and user defined functions?

613

What are the differences between union, intersect, and minus operators?

564

What is the current limitation of the size of SQL Azure DB?

102

What is self contained scalar sub query?

526

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

571

What do you know about normalization and de- normalization?

462

How each E-R model constructs can be mapped to the relational model?

547

What is a result set object returned by odbc_exec()?

542

What are “unrepeatable reads”?

732

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