将当前数据库中所有表的smalldatetime 列改为nvarchar
2008-11-08 16:50:30 来源：WEB开发网 闂傚倷绶氬ḿ褍螞閹绢喖绠柨鐕傛嫹
闂傚倷绀侀幉锟犲垂閻㈠灚宕查柟鎵閸庡秵銇勯幒鎴濃偓鐢稿磻閹炬枼妲堟繛鍡楃С濞岊亞绱撻崒姘扁枌闁瑰嚖鎷�
婵犵數濮幏鍐川椤撴繄鎹曢梻渚€娼уú銈吤洪妸鈺佺劦妞ゆ帊鑳堕埊鏇㈡煏閸モ晛浠х紒杈╁仱閺佹捇鏁撻敓锟�闂傚倷绶氬ḿ褍螞閹绢喖绠柨鐕傛嫹 闂傚倷鑳舵灙缂佺粯顨呴埢宥夊即閵忕姵鐎梺缁樺姇閹碱偆鐥閺屾洘绻濊箛鏇犵獥闂佺厧澹婃禍婊堚€旈崘顏佸亾閿濆骸澧ù鐘欏嫮绠鹃柛顐ゅ枎閻忋儲銇勯弴妯哄姦妞ゃ垺鐟╅幃鈩冩償閵囧府鎷�
核心提示：-- 将当前数据库中, 所有表的smalldatetime 列改为nvarchar(20)-- 如果列上有索引/默认值之类的依赖项, 则无法修改EXEC sp_msforeachtable@command1 = N'DECLARE CUR CURSOR LOCALFORSELECTN''ALTE
-- 将当前数据库中, 所有表的smalldatetime 列改为nvarchar(20)
-- 如果列上有索引/默认值之类的依赖项, 则无法修改
EXEC sp_msforeachtable
@command1 = N'
DECLARE CUR CURSOR LOCAL
FOR
SELECT
N''ALTER TABLE ? ALTER COLUMN ''
+ QUOTENAME(C.name)
+ N''nvarchar(20)''
FROM syscolumns C, systypes T
WHERE C.xusertype = T.xusertype
AND T.name = ''smalldatetime''
AND C.id = OBJECT_ID(N''?'')
OPEN CUR
DECLARE @s nvarchar(4000)
FETCH CUR INTO @s
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT(@s)
EXEC(@s)
FETCH CUR INTO @s
END
CLOSE CUR
DEALLOCATE CUR
',
@whereand = N'
AND EXISTS(
SELECT * FROM syscolumns C, systypes T
WHERE C.xusertype = T.xusertype
AND T.name = ''smalldatetime''
AND C.id = O.id)
'
中查找“将当前数据库中所有表的smalldatetime 列改为nvarchar”更多相关内容
中查找“将当前数据库中所有表的smalldatetime 列改为nvarchar”更多相关内容更多精彩
赞助商链接
