Journey to SQL Authority with Pinal Dave

Posted in Author Pinal, Database, 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, SQL XML, SQLAuthority, T SQL, Technology | 12 Comments

12 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.