Sharing Couple of T SQL Questions frequently asked in microsoft interviews:
1. What is the difference between SP and Functions?
2. Can we call SP from Function?
3. Can we write Functions in SP?
4. Given a scenario to define ER Model for the scenario like “A College is organizing a Band”.
5. Prepare the necessary Model with required attributes.
7. What is synonym & why we use synonym?
8. What is 'linked server' & use of 'linked server'?
9. Can we modify the table data after using the views for that table?
Tags: T SQL Interview Questions and Answers At Microsoft, Microsoft, Interview Questions and Answers At Microsoft, T SQL, T SQL Interview Questions, T SQL QA, T SQL Interview Questions and Answers, T SQL Tutorial, T SQL books, T SQL Interview Questions pdf, T SQL experienced QA, interview questions, T SQL interview questions for experienced, T SQL interview questions for developers,T SQL interview questions for freshers,T SQL interview questions senior level, T SQL Certification Questions, Basic T SQL interview questions, T SQL interview questions 2 3 4 5 6 years experienced, T SQL Real time interview questions, T SQL Interview Questions and Answers At Microsoft 2015, Latest T SQL Questions At Microsoft Interview.
1. What is the difference between SP and Functions?
2. Can we call SP from Function?
3. Can we write Functions in SP?
4. Given a scenario to define ER Model for the scenario like “A College is organizing a Band”.
5. Prepare the necessary Model with required attributes.
6. How we can access the server 2 table data from sever 1?
7. What is synonym & why we use synonym?
8. What is 'linked server' & use of 'linked server'?
9. Can we modify the table data after using the views for that table?
10. Write a query to find the duplicate values & its count?
11. What is view & why we use views?
12. Write a query to find the all Employee names having 'ANZ SQL’?
13. How to create the dummy table?
14. After data loading, what will you test?
11. What is view & why we use views?
13. How to create the dummy table?
14. After data loading, what will you test?
15. What are transactions?