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.
Dim cn As New SqlConnection Dim cmd As New SqlCommand cn = GetConnected() cmd.Connection = cn cmd.CommandText = sSQL cmd.Parameters.Add(New SqlParameter("@FromDate", SqlDbType.DateTime)) ' etc - more parameters added ' This works - the record is added with a visible uniqueidentifier cmd.ExecuteNonQuery() ' This is where I'm trying to grab the Primary Key, but it returns a null.... cmd.Parameters.Clear() cmd.CommandText = "SELECT @@IDENTITY" Dim newID As String = "" & cmd.ExecuteScalar() ' ... so all of the record added here have a blank SessionID sSQL = "INSERT INTO tblScheduleStuff (Scheduler_SessionID, GenericStuff) SELECT '" & newID & "', Stuff FROM tblTEMPStuff" cmd.CommandText = sSQL cmd.ExecuteNonQuery()
|Database Connections Not being returned to Connection Pool||7||24|
|insert wont work in SQL||14||18|
|Update a text value in another table||10||37|
|sql 2008 how to table join||2||12|