Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
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
|sql server select date from a datetime column||10||23|
|SQL Server - problem connecting to database engine from management studio||4||38|
|Webservices in T-SQL||3||30|
|Help with adding DLL file in Windows project||20||28|