怎么设置一个变量计算器
如何设置一个变量计算器
我想要达到下面的结果：
declare @rn int=2;--变量计数器
SELECT
@rn+1 id,
user,
sex
FROM usertb
--接着上面计算器
SELECT
@rn+1 id,
carNO,
carLeng
FROM carTb
---执行结果如下---
ID user sex
2 admin 1
3 zh1sw 2
4 erredd 1
-------
ID carNO carLeng
5 15424 12.6
6 54662 41
求教这该这么写？
------解决思路----------------------
我想要达到下面的结果：
declare @rn int=2;--变量计数器
SELECT
@rn+1 id,
user,
sex
FROM usertb
--接着上面计算器
SELECT
@rn+1 id,
carNO,
carLeng
FROM carTb
---执行结果如下---
ID user sex
2 admin 1
3 zh1sw 2
4 erredd 1
-------
ID carNO carLeng
5 15424 12.6
6 54662 41
求教这该这么写？
------解决思路----------------------
DECLARE @rn int
SET @rn = 2
SELECT @rn + ROW_NUMBER() OVER(ORDER BY GETDATE()) - 1 id,
*
FROM (SELECT TOP 3 name
FROM master..spt_values
) t
SET @rn = @rn + @@ROWCOUNT
SELECT @rn + ROW_NUMBER() OVER(ORDER BY GETDATE()) - 1 id,
*
FROM (SELECT TOP 2 name
FROM master..spt_values
ORDER BY number DESC
) t
SET @rn = @rn + @@ROWCOUNT
id name
-------------------- -----------------------------------
2 (rpt)
3 YES OR NO
4 SYSREMOTELOGINS TYPES
(3 行受影响)
id name
-------------------- -----------------------------------
5 ALL SETTABLE OPTIONS
6 auto update statistics
(2 行受影响)