SQL 2005 CommandText Syntax

How do I format the following correctly?  I am passing in EmployeeID and ManagerID

 cmd2.CommandText = "Update CNote_CasAssetManagers Set AssetMgrID, EmployeeID = '" & ManagerID & "','" & EmpID
Annette Wilson, MSISSr. Programmer AnalystAsked:
Who is Participating?
 
eridanixConnect With a Mentor Commented:
cmd2.CommandText = "UPDATE dbo.CNote_CasAssetManagers SET AssetMgrID = '" & ManagerID & "', EmployeeID = '" & EmpID & "'"

But be carefull!!! This query change all records in table!!! Maybe there should be a WHERE statement in query.
0
 
Annette Wilson, MSISSr. Programmer AnalystAuthor Commented:
Thank youu.
0
All Courses

From novice to tech pro — start learning today.