SQL Server Performance

70-431 details

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

  1. bhushnan New Member

    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


    Contributing Editor, Writer & Forums Moderator

    Visit my Blog at
  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
    SELECT * FROM Adventureworks.HumanResources.Employee
    SELECT * INTO Employee FROM HumanResources.Employee WHERE 1 = 0
    SELECT * FROM Employee

  4. satya Moderator

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