Saturday 15 February 2014

T- SQL Interview Questions and Answer

T- SQL Interview Questions and Answer

  1. Different type of statements in SQL?
  2. What's the use of INTO keyword in Select statement in SQL?
  3. How do you add a column in an already existing table in SQL?
  4. How to update a value in a column in SQL?
  5. Can you rename an object in SQL?
  6. What is identity in SQL and whats the use of it?
  7. How to reset an identity?
  8. Difference between having and where clause?
  9. What data types have you used to setup a table?
  10. Whats the different between nvarchar and varchar?
  11. Difference between delete and truncate command ?
  12. Difference between truncate and drop command?
  13. What are joins in sql and explain different types of Joins?
  14. Difference between Union and Union All?
  15. What are Indexes?
  16. Different Types of indexes?
  17. Difference between clustered and non - clustered indexes?
  18. What are Views in SQL?
  19. What is CTE in SQL?
  20. Difference between CTE and Views?
  21. What is temp table?
  22. What is temporary variable?
  23. Difference between temp table and temp variable?
  24. Difference between temp table and CTE?
  25. What is Sub-Query in SQL?
  26. What is Nested query in SQL?
  27. What is inline Query in SQL?
  28. What are ranking functions in SQL?
  29. Difference between Rank and Dense Rank?
  30. Which Ranking functions is used to delete duplicate rows from a table? 
  31. what is store procedure?
  32. what is UDF in SQL?
  33. difference between a store procedure and function in SQL?
  34. whats the use of NO COUNT?
  35. What is charindex function used for in SQL?
  36. What is substring function used for in SQL?
  37. What is coalesce function in SQL?
  38. difference between coalesce and ISNULL function?
  39. what is datediff function?
  40. what is dateadd function?
  41. explain functionality of Case function?
  42. how to use Case function in Select statement?
  43. Write a query to generate Running Total?
  44. Write a query to generate Running Average Values?
  45. What is BCP in SQL?







14 comments:

  1. In order to be irreplaceable one must always be different. See the link below for more info.


    #different
    www.ufgop.org

    ReplyDelete
  2. Hi There,


    You make learning and reading addictive. All eyes fixed on you. Thank you being such a good and trust worthy guide.


    I use Powerpivot every day with a lot of SQL Server queries, some of them pretty long or complex and I have never the following issue : I had to write a 1,500-row SQL Server query that works fine on my editor and when I run it in Powerpivot, I am getting either of the following messages :
    - "one or more formulas in this workbook are longer than the allowed limit of 8192 characters" : I tried to save the file in regular format or binary format but still can't save it.
    - after closing the Powerpivot back-end menu (via "Manage"), when I want to access it again, I get a ""Powerpivot is unable to load the Data Model" error message.
    There are no formula on the front-end of Excel, all the data resides in the back-end, so what does it mean? Is it counting the total characters in the SQL Server query itself?
    I couldn't find any specific support
    on this, is it due to the size of the SQL Server query? To specific tables inside the query? To some formatting that need to be done in the SQL query?

    By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).
    Please keep providing such valuable information.


    Ciao,
    Irene Hynes

    ReplyDelete
  3. All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates.
    Selenium testing training in chennai
    Selenium Courses in Chennai
    Selenium training Chennai
    Selenium Institutes in Bangalore
    Selenium Testing Institutes in Bangalore
    Selenium Testing Course in Bangalore


    ReplyDelete

  4. This is an excellent tip especially to those new to the blogosphere. Short however exact data… Thank you for sharing this one. An unquestionable requirement read post!


    best interiors

    ReplyDelete