Journey to SQL Authority with Pinal Dave

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Constraint and Keys, SQL Cursor, SQL Data Storage, SQL DateTime, SQL Documentation, SQL Download, SQL Error Messages, SQL Function, SQL Index, SQL Interview Questions and Answers, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Server DBCC, SQL Stored Procedure, SQL Tips and Tricks, SQL Trigger, SQL Utility, SQLAuthority, T SQL, Technology | Tagged SQL XML | 21 Comments

21 Responses to “SQL SERVER - 2008 - Interview Questions and Answers Complete List Download”

1. on September 22, 2008 at 7:49 pm Jerry Hung

   Well done, it must took you a good while to write these questions for the greater good

   I was wondering when the interview articles will finish, so I can print them double-sided

   now with the PDF, problem solved.

   Many thanks Pinal, from Canada

   
   
2. on September 22, 2008 at 9:46 pm pinaldave

   Jerry Hung,

   You are welcome.

   Regards,
   Pinal Dave

   
   
3. on September 23, 2008 at 5:35 pm Sumit

   Hi Pinal ,
   i want to know how to Insert Excel file in binary format in perticular one Collum of sql Table.

   
   
4. on September 25, 2008 at 10:05 pm Shveta

   I have to design a script which would go thru the DB and extract a flat file of each pertinent table’s data(1 file/table).I have used DTS to export data from databases.I have never written a script for extraction.Could you please guide me on this and help me in getting started on how to write a script with a small example.Could you also please help me on how to run the script against the database so that it could generate a data file

   Do u usually reply to their email or post solutions here?

   Thanks

   Shveta

   
   
5. on September 26, 2008 at 3:38 pm Pramila

   Hi Pinal,

   Greatest work..Thanks a ton..You have made concepts clear to me..

   Pramila

   
   
6. on September 30, 2008 at 9:17 am baig

   hi Pinal,

   thanks a lot,……i think no book will give as much wealthy knowledge as your website gives…..this is the real place to learn a lot and that too your examples are amazing…..easy to understand and learn……..thanks a lot.

   
   
7. on October 13, 2008 at 12:25 pm karan

   Dear
   pinal
   I am looking forward to change . so for that i need sql server 2005 question and answer

   regards
   karan

   
   
8. on October 14, 2008 at 2:36 pm Swati

   My SQL statements are:

   CREATE TABLE doc_exe ( column_a INT CONSTRAINT column_a_un UNIQUE)
   GO

   ALTER TABLE doc_exe
   alter column column_a int identity(1,1)

   I get the error:

   Msg 156, Level 15, State 1, Line 2
   Incorrect syntax near the keyword ‘identity’.

   Please explain or correct the sytax.

   Thanx

   
   
9. on October 21, 2008 at 2:43 pm Ramya

   Greatest work..Thanks

   
   
10. on October 21, 2008 at 2:51 pm Venkat

    Hi Pinal,
    I have table structure with data like below. all columns are key columns.

    Col1 col2 col4
    a1 c 1
    b1 a 1
    c1 b 1
    d2 b 2
    b2 c 2
    c2 a 2
    a2 d 2
    b3 a 3
    a3 d 3

    But I want a query to get first record group by col4. the resultset should be
    Col1 col2 col4
    a1 c 1
    d2 b 2
    b3 a 3

    Please guide me to get a query.

    Thanks,

    
    
11. on November 8, 2008 at 1:37 pm c++

    hom many time takes to download sql server 2008 ?

    
    
12. on November 17, 2008 at 6:04 pm Ajith

    Hi Pinal,

    So nice of you. You are doing a very big help and guidance to people like me.

    God bless You and your family.

    
    
13. on November 22, 2008 at 3:51 pm smita

    Hello Sir,

    The information there on this blog is very useful & helpful thanks for providing such informative infromation.

    Sir i have a query in ms-sql server2000
    can we convert numeric(18,0) to identity(1,1) which will be primary key ,
    since this ID numeric(18,0) is a foreign key in another table so i wanted that this key should be as primary auto incrementing key

    whereas i am also unable to do insert into statement for the same
    error ocuuring is as : Cannot insert explicit value for identity column in table

    Can you please help me out.

    
    
14. on November 29, 2008 at 5:37 pm Om Prakash

    hi

    i want to store a image in sql server 2005 by usging Sql command

    plz guide me

    
    
15. on December 3, 2008 at 8:08 pm Krishna

    Hi Dave,

    I’m very new to SQL server. Could you please guide with any training materials. Thank you

    
    
16. on December 7, 2008 at 7:01 am SQL SERVER - Interesting Interview Questions Journey to SQL Authority with Pinal Dave

    [...] Those who are scheduled for interview with me next week this is one question I will be sure asking you besides questions from my interview questions and answer series. [...]

    
    
17. on December 9, 2008 at 12:47 am Muhammad Junaid

    Dear Pinal Dave

    Really your are doing marvels Job I would like to appreciate your effort and Pray from God you always maintain this effort for deprived person like me.

    Regard
    Muhammad Junaid Babar

    
    
18. on December 10, 2008 at 7:00 am SQL SERVER - Interesting Interview Questions - Part 2 - Puzzle Journey to SQL Authority with Pinal Dave

    [...] not get this simple question, they smiled and answered that I did not have that on my blog or on my interview questions list. Let us go over the interview [...]

    
    
19. on December 17, 2008 at 12:40 pm Girish Advani

    Gr8 job dude..!

    Girish Advani
    Gujarat

    
    
20. on December 17, 2008 at 3:12 pm Vivek Singh

    Wonderful Work!

    
    
21. on December 20, 2008 at 12:02 pm SQL SERVER - Interesting Interview Questions - Revisited Journey to SQL Authority with Pinal Dave

    [...] for job in SQL Server related area please find your right job here. Make sure to read all the interview questions and answers for SQL Server 2008 before you appear for [...]