SQL Server Performance

70-431 details

Discussion in 'SQL Server 2005 General Developer Questions' started by bhushnan, Dec 12, 2006.

  1. bhushnan New Member

    hi,
    i am planning to do 70-431 ( MCTS--SQL 2005 certification ),
    plz suggest me how to prepare for the exam, related links and also
    can any one send the dump.

    thanks in advance!!
  2. dineshasanka Moderator

    http://www.microsoft.com/Learning/exams/70-431.asp

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  3. sumprit New Member

    Hi Bhushan,

    I visitied your website and found a useful code that you have written, about creating a new empty table structure based on the exsisting one, by having the value for 1=0.

    My question is , can I do the same using between two database under one server. So the query would go something like this:-

    Use Sumprit -- database name
    Go
    SELECT * FROM Adventureworks.HumanResources.Employee
    SELECT * INTO Employee FROM HumanResources.Employee WHERE 1 = 0
    SELECT * FROM Employee


    thanks.
  4. satya Moderator

    Sumprit
    If this is a seperate question to Bhushan's then please use a new thread and in your case it should work.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page