Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

What is a job?

3 4111

What are primary keys and foreign keys?

3 3613

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

3 8957

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

1 5252

How m-m relationships are implemented?

2 6669

How do you know which index a table is using?

4 9778

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

3 6162

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

2 7238

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

9 18988

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

Infosys,

4 8808

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

3 8203

Which virtual table does a trigger use?

TCS,

8 20743

How do you measure the performance of a stored procedure?

Infosys,

3 13515

Questions regarding Raiseerror?

1 5521

Questions on identity?

Infosys,

2 5159







Un-Answered Questions { SQL Server }

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

188


What are types of subqueries?

200


what information is maintained within the msdb database? : Sql server administration

199


what is the difference between a primary key and a unique key? : Sql server database administration

171


How to insert multiple rows with a subquery?

203






What is the data tier application?

99


what is a join? : Sql server database administration

181


What is normalization and denormalization in sql server?

211


Can the query output be sorted by multiple columns in ms sql server?

213


Explain a join?

225


What are security principals used in sql server 2005?

188


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1640


What is sql server used for?

209


What is query and its types?

160


What is isolation levels?

238