What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI
Sub oInsert() Dim ra As Integer Dim oDate As String = "03/03/2011" 'Date.Now.ToString Dim oText As String = "sqlclient" Dim oNumber As Decimal = 100 myConnection.Open() Dim sSQL As String sSQL = "Insert Into Table1 ([oDate],[oText], [oNumber]) Select '" & oDate & "' as Expr1, '" & oText & "' as Expr2, " & oNumber & " as Expr3" myCommand = New SqlCommand(sSQL, myConnection) ra = myCommand.ExecuteNonQuery() 'Since no value is returned we use ExecuteNonQuery MsgBox("Records Inserted " & ra) myConnection.Close() 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.