你很厉害,一下子点了三个斑竹的名!
不过你的问题好像不必三个斑竹一起为你解答吧?!
我一人代劳了:Select @sSql = 'DECLARE csShop CURSOR FOR SELECT ShopID, ShopName FROM Use Web_Shoes_01..Shop ORDER BY ShopID'
Exec(@sSql)
open csShop
...
不过你的问题好像不必三个斑竹一起为你解答吧?!
我一人代劳了:Select @sSql = 'DECLARE csShop CURSOR FOR SELECT ShopID, ShopName FROM Use Web_Shoes_01..Shop ORDER BY ShopID'
Exec(@sSql)
open csShop
...
为什么这里就不能使用USE Web_Shoes_01 'DECLARE csShop CURSOR FOR SELECT ShopID, ShopName FROM Shop ORDER BY ShopID'不好意思,我现在急等着用的,所以嘛、、、、
CREATE Procedure sp_upShop @DBName Char(15)
As DECLARE @sUseDB CHAR(16)
DECLARE @sSql NVARCHAR(4000)
Select @sUseDB = 'Use '+ @DBName
DECLARE @sID CHAR(4)
DECLARE @sName CHAR(40)
Select @sSql = 'DECLARE csShop CURSOR FOR SELECT ShopID, ShopName FROM '+ @sUseDB +'..Shop ORDER BY ShopID'
print @sSql
Exec(@sSql)OPEN csShop
好象不行啊。服务器: 消息 156,级别 15,状态 1,行 1
在关键字 'Use' 附近有语法错误。
你的@DBName是不是数据库名?
@sUseDB是什么?CREATE Procedure sp_upShop @DBName Char(15)
As DECLARE @sSql VARCHAR(4000)
Select @sSql = 'DECLARE csShop CURSOR FOR SELECT ShopID, ShopName FROM '+ @DBName +'..Shop ORDER BY ShopID'
Exec(@sSql)OPEN csShop
As DECLARE @sSql VARCHAR(4000)
Select @sSql = 'DECLARE csShop CURSOR FOR SELECT ShopID, ShopName FROM '+ rtrim(@DBName) +'..Shop ORDER BY ShopID'
Exec(@sSql)OPEN csShop 或者:CREATE Procedure sp_upShop @DBName VarChar(15)
As DECLARE @sSql VARCHAR(4000)
Select @sSql = 'DECLARE csShop CURSOR FOR SELECT ShopID, ShopName FROM '+ @DBName +'..Shop ORDER BY ShopID'
Exec(@sSql)OPEN csShop