Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update field

Status
Not open for further replies.
intel233

intel233

MIS
Feb 24, 2007
289
0
0
US
I am not a SQL guy and there is no one here to help. I have a database call bis2. I need to update a table.
If I do:
Select * from dbo.Hardware where HardwareId='14518';
I get
HardwareID HardwareName HardwareTypeID Brand ModelNo SerialNumber
1 14518 Notebook 5 Dell Dell Latitude 3490 CWJ11111

For HardwareID 14519 its empty and I need to fill this in. How Do I do that? I would guess with Update but not sure the syntax.

Thanks
 
Sort by date Sort by votes
Since you're not a SQL guy, and it sounds like this is a "one off". The easiest way is to open SQL Server Management Studio, find the table you need, right click and edit.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
Database field defaulting to a certain value and it should not
Replies
0
Views
34
dgillz
dgillz
djj55
  • Locked
  • Question
Unable to update the database IDs error.
Replies
5
Views
63
djj55
djj55
TiltingCode
  • Locked
  • Question
modifying a field
Replies
2
Views
34
SQLBill
SQLBill
awaria
  • Locked
  • Question
SQL 2000 Strategy for keeping Reporting Server Updated with Prod Server Data
Replies
8
Views
60
djj55
djj55
tinnu
  • Locked
  • Question
how to update a value in other table
Replies
1
Views
45
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top