![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SqlServer
文章平均质量分 63
新一人
君子之道,辟如行远必自逊,辟如登高必自卑
展开
-
sqlserver 中的游标
DECLARE @DeviceID bigint,@MaterialID bigint DECLAREMy_Cursor CURSOR --定义游标FOR ( SELECT device_id, material_id FROM [dbo].[tablename] ) OPEN My_Cursor;--打开游标FETCH NEXT FROM My_Cursor INTO @DeviceID,@MaterialID;--读取第一行数据WHILE @@FETCH_STATUS = 0 BEGIN原创 2022-05-28 16:29:33 · 8364 阅读 · 0 评论 -
SqlServer存储器创建
前提 创建表,并插入数据IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[User]') AND type IN ('U')) DROP TABLE [dbo].[User]GOCREATE TABLE [dbo].[User] ( [id] int NOT NULL, [name] nchar(10) COLLATE Chinese_原创 2021-07-17 21:22:26 · 447 阅读 · 0 评论 -
SQLServer 和Mysql左连接,右连接,内连接,全连接
前提创建员工表CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '员工姓名', `dpid` int(11) NULL DEFAULT NULL COMMENT '部门id', PRIMARY KEY (`id`原创 2021-07-06 00:06:45 · 709 阅读 · 0 评论