摘要:
CAST ( CAST ( DATEDIFF ( ss, StartTime, ConcludeTime ) / ( 60 * 60 * 24 ) AS INT ) AS VARCHAR ) + '天' + CAST ( CAST ( DATEDIFF ( ss, StartTime, ConcludeTime ) % 86400 / 3600 AS INT ) AS VARCHAR ) + ... 阅读全文
摘要:
exec UpdateTableData '表名','修改字段','修改值','条件字段','条件值' 阅读全文
摘要:
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROC [dbo].[SearchTableData] @TableName VARCHAR(255), @Fields VARCHAR(255), @WhereField VARCHAR(255), @WhereValue VARCHAR(255) AS BEGIN DECLAR... 阅读全文