|
|
Posted by Jason Lepack on 06/07/07 15:03
> 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...@eaglecrusher.com> wrote:
>
> "Erland Sommarskog" <esq...@sommarskog.se> 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/downloads/books...
> > Books Online for SQL Server 2000 at
> >http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Hide quoted text -
>
> - Show quoted text -
Navigation:
[Reply to this message]
|