CREATE PROCEDURE [getzijin] @date datetime,@username varchar(50) AS
set nocount on
begin transaction
insert TABLE (username,name,shl) select @username,pzhhh,sum(jc) from DATABASE.TABLE1 where date=@date group by pzhhh having sum(jc)<>0
commit
GO
DATABASE.TABLE1 是另外一个数据库DATABASE的TABLE1表
提示DATABASE.TABLE1无效,请问该如何写啊 ,谢谢
...全文
2607打赏收藏
请问在存储过程中如何调用其他数据库中的表
CREATE PROCEDURE [getzijin] @date datetime,@username varchar(50) AS set nocount on begin transaction insert TABLE (username,name,shl) select @username,pzhhh,sum(jc) from DATABASE.TABLE1 where date=@date group by pzhhh having sum(jc)0 commit GO DATA
CREATE PROCEDURE [getzijin] @date datetime,@username varchar(50) AS
set nocount on
begin transaction
insert TABLE (username,name,shl) select @username,pzhhh,sum(jc) from DATABASE.dbo.TABLE1 where date=@date group by pzhhh having sum(jc) <>0
commit
GO