Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.
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()
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.