MsSql - 随笔分类(第5页) - chengjunde

ERP存储过程

摘要：[dbo].[st_MES_MonitorMachine]--------------------------------------------USE [ChiefMESNew]GO/****** Object: StoredProcedure [dbo].[st_MES_MonitorMach... 阅读全文

posted @ 2015-05-15 17:59 chengjunde 阅读(751) 评论(0) 推荐(0)

SQL存储过程调试

摘要：转自：http://www.cnblogs.com/xiangzhong/archive/2012/10/27/2742974.html今天突然有同事问起，如何在sqlserver中调试存储过程（我们公司使用的是sqlserver 2008 R2），猛地一看，和以前使用sqlserver 2000真... 阅读全文

posted @ 2015-05-13 18:00 chengjunde 阅读(323) 评论(0) 推荐(0)

MSSQL CharIndex()用法

摘要：CHARINDEX函数返回字符或者字符串在另一个字符串中的起始位置。CHARINDEX ( expression1 , expression2 [ , start_location ] )expression1是要到expression2中寻找的字符中，start_location是CHARINDE... 阅读全文

posted @ 2015-05-13 16:57 chengjunde 阅读(277) 评论(0) 推荐(0)

Erp:原料投入产出报表

摘要：USE [ChangHongWMS612]GO/****** Object: StoredProcedure [dbo].[st_WMS_RptMaterialInOutDaily] Script Date: 05/12/2015 17:24:27 ******/SET ANSI_NULLS... 阅读全文

posted @ 2015-05-12 17:55 chengjunde 阅读(852) 评论(0) 推荐(0)

union all 简单用法

摘要：select Y.ID,sum(cast(Y.m as int)) as hefrom(select top 10 a.ID,a.AlarmSource as m from dbo.AlarmInfo aunion allselect top 10 B.ID,B.AssetCode as m fro... 阅读全文

posted @ 2015-05-12 17:49 chengjunde 阅读(571) 评论(0) 推荐(0)

带有游标的应用的存储过程

摘要：USE [ChiefMes]GO/****** Object: StoredProcedure [dbo].[SELECT_TotalNum] Script Date: 05/12/2015 09:08:46 ******/SET ANSI_NULLS ONGOSET QUOTED_IDEN... 阅读全文

posted @ 2015-05-12 16:07 chengjunde 阅读(399) 评论(0) 推荐(0)

SQL批量删除与批量插入

摘要：批量删除：DELETE FROM MyTable WHERE ID IN (1,2);批量插入：INSERT INTO MyTable(ID,NAME) VALUES(1,'123');INSERT INTO MyTable(ID,NAME) VALUES(2,'456');INSERT INTO ... 阅读全文

posted @ 2015-05-12 14:19 chengjunde 阅读(535) 评论(0) 推荐(0)

表与表不同条件下的关联SQL

摘要：USE [ChiefMes]GO/****** Object: StoredProcedure [dbo].[Kenta_RptEmpOEE] Script Date: 05/12/2015 13:52:00 ******/SET ANSI_NULLS ONGOSET QUOTED_IDEN... 阅读全文

posted @ 2015-05-12 14:03 chengjunde 阅读(598) 评论(0) 推荐(0)

单表的自修改与自插入数据（重要）

摘要：USE [ChiefMes]GO/****** Object: StoredProcedure [dbo].[Kenta_UpandAddEmpOEEConfig] Script Date: 05/12/2015 08:34:00 ******/SET ANSI_NULLS ONGOSET ... 阅读全文

posted @ 2015-05-12 12:53 chengjunde 阅读(268) 评论(0) 推荐(0)

Row_Number()over(order by....) as

摘要：出自：http://www.2cto.com/database/201307/227103.htmlSql Server Row_Number()学习Row_Number()：row_number()主要是为选出的每一条记录按照一定的排序方式生成一个行序号。语法：1ROW_NUMBER ( ) OV... 阅读全文

posted @ 2015-04-23 18:47 chengjunde 阅读(6451) 评论(0) 推荐(0)

复杂报表的存储过程

摘要：USE [MoponZhongYingGroup_cs]GO/****** Object: StoredProcedure [dbo].[TempCountCimetomg] Script Date: 12/24/2014 15:24:58 ******/SET ANSI_NULLS ONG... 阅读全文

posted @ 2014-12-24 17:59 chengjunde 阅读(366) 评论(0) 推荐(0)

带有分页的存储过程

摘要：-- -- CREATE PROCEDURE [control].[mp_GetSellerTerminalList_Temp] @Svalidtime DATETIME, /*验证开始时间*/ @Evalidtime DATETIME, /*验证结束时间*/ @CurrentPage int, / 阅读全文

posted @ 2014-12-18 14:24 chengjunde 阅读(339) 评论(0) 推荐(0)

应用临时表的存储过程

摘要：CREATE procedure [control].[mp_GetSellerTerminalList_Export] ( @Svalidtime nvarchar(30), @Evalidtime nvarchar(30), @UseStatus ... 阅读全文

posted @ 2014-12-18 14:19 chengjunde 阅读(184) 评论(0) 推荐(0)

chengjunde

随笔分类 - MsSql