SQL Server Interview Questions

Recently Posted

Job Title

1

Answer

Interview Questions.One of the Interview I have faced I was give a query to write,here is the tableId Value 1 10 1 0 2 12 2 12 3 0 4 0I was asked to find the total number of consumed and unconsumed ids,following is the output tableId Consumed Unconsumed 1 1 1 2 2 0 3 0 1 4 0 1 As we can see consider Id 1 in the output table it has value 1 for consumed column and 1 for unconsumed column,because total number of Ids with value 1 are 2 and one id with value 1 has value greater than 0 and second one has value equal to 0 in the input table.so the conditon is consumed ids are ids whose value is greater than 0 and unconsumed ids are ids whose value is equal to zero.i was asked to write query to generate the following output,I have found many difficulties and was not able to solve during the interview.the interviewer gav

Aniket Narvankar
9y Reply
3

Answers

What is types of functions are in SQL Server?

Sujeet Suman
9y Reply
3

Answers

What is the difference between Delete and a Truncate ?

Ajeet Mishra
9y Reply
2

Answers

What is a NATURAL JOIN in SQL?

Ajeet Mishra
9y Reply
4

Answers

What is a SELF JOIN in SQL ?

Ajeet Mishra
9y Reply
3

Answers

What is a CROSS JOIN in SQL?

Ajeet Mishra
9y Reply
2

Answers

What is an EQUI JOIN in SQL?

Ajeet Mishra
9y Reply
2

Answers

What is a FULL OUTER JOIN in SQL?

Ajeet Mishra
9y Reply
2

Answers

What is a RIGHT OUTER JOIN in SQL?

Ajeet Mishra
9y Reply
2

Answers

What is a LEFT OUTER JOIN in SQL?

Ajeet Mishra
9y Reply
4

Answers

What is an Identity ?

Ajeet Mishra
9y Reply
2

Answers

What are the steps to Create Cursor in SQL Server ?

Ajeet Mishra
9y Reply
2

Answers

What are the DisAdvantages of User Defined Functions?

Ajeet Mishra
9y Reply
2

Answers

What are the Advantages of User Defined Functions?

Ajeet Mishra
9y Reply
1

Answer

What is a User Defined Functions in SQL Server?

Ajeet Mishra
9y Reply

4
5
6
7
8

76 - 90 of 111