USE IFP
GO
IF NOT EXISTS(SELECT * FROM syscolumns WHERE [ID] = object_id(N'tempTableRatedElements') AND [NAME] = N'ID')
ALTER TABLE dbo.tempTableRatedElements ADD [ID] INT IDENTITY(1,1) CONSTRAINT
declare @str varchar(100)
set @str='test' --要搜索的字符串
declare @s varchar(8000)
declare tb cursor local for
select s='if exists(select 1 from ['+b.name+'] where ['+a.name+'] like ''%'+@str+'%'')
prin...
在SQL数据库中，如果一个日期字段用Char型来存储，如何将数据库中的字段在执行SQL语句时转为日期型，并且比较时间前后，下面这条SQL语句作为模板，实现上述功能。
strSQL = "select * from Charge_Info where cast(convert(varchar,date) as datetime) between '" & strStartDate
& "
想要查询表的全部信息 ： exec sp_help 'TABLE'
查询表中所有字段名称及类型：select name,TYPE_NAME(system_type_id)+'('+convert(varchar(100),max_length)+')' as type from sys.columns where object_id=object_id('TABLE')
以上s
SELECT object_name(sc.id) as TableName, sc.Name as ColumnName, si.rows as RowCounts FROM SysColumns sc LEFT JOIN SysObjects so ON sc.id = so.id LEFT JOIN SysIndexes si ON sc.id = si.id WHERE so.type='...
将同一个表中两个类型一样的字段的值互换：UPDATE ddd a,
ddd b
SET a.original_department_id = b.department_id,
a.department_id = b.original_department_id
WHERE
a.key_manage_id = b.key_manage_id
AND a.key_manage_id = 1
本版专家分：0结帖率 95.45%
