我有3个变量:@testid
, @sampleid
and @clientid
.
我该如何设置@sampleid
and @clientid
通过执行此查询一次?
SELECT
[sample].sampleid,
[client].clientid
FROM
dbo.[test]
LEFT OUTER JOIN dbo.[sampleslice] ON dbo.[test].samplesliceid = dbo.[sampleslice].samplesliceid
LEFT OUTER JOIN dbo.[sample] ON dbo.[sampleslice].sampleid = dbo.[sample].sampleid
LEFT OUTER JOIN dbo.[client] ON dbo.[sample].clientid = dbo.[client].clientid
WHERE
testid = @testid
DECLARE @sampleid YOUR_VAR_TYPE;
DECLARE @clientid YOUR_VAR_TYPE;
SELECT
@sampleid = [sample].sampleid,
@clientid = [client].clientid
FROM dbo.[test]
-- The variables are now initialized. You can now use them below.above
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)