> Dim loDataParameterSQLClient As SqlParameter = Nothing > > loDataParameterSQLClient = New SqlParameter() > loDataParameterSQLClient.ParameterName = "MyField1" > loDataParameterSQLClient.Value = 1 > loDataParameterSQLClient.SqlDbType = SqlDbType.Int > loDataParameterSQLClient.Size = 4 > > loDataParameterSQLClient = New SqlParameter() > loDataParameterSQLClient.ParameterName = "MyField2" > loDataParameterSQLClient.Value = '12/30/1899 12:00:00 AM' > loDataParameterSQLClient.SqlDbType = SqlDbType.DateTime > loDataParameterSQLClient.Size = 8 > > loDataParameterSQLClient = New SqlParameter() > loDataParameterSQLClient.ParameterName = "MyField3" > loDataParameterSQLClient.Value = ' ' > loDataParameterSQLClient.SqlDbType = SqlDbType.VarChar > loDataParameterSQLClient.Size = 8 > > loDataParameterSQLClient = New SqlParameter() > loDataParameterSQLClient.ParameterName = "MyField4" > loDataParameterSQLClient.Value = '3/16/2008 9:26:07 PM' > loDataParameterSQLClient.SqlDbType = SqlDbType.DateTime > loDataParameterSQLClient.Size = 8 >>
>DECLARE @MyField1 Integer >DECLARE @MyField2 DateTime >DECLARE @MyField3 Varchar(8) >DECLARE @MyField4 DateTime > >SET @MyField1=1 >SET @MyField2='12/30/1899 12:00:00 AM' >SET @MyField3=' ' >SET @MyField4='3/16/2008 9:26:07 PM' >>