如何在单个SELECT查询中设置多个T-SQL变量? [英] How can I set multiple T-SQL variables in a single SELECT query?

问题描述

我有3个变量:@testid，@sampleid和@clientid.

如何通过执行一次查询来设置@sampleid和@clientid?

How can I set @sampleid and @clientid by executing this query once?

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

这篇关于如何在单个SELECT查询中设置多个T-SQL变量?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！