SQL SERVER 2000 INTERVIEW QUES Database Interview Questions [95 Questions]

  1. Fetching records from attributesHow will you fetch records having underscore ( _ ) in the middle of of strings, from columns having attributes as "amit_6", "t_mit06", "am_06", "m_t", "j_x_t" ?
  2. Table Name AliasWhy do we use alias for the table name? What is its importance?
  3. Data BlockWrite an SQL query if you want to select the data from one block which intern reflects in another block?
  4. After triggerIs there any reason for which we cannot use After trigger with a view?
  5. What is the difference between windows authentication and sql server authentication
  6. You must first Login or Register to view all 95 questions from this category.

    Registering yourself is FREE, takes just less than a minute and opens up a whole new GetGyan experience.