Reply to Re: How To Script

Your name:

Reply:


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

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация