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 命令字串:
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
0 個意見:
張貼留言
訂閱 張貼留言 [Atom]
<< 首頁