At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!
Sub Asset_Tag_Update() Set conSQL = New ADODB.Connection conSQL.Open "Server=OURSQLSERVER;DRIVER=SQL Server;Database=maverick;User ID=mylogin;Password=mypassword" For Each Cell In Range("rt_ser") rt_serial = ActiveCell.Value new_asset_tag = ActiveCell.Offset(0, 1).Value rt_serial = "'" & rt_serial & "'" new_asset_tag = "'" & new_asset_tag & "'" strSQL = "update audit_item ai" & _ " set new_asset_tag = " & new_asset_tag & "" & _ " where rt_serial = " & rt_serial & "" Next Cell End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.