Can T-SQL functions like Convert,Cast etc be used in a Parameterized SQL command ?
Here is the code I was tryign to use which would not work
is the part marked in purple correct?
Here is the code I was tryign to use which would not work
VB.NET:
Dim sqlStr As String
sqlStr = "Update ClientTransactions"
sqlStr = sqlStr & " SET TranId=@TranId,[B][COLOR=Purple]CtrnTime = convert(nvarchar,CtrnDate,101)+' '+ @CtrnTime[/COLOR][/B],CtrnDuration=@CtrnDuration,CtrnNotes= @CtrNnotes,LastModifiedDate=GETDATE(),UserIdLastModified=@UserIdLastModified"
sqlStr = sqlStr & " where RecurTranID=@RecurTranID"
Dim cmd As New SqlCeCommand()
cmd.CommandText = sqlStr
cmd.CommandType = CommandType.Text
cmd.Parameters.Add("@TranId", SqlDbType.NVarChar).Value = ConvertToSql(TranID)
cmd.Parameters.Add("@CtrnTime", SqlDbType.NVarChar).Value = ConvertToSql(CtrnTime.ToString("HH:mm:ss"))
cmd.Parameters.Add("@CtrnDuration", SqlDbType.Int).Value = ConvertToSql(CtrnDuration)
cmd.Parameters.Add("@CtrnNotes", SqlDbType.NVarChar).Value = ConvertToSql(CtrnNotes)
cmd.Parameters.Add("@RecurTranID", SqlDbType.NVarChar).Value = ConvertToSql(RecurTranID)
cmd.Parameters.Add("@UserIdLastModified", SqlDbType.NVarChar, 40, "UserIdLastModified").Value = ConvertToSql(UserId)
cmd.Parameters.Add("@LastModifiedDate", SqlDbType.NVarChar, 40, "LastModifiedDate")
ExecuteNonQuery(cmd)
is the part marked in purple correct?