|
Posted by Brian on 06/07/07 13:51
What does the silver key mean?
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9947EFB6764B9Yazorman@127.0.0.1...
> Brian (b.houghtby@eaglecrusher.com) writes:
>> I need to update a value in IMA_GLInvAcctNbr 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_GLInvAcctNbr = 11500
> WHERE IMA_GLInvAcctNbr = 11283
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.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
Navigation:
[Reply to this message]
|