Post reply

Table insertion help

  • October 1, 2015 at 1:34 pm

    #321638

    All,

    I am trying to insert ServerName, DBName, Recovery Model, CreateDate and Owner into a user table from the system table. I am wondering if someone can help me with the syntax?

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • October 1, 2015 at 1:43 pm

    #1830885

    That should be a straightforward INSERT ... SELECT. What part of the syntax are you having trouble with?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 1, 2015 at 2:22 pm

    #1830906

    Sorry for the confusion. I got it.

    Thanks!

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply