How To Script

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.



Thanks

Re: How To Script

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/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: How To Script

What does the silver key mean?

"Erland Sommarskog" 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/downlo ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

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" wrote:
>
> "Erland Sommarskog" wrote in message
>
> news:Xns9947EFB6764B9Yazorman@127.0.0.1...
>
>
>
> > Brian (b.hough...@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, esq...@sommarskog.se
>
> > Books Online for SQL Server 2005 at
> >http://www.microsoft.com/technet/prodtechnol/sql/2005/downl oads/books...
> > Books Online for SQL Server 2000 at
> >http://www.microsoft.com/sql/prodinfo/previousversions/book s.mspx- Hide quoted text -
>
> - Show quoted text -