先把数据库中所有表名称找到 ,然后逐个表查询
declare @name varchar(50),@tt varchar(10)
declare cc cursor for
select name from sysobjects where xtype='U'
fetch cc into @name
while @@fetch_status = 0
begin
sql如何查询整个数据库包含abc关键字的数据,在线求解答
先把数据库中所有表名称找到 ,然后逐个表查询
declare @name varchar(50),@tt varchar(10)
declare cc cursor for
select name from sysobjects where xtype='U'
fetch cc into @name
while @@fetch_status = 0
begin