[SQLServer]Stored Procedure サンプル

2008 2/28
カテゴリー : SQLServer
SQLServer . stored procedure
投稿者 : flied_onion
コメントを書く

declare @tn nvarchar(40)
declare @cln nvarchar(40)
declare @sql nvarchar(200)

declare ca Cursor for 
select syscolumns.name,sysobjects.name from sysobjects,syscolumns
where sysobjects.xtype='U' 
and sysobjects.id=syscolumns.id 
and syscolumns.name like '%Employ%'

OPEN ca

Fetch next from ca into @cln,@tn
WHILE(@@fetch_status = 0)
begin
	--exec sp_executesql N'select ' + @cln  + N' from ' + @tn;
	

	set @sql = 'select ' + @cln  + ' from ' + @tn + ' where ' + @cln + ' is not null'; 
	exec sp_executesql @sql;
	print @sql
	Fetch next from ca into @cln,@tn
end

close ca
deallocate ca

declare @tn nvarchar(40)

declare @cln nvarchar(40)

declare @sql nvarchar(200)

declare ca Cursor for

select syscolumns.name,sysobjects.name from sysobjects,syscolumns

where sysobjects.xtype='U'

and sysobjects.id=syscolumns.id

and syscolumns.name like '%Employ%'

OPEN ca

Fetch next from ca into @cln,@tn

WHILE(@@fetch_status = 0)

begin

--exec sp_executesql N'select ' + @cln + N' from ' + @tn;

set @sql = 'select ' + @cln + ' from ' + @tn + ' where ' + @cln + ' is not null';

exec sp_executesql @sql;

print @sql

Fetch next from ca into @cln,@tn

end

close ca

deallocate ca

Onion Knowledge

fliedonion's knowledge base

[SQLServer]Stored Procedure サンプル

INFORMATION

最近の投稿

最近のコメント

アーカイブ

カテゴリー

メタ情報