I am running following query which is not working properly:
create table #temp(
tableName nvarchar(50)
)
insert into #temp
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
DECLARE @name VARCHAR(50)
DECLARE @TQ VARCHAR(500)
DECLARE @ContainName VARCHAR(500)
DECLARE db_cursor CURSOR FOR
SELECT tableName
FROM #temp
OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
select @name IF COL_LENGTH(@name,'IsDeleted') IS NOT NULL
begin
IF COL_LENGTH(@name,'IsActive') IS NOT NULL
begin
exec ('UPDATE '+@name+' SET [IsActive] = ~[IsDeleted]')
end
ELSE
BEGIN
exec('ALTER TABLE '+@name+' ADD IsActive bit')
exec ('UPDATE '+@name+' SET [IsActive] = ~[IsDeleted]')
exec('ALTER TABLE '+@name+' ALTER COLUMN I ...
Go to the complete details ...