SQLServer2008中，存储过程中一个变量的值是由一个子查询得到的。这个该怎么写？

Question

如题。 1 INSERT INTO [ApplicationLog] 2 ([AppServerID],[Class],[Level]) 3 VALUES(@[AppServerID],@[Class],@[Level]); 4 --其中，AppServerID的值由下面的查询得到 5 SELECT AppServerID FROM AppServerConnection 6 WHERE 7 AppID=@AppID AND ServerID=(SELECT a.ServerID FROM PCServer AS a WHERE a.IntranetIP = @IntranetIP 请问这个该怎么写成一个存储过程呀！！！谢谢！！！！

Answer 1

INSERT INTO [ApplicationLog]
        ([AppServerID],[Class],[Level])
        (SELECT AppServerID],@[Class],@[Level] FROM AppServerConnection 
 WHERE
 AppID=@AppID AND ServerID=(SELECT a.ServerID FROM PCServer AS a WHERE a.IntranetIP = @IntranetIP)

Answer 2

Declare @AppServerID nvarchar(50) --- or int

 

Select @AppServerID=AppServerID FROM AppServerConnection WHERE AppID=@AppID

AND ServerID=(SELECT a.ServerID FROM PCServer AS a WHERE a.IntranetIP = @IntranetIP

 

Insert into....

Answer 3

前辈你好！你看我这样写对吗！

 1 SET ANSI_NULLS ON
 2 GO
 3 SET QUOTED_IDENTIFIER ON
 4 GO
 5 
 6 CREATE PROCEDURE [dbo].[prInsApplicationLog2]
 7 @AppID int,
 8 @Class nvarchar(512),
 9 @Level nvarchar(512),
10 @Thread int,
11 @File nvarchar(512),
12 @Line int,
13 @Message nvarchar(MAX),
14 @TimeGenerated datetime,
15 @CreatedTime datetime,
16 @IntranetIP nvarchar(256)
17 AS
18 BEGIN
19 Declare @AppServerID int
20 Select @AppServerID=AppServerID FROM AppServerConnection WHERE AppID=@AppID
21 AND ServerID=(SELECT a.ServerID FROM PCServer AS a WHERE a.IntranetIP = @IntranetIP)
22 INSERT INTO ApplicationLog
23 (AppServerID,Class,Level,Thread,[File],Line,Message,TimeGenerated,CreatedTime)
24     VALUES
25     (@AppServerID,@Class,@Level,@Thread,@File,@Line,@Message,@TimeGenerated,@CreatedTime)
26 END
27 GO

谢谢谢谢。。。

Answer 4

@紫秋: 谢谢你第一个回答！