Posted by Erland Sommarskog on 06/06/07 21:32

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

[Back to original message]