1-) MSSQL RMOS - satırdaki column isimlerini araya virgül koyarak birleştirir

declare @result varchar(max)

select @result = COALESCE(@result + ', ', '') + COLUMN_NAME

from INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Log_Telefonlar'

select @result

2-) id 'yi almaz yani ilk virgüle kadarki olan kısmı çıkartır.

declare @result varchar(max)

select @result = COALESCE(@result + ', ', '') + COLUMN_NAME

from INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Log_Telefonlar'

select @result

declare @virgul int=(SELECT CHARINDEX(',', @result))

select SUBSTRING(@result, @virgul+2, LEN(@result)) AS ExtractString;

3-) bunlara bakmasanda olur

declare @result varchar(max)

select @result = COALESCE(@result + ', @', '') + COLUMN_NAME

from INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'deneme'

declare @virgul int=(SELECT CHARINDEX(',', @result))

set @result = (select SUBSTRING(@result, @virgul+2, LEN(@result)) AS ExtractString)

select 'as begin if @tip=0  begin insert into deneme values('+@result+') end

else if @tip=1 begin

update deneme set' as sutunlar