Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
Sub oUpdate() Dim sss As Integer 'myConnection = New SqlConnection("server=localhost;uid=sa;pwd=;database=pubs") myConnection.Open() myCommand = New SqlCommand("Update Authors Set city='Oakland' where city='San Jose' ", myConnection) sss = myCommand.ExecuteNonQuery() MsgBox("Records affected" & sss) myConnection.Close() End Sub
|Forgotton SQL Server 2008 SA Password||13||24|
|convert this back to a date?||13||51|
|Output query to a text file||20||72|
|SQL, Updating Statistics take too long for 60GB database||5||26|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!