How To Script

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Brian
    #1

    How To Script

    I need to update a value in IMA_GLInvAcctNb r from 11283 to 11500. the table
    name is dbo.item. What would my script look like to do this in SQL server
    2005? The column has a silver key by it too in SQL Server Management
    Studio.



    Thanks


    Tags: None
    • Erland Sommarskog
      #2
      Re: How To Script

      Brian (b.houghtby@eag lecrusher.com) writes:
      I need to update a value in IMA_GLInvAcctNb r from 11283 to 11500. the
      table name is dbo.item. What would my script look like to do this in
      SQL server 2005? The column has a silver key by it too in SQL Server
      Management Studio.
      UPDATE dbo.item
      SET IMA_GLInvAcctNb r = 11500
      WHERE IMA_GLInvAcctNb r = 11283


      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server 2005 at
      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

      Books Online for SQL Server 2000 at
      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

        Comment

        • Brian
          #3
          Re: How To Script

          What does the silver key mean?

          "Erland Sommarskog" <esquel@sommars kog.sewrote in message
          news:Xns9947EFB 6764B9Yazorman@ 127.0.0.1...
          Brian (b.houghtby@eag lecrusher.com) writes:
          >I need to update a value in IMA_GLInvAcctNb r from 11283 to 11500. the
          >table name is dbo.item. What would my script look like to do this in
          >SQL server 2005? The column has a silver key by it too in SQL Server
          >Management Studio.
          >
          UPDATE dbo.item
          SET IMA_GLInvAcctNb r = 11500
          WHERE IMA_GLInvAcctNb r = 11283
          >
          >
          --
          Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
          >
          Books Online for SQL Server 2005 at
          http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

          Books Online for SQL Server 2000 at
          http://www.microsoft.com/sql/prodinf...ons/books.mspx

            Comment

            • Jason Lepack
              #4
              Re: How To Script

              What does the silver key mean?

              It means that it is in a foreign key relationship to another table.

              On Jun 7, 9:51 am, "Brian" <b.hough...@eag lecrusher.comwr ote:
              >
              "Erland Sommarskog" <esq...@sommars kog.sewrote in message
              >
              news:Xns9947EFB 6764B9Yazorman@ 127.0.0.1...
              >
              >
              >
              Brian (b.hough...@eag lecrusher.com) writes:
              I need to update a value in IMA_GLInvAcctNb r from 11283 to 11500. the
              table name is dbo.item. What would my script look like to do this in
              SQL server 2005? The column has a silver key by it too in SQL Server
              Management Studio.
              >
              UPDATE dbo.item
              SET IMA_GLInvAcctNb r = 11500
              WHERE IMA_GLInvAcctNb r = 11283
              >
              --
              Erland Sommarskog, SQL Server MVP, esq...@sommarsk og.se
              >
              Books Online for SQL Server 2005 at
              http://www.microsoft.com/technet/pro...ownloads/books...
              Books Online for SQL Server 2000 at
              http://www.microsoft.com/sql/prodinf...ns/books.mspx- Hide quoted text -
              >
              - Show quoted text -

                Comment

                Previous template Next
                Working...