双11狂欢大促

盲盒赢 定制羽绒服

开启惊喜盲盒，抽取你的专属好礼

— 惊喜奖品抢先看 —

超级年卡50元券

周边70元券

手机支架

一拖三数据线

雨伞

运动毛巾

电动牙刷

VIP月卡

机械键盘

定制羽绒服

超级年卡50元券

周边70元券

手机支架

一拖三数据线

雨伞

运动毛巾

电动牙刷

VIP月卡

机械键盘

定制羽绒服

急求SQL

2018-11-20 01:26:06 1.2k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

fyming 墨衍会员 · AI 创作全网分发关注 + 加入社区

实战指南！基于STM32的智能环境监测系统（代码+硬件设计+云端控制）本文详细介绍了基于STM32的智能环境监测系统的设计与实现，包括硬件选型、电路设计、软件架构和云端控制。系统通过DHT11温湿度传感器和MQ-2烟雾传感器实时监测环境数据，STM32F103C8T6主控芯片处理数据并通过ESP8266上传至中国移动物联网平台，支持手机APP远程监控。项目成本低、稳定性高，适合智能家居和环境监测应用。阅读详情

CREATE TABLE #(W1 INT,W2 INT,W3 INT,W4 INT,S NVARCHAR(30))

INSERT INTO #(W1,W2,W3,S)
SELECT 1,2,3,'W1+W2' UNION ALL
SELECT 1,1,1,'W2+W3' UNION ALL
SELECT 1,0,0,'W1*20+W2+W3-5'
---------------
说明，S为公式，根据公式得到结果并赋值给W4，希望得到结果：

W1 W2 W3 W4 S
1 2 3 3 ‘W1+W2’
1 1 1 2 'W2+W3'
1 0 0 15 'W1*20+W2+W3-5'
-----------------------------
多谢！！！

...全文

STM32F407 BootLoader实战：从零搭建到OTA升级（附完整源码）本文详细介绍了为STM32F407微控制器从零搭建BootLoader并实现稳定OTA升级的完整实战指南。内容涵盖Flash分区规划、链接脚本配置、核心跳转逻辑、中断向量表重定向、可靠的升级流程设计，并深入探讨了双备份与回滚机制以提升工业级可靠性。文章提供了可直接使用的代码框架，并分享了关键调试技巧，帮助开发者快速掌握STM32远程固件更新技术。阅读详情

fyming

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

gyg_123 2018-11-26

打赏
举报



CREATE TABLE [dbo].[S_SELECT](

	[ID] [int] IDENTITY(1,1) NOT NULL,

	[W1] [nvarchar](50) NULL,

	[W2] [nvarchar](50) NULL,

	[W3] [nvarchar](50) NULL,

	[W4] [nvarchar](50) NULL,

	[S] [nvarchar](max) NULL,

 CONSTRAINT [PK_S_SELECT_1] PRIMARY KEY CLUSTERED 

(

	[ID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [dbo].[S_SELECT] ON

INSERT [dbo].[S_SELECT] ([ID], [W1], [W2], [W3], [W4], [S]) VALUES (1, N'1', N'1', N'9', N'11', N'W1+W2+W3')

INSERT [dbo].[S_SELECT] ([ID], [W1], [W2], [W3], [W4], [S]) VALUES (2, N'5', N'6', N'7', N'37', N'-W1+W2*W3')

SET IDENTITY_INSERT [dbo].[S_SELECT] OFF







declare @A nvarchar(100)

declare @B int

declare  @num int 

set @num = ( select COUNT(*) from dbo.S_SELECT)-- print @num

declare @d  nvarchar(100)

declare @dd  nvarchar(100)

DECLARE @ID INT

declare @i int

set @i = 1

while(@i<=@num)

  begin

     exec select_ @i,@d output



			   if((select CHARINDEX('w1',@d))>0)

			   begin

			       set @d =( select REPLACE(@d,'w1',(( SELECT W1 from (select *,ROW_NUMBER()over(order by ID)as num FROM S_SELECT)as B where B.num=@i))))

	           end

	           --print @sql



	       --declare @sql nvarchar(100)='w1+w2'

	           if((select CHARINDEX('w2',@d))>0)

	           begin

	               set @d =( select REPLACE(@d,'w2',( SELECT W2 from (select *,ROW_NUMBER()over(order by ID)as num FROM S_SELECT)as B where B.num=@i)))

	           end

	           

	           if((select CHARINDEX('w3',@d))>0)

			   begin

			       set @d =( select REPLACE(@d,'w3',(( SELECT W3 from (select *,ROW_NUMBER()over(order by ID)as num FROM S_SELECT)as B where B.num=@i))))

	           end

		 print @d  

		 

		 set @A=@d

set @A=N'set @B=' + @A



exec sp_executesql @A,N'@B int output', @B output

print @B

		update  S_SELECT set W4 = @B WHERE ID = (SELECT  ID from (select *,ROW_NUMBER()over(order by ID)as num FROM S_SELECT)as B where B.num=@i)	 

		 set @i = @i+1	 

	 end

	 

	 SELECT * FROM  S_SELECT

education520 2018-11-24

打赏
举报

delete from cusDecStatusData where 1=1
--先锁定所有记录数大于1的数据
and entryId in(select entryId from cusDecStatusData group by entryId having count(entryId)>1)
--再锁定日期最大的那笔数据，如果有序列ID，用ID来区分先后最好了
and AddTime in(select max(AddTime) from cusDecStatusData group by entryId having count(entryId)>1)

吉普赛的歌版主 2018-11-20

打赏
举报

USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL 
	DROP TABLE t
GO
CREATE TABLE t(
	id INT IDENTITY(1,1) PRIMARY KEY
	, W1 INT
	,W2 INT
	,W3 INT
	,W4 INT
	,S NVARCHAR(30)
)
--
INSERT INTO t(W1,W2,W3,S)
SELECT 1,2,3,'W1+W2' UNION ALL
SELECT 1,1,1,'W2+W3' UNION ALL
SELECT 1,0,0,'W1*20+W2+W3-5'
GO
IF OBJECT_ID('Proc_Cal') IS NOT NULL 
	DROP PROC Proc_Cal
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE dbo.Proc_Cal
AS
BEGIN
	SET NOCOUNT ON;
	DECLARE @i INT,@imax INT,@w1 INT,@w2 INT,@w3 INT,@w4 int,@s NVARCHAR(MAX)
	SELECT @i=1,@imax=MAX(id) FROM t
	DECLARE @r TABLE (w4 INT)
	
	WHILE @i<=@imax
	BEGIN
		IF NOT EXISTS(SELECT 1 FROM t WHERE id=@i)
		BEGIN
			SET @i=@i+1;
			CONTINUE;
		END
		
		SELECT @w1=w1,@w2=w2,@w3=w3,@s=s FROM t WHERE id=@i
		SET @s='select @w4='+REPLACE(@s,'W','@w');
		EXEC sp_executesql @s,N'@w1 int,@w2 int,@w3 int,@w4 int out',@w1,@w2,@w3,@w4 OUT;
		
		UPDATE t SET w4=@w4 WHERE id=@i;
		SET @i=@i+1
	END
END
GO

--执行更新
EXEC Proc_Cal

--查询
SELECT * FROM t
/*
id          W1          W2          W3          W4          S
----------- ----------- ----------- ----------- ----------- ------------------------------
1           1           2           3           3           W1+W2
2           1           1           1           2           W2+W3
3           1           0           0           15          W1*20+W2+W3-5
*/

二月十六版主 2018-11-20

打赏
举报

DECLARE @sql nvarchar(max)=''

DECLARE CUR_B CURSOR FORWARD_ONLY FOR

SELECT 'UPDATE # SET W4 = ' + S + ' FROM B WHERE CURRENT OF CUR_B'

FROM #

;

OPEN CUR_B;

WHILE 1 = 1

BEGIN

    FETCH CUR_B INTO @sql;

    IF NOT @@FETCH_STATUS = 0 BREAK;

    EXEC(@sql);

END;

CLOSE CUR_B; DEALLOCATE CUR_B;



SELECT * FROM #

✦双11狂欢大促✦

急求SQL

相关推荐

双11狂欢大促