VB.NET 塞時間到資料庫欄位中

塞時間到資料庫欄位中(欄位型態為DATE)


SQL 命令字串:

SQLS = SQLS & "update [OLAP].[dbo].[Cube]" & vbCrLf
SQLS = SQLS & "set [cube_name] ='" & cube_name & "'" & vbCrLf
SQLS = SQLS & ", [cube_desc] ='" & cube_desc & "'" & vbCrLf
SQLS = SQLS & ", [updatetime] = GETDATE()" & vbCrLf
SQLS = SQLS & ", [updid] ='" & Session("user_id") & "'" & vbCrLf

SQL去除空白

REPLACE(@string, '要被替代的字元', '替代字元')