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!

  • Congratulations Mike Lewis 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

MIS
Feb 24, 2007
289
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top