sqlÖÐ £¿´ú±íʲô - MS-SQL Server / »ù´¡Àà

SQL code:

IF '?' IN(select rtrim(databasename) as name from stibtest.dbo.ls_yddata where is_wlz='ÊÇ' and databasename<=''stib232'' and databasename<>''stib144'')



Õâ¸ö £¿ ±íʾʲô£¬ÊÇÊý¾Ý¿âÃûÂð£¿

---

²»Ã÷°×¡£SF¡£¡£¡£²»Ã÷°×£¿ÊǸÉʲô

---

?ÊÇռλ·û£¬ÔÙ³ÌÐòÀïÐèÒª½øÐÐÉèÖõIJÎÊý

---

ÄãµÄ²éѯÊÇÓû§¶¨ÒåµÄ±í£¬¾Í²»ºÃ˵ÁË

---

¹âÕâ¸öÓï¾ä²»Ðаɣ¿ÔÚijЩµØ·½¿ÉÒÔ´ú±íռλ·û£¬È磺
·µ»ØËùÓбíÃû£º
SQL code:

EXEC sp_MSforeachtable '?'

---

Ò²ÐíÊÇsp_msforeachdbÖеÄÓï¾ä°É£¬°ÑÓï¾ä¸øÈ«

---

SQL code:

declare @command1 nvarchar(1000)
declare @command2 nvarchar(1000)
set @command1='
if ''?'' in(select databasename from [stibtest].dbo.ls_yddata where databasename>=''stib001'' and databasename<=''stib232'')
begin
use ?
if exists(select top 1 * from ?.dbo.retmast where rq=convert(char(10),getdate()-1,120))
insert into [stibtest].dbo.scqk
select ydname,''ÒÑÈÕÇå'' from [stibtest].dbo.ls_yddata where databasename=''?''
else
if not exists(select top 1 * from ?.dbo.retmast where rq=convert(char(10),getdate()-1,120))
begin
if exists(se