select 'tb=' + cast(tb as varchar) + ';tb_name=' + cast(tb_name as varchar) + ';tb_sql=select * from ' + cast(tb_sql as varchar) + ';' from tb
解决方案 »
- 一个简单的sql语句,帮俺解决一下,在线等!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 数据库的处理
- 求取最近日期的一些记录的SQL语句,刚注册的号没办法给分,如果信任我,有分后再补
- sql列转化行 统计的问题
- 请各位高手帮忙想一条sql语句
- 用sql建立了一个local数据库以后,里面的表有很多是系统自行定义的,能不能删除啊?
- 复杂的"约束"
- 数据库交叉查询,统计
- 这样的SQL语句如何写?
- 还是想不出来!!(有关jpg与bmp、SQL Server)
- 专家帮忙看看,怎么写这样的SQL
- mssql中如何对所有的表进行修改(不想一张张的改,太累),感谢帮忙
insert into test values(22 , 'saletb' , 'select * from saletb')
goselect 'tb=' + cast(tb as varchar) + ';tb_name=' + cast(tb_name as varchar) + ';tb_sql=' + cast(tb_sql as varchar) + ';' from testdrop table test/*
---------------------------------------------------------------------------------------------------------------
tb=22;tb_name=saletb;tb_sql=select * from saletb;(所影响的行数为 1 行)
*/
insert into test values(22 , 'saletb' , 'select * from saletb')
goselect 'tb=' + cast(tb as varchar) + ';tb_name=' + cast(tb_name as varchar) + ';tb_sql=' + cast(tb_sql as varchar) + ';' from testdrop table test/*
---------------------------------------------------------------------------------------------------------------
tb=22;tb_name=saletb;tb_sql=select * from saletb;(所影响的行数为 1 行)
*/
--> 测试数据:[tb]
if object_id('[tb]') is not null drop table [tb]
create table [tb]([tb] int,[tb_name] varchar(6),[tb_sql] varchar(32))
insert [tb]
select 22,'saletb','select * from saletb'declare @sql nvarchar(1000)
select @sql=isnull(@sql+'+'';''+','')+''''+[name]+'=''+rtrim(' + [name] + ')'
from syscolumns
where id=object_id('tb')print ('select '+@sql + ' from tb')
exec ('select '+@sql + ' from tb')/*
select 'tb='+rtrim(tb)+';'+'tb_name='+rtrim(tb_name)+';'+'tb_sql='+rtrim(tb_sql) from tb----------------------------------------------------------------------
tb=22;tb_name=saletb;tb_sql=select * from saletb(1 行受影响)
*/drop table tb
--> 测试数据:[tb]
if object_id('[tb]') is not null drop table [tb]
create table [tb]([tb] int,[tb_name] varchar(6),[tb_sql] varchar(32))
insert [tb]
select 22,'saletb','select * from saletb'declare @sql nvarchar(1000)
set @sql='select '
select @sql=@sql+''''+[name]+'=''+rtrim(' + [name] + ')+'';'''
from syscolumns
where id=object_id('tb')
set @sql=@sql + ' from tb'--print @sql
exec(@sql)/*-------------------------------------------------------------------------
tb=22;'tb_name=saletb;'tb_sql=select * from saletb;(1 行受影响)
*/drop table tb
--> 测试数据:[tb]
if object_id('[tb]') is not null drop table [tb]
create table [tb]([tb] int,[tb_name] varchar(6),[tb_sql] varchar(32))
insert [tb]
select 22,'saletb','select * from saletb'declare @sql nvarchar(1000)
select @sql=isnull(@sql+'+','')+''''+[name]+'=''+rtrim(' + [name] + ')+'';'''
from syscolumns
where id=object_id('tb')
set @sql='select '+ @sql + ' from tb'--print @sql
exec(@sql)/*
tb=22;tb_name=saletb;tb_sql=select * from saletb;(1 行受影响)
*/drop table tb
if object_id('[s]') is not null drop table [s]
create table [s] (tb int,tb_name varchar(6),tb_sql varchar(50))
insert into [s]
select 22,'saletb','select * from saletb'declare @sql varchar(100)
select @sql=isnull(@sql+'+'';','''')+name+'=''+ltrim('+name+')' from syscolumns where id=object_id('s')
exec('select '+@sql+' from s')
declare @sql varchar(8000)
select @sql=isnull(@sql+'+'';','''')+name+'=''+ltrim('+name+')' from syscolumns where id=object_id('s')
exec('select '+@sql+' from s')