SQL Server Interview Questions

Recently Posted

Job Title

3

Answers

How many records will be there in the result set of a CROSS JOIN?

Rajanikant Hawaldar
4y Reply
3

Answers

Which SQL JOIN can be applied if there is no relationship between the two tables?

Rajanikant Hawaldar
4y Reply
2

Answers

Can you give me a real-time scenario where you have applied CROSS JOIN in your project?

Rajanikant Hawaldar
4y Reply
1

Answer

Will null evaluate with null(null = null)

Vinay Talapaneni
4y Reply
1

Answer

What would be the first step to take when troubleshooting a slow query?

Cristopher Coronado
4y Reply
1

Answer

How many update commands we need to issue to update data in related tables?

Govardhan P
5y Reply
1

Answer

Differences between local and global temporary tables?

Naresh Beniwal
5y Reply
1

Answer

what is the difference between putting condition after join and where condition in sql

Venkat Mungari
5y Reply
6

Answers

How to insert ONLY HEADER of one table into another table?

Rohit Kainth
6y Reply
3

Answers

How to find and remove duplicates from a table?

Rohit Kainth
6y Reply
8

Answers

Differenciate between Truncate and Delete.

Rohit Kainth
6y Reply
1

Answer

Write down the names of DMVs to find long running queries or stored procedures.

Rohit Kainth
6y Reply
4

Answers

A product table has a record of product. Table has only one record and this product accessing three user.First user has purchased product then how restrict second use to update that record.

Lalit Raghav
6y Reply
1

Answer

Where does Temporary table and Table variables get stored in SQL db?

Ankit Tyagi
6y Reply
3

Answers

Why not we should prefix stored procedure names with “sp_”?

Santosh Kumar Adidawarpu
7y Reply

31 - 45 of 130

How many records will be there in the result set of a CROSS JOIN?

Which SQL JOIN can be applied if there is no relationship between the two tables?

Can you give me a real-time scenario where you have applied CROSS JOIN in your project?

Will null evaluate with null(null = null)

What would be the first step to take when troubleshooting a slow query?

How many update commands we need to issue to update data in related tables?

Differences between local and global temporary tables?

what is the difference between putting condition after join and where condition in sql

How to insert ONLY HEADER of one table into another table?

How to find and remove duplicates from a table?

Differenciate between Truncate and Delete.

Write down the names of DMVs to find long running queries or stored procedures.

A product table has a record of product. Table has only one record and this product accessing three user.First user has purchased product then how restrict second use to update that record.

Where does Temporary table and Table variables get stored in SQL db?

Why not we should prefix stored procedure names with “sp_”?