Orçun Polat

DECLARE @tablename varchar(100) SET @tablename = N'myTable' SELECT clmns.name AS [Name], usrt.name AS [DataType], ISNULL(baset.name, N'') AS [SystemType], CAST(CASE WHEN baset.name IN (N'nchar', N'nvarchar') AND clmns.max_length <> -1 THEN clmns.max_length/2 ELSE clmns.max_length END AS int) AS [Length], CAST(clmns.precision AS int) AS [NumericPrecision] FROM sys.tables AS tbl INNER JOIN sys.all_columns AS clmns ON clmns.object_id=tbl.object_id LEFT OUTER JOIN sys.types AS usrt ON usrt.user_type_id = clmns.user_type_id LEFT OUTER JOIN sys.types AS baset ON baset.user_type_id = clmns.system_type_id and baset.user_type_id = baset.system_type_id WHERE (tbl.name=@tablename and SCHEMA_NAME(tbl.schema_id)=N'dbo') ORDER BY clmns.column_id ASC

--saha bazında eksiklerin tespiti declare @myserver varchar(100) declare @mydb varchar(100) declare @surumserver varchar(100) declare @surumdb varchar(100) set @myserver='eski sql sunucu' set @mydb='eski sql db' set @surumserver='yeni sql sunucu' set @surumdb='yeni sql db' EXEC('Select b.name tablo, ''gercek'' db from ['+@surumserver+'].['+@surumdb+'].[dbo].Sysobjects b left join ['+@myserver+'].['+@mydb+'].[dbo].Sysobjects c on c.name =b.name where b.xtype=''U'' and c.id is null AND b.name not like ''VS_%'' order by b.name ' ) exec(' Select ''alter table ''+b.name+'' add ''+a.name+'' ''+ case when a.xtype=127 then ''bigint'' when a.xtype=106 then ''decimal(''+cast(a.prec as varchar(20))+'',''+cast(a.scale as varchar(20))+'')'' when a.xtype=231 or a.xtyp...