会python真的可以为所欲为0(回)
353天前
这里还有人吗1(回)
538天前这里还有人吗0(回)
538天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
762天前到处都是羊，不想上班0(回)
842天前
鸽子
0(回)
847天前DECLARE @ColumnName VARCHAR(100) |
DECLARE @TableName VARCHAR(100) |
DECLARE @IsNull INT |
DECLARE @sSQL VARCHAR(500) |
DECLARE cur CURSOR FOR |
SELECT o.name,c.name,c.is_nullable, c.* |
FROM sys.[columns] AS c |
LEFT JOIN sys.objects AS o ON o.[object_id]=c.[object_id] |
WHERE c.name LIKE '%ItemID' AND o.[type]='U' AND c.max_length=15 |
OPEN cur |
FETCH NEXT FROM cur INTO @TableName,@ColumnName,@IsNull |
WHILE @@FETCH_STATUS=0 |
BEGIN |
SET @sSQL='ALTER TABLE '+@TableName+' ALTER COLUMN '+@ColumnName+' VARCHAR(100) ' + CASE WHEN @IsNull=1 THEN ' NOT NULL' ELSE '' END |
PRINT @sSQL |
|
--EXECUTE('ALTER TABLE ' + @tableName +' ADD CONSTRAINT DF_'+@tableName+'_Status DEFAULT (1) FOR [STATUS]') |
--EXECUTE(@sSQL) |
--EXECUTE ('UPDATE '+ @tableName + 'SET [Status]=1 WHERE [STATUS] IS NULL') |
|
FETCH NEXT FROM cur INTo @TableName,@ColumnName,@IsNull |
END |
CLOSE cur |
DEALLOCATE cur |
