SQL SERVER
文章平均质量分 76
ceozhg2009
这个作者很懒,什么都没留下…
展开
-
SQL 存储过程示例01
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ----将DCM中的系统用户资料同步到WebOrder用户表 ALTER PROCEDURE [dbo].[SP_WO_SYNC_SYS_USERS] ( @IsFirst int, --是否是第一次导入 @WebOrderDBName nvarchar(50) --原创 2012-02-01 09:12:53 · 315 阅读 · 0 评论 -
SQL 存储过程示例02
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO --获取销售订单编号 ALTER PROCEDURE [dbo].[DCM_GenerateSaleOrderNo] AS DECLARE @ErrorCode nvarchar(10) DECLARE @ErrorMsg nvarchar(255) DECLARE @OrderN原创 2012-02-01 09:14:39 · 199 阅读 · 0 评论 -
将表中数据转换成Insert语句
/****** Object: StoredProcedure [dbo].[spGenInsertSQL] Script Date: 02/01/2012 10:48:38 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[spGenInsertSQL] @tablen转载 2012-02-01 10:47:05 · 491 阅读 · 0 评论 -
SQL Function示例程序01
/****** Object: UserDefinedFunction [dbo].[GetActualBaseSalary] Script Date: 02/01/2012 10:52:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO --获取员工实际底薪 --@oid 促销员号 --@caculate_end_d原创 2012-02-01 10:54:11 · 345 阅读 · 0 评论 -
SQL Procedure示例程序03
ALTER PROCEDURE [dbo].[AssignAreaRightToUsers] AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; DECLARE @CustomerID原创 2012-02-01 11:06:45 · 250 阅读 · 0 评论 -
SQL Procedure示例程序01
/****** Object: StoredProcedure [dbo].[SP_HRXZ_CACULATE_ITEMS] Script Date: 02/01/2012 10:50:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[SP_HRXZ_CACU原创 2012-02-01 10:48:55 · 487 阅读 · 0 评论 -
SQL Procedure示例程序02
ALTER PROCEDURE [dbo].[SP_HRXZ_GetRptSalaryReportList] ( @PACKAGE_ID VARCHAR(50), @REGION_CODE NVARCHAR(100), @AREA_NAME NVARCHAR(100), @OUTLET_NAM原创 2012-02-01 10:57:15 · 537 阅读 · 0 评论 -
SQL Procedure示例程序04
CREATE procedure [dbo].[eosp_CreateEPOS_CARD] ( @cC_NO VarChar(30), @cC_DATE DateTime, @sTATUS Char(1), @lAST_PAY_TIME DateTime, @oRDER_NUMBER VarChar(12), @pAN VarChar(19), @eXPIREDDATE Char(10), @cV原创 2012-02-01 11:11:54 · 466 阅读 · 0 评论 -
SQL 文件内容存储表 创建索引
exec sp_fulltext_database 'enable' exec sp_fulltext_catalog 'CATE_DOC_FILES', 'create' exec sp_fulltext_table 'CM_BSS_DOCFILES', 'create', 'CATE_DOC_FILES', 'PK_C' exec sp_fulltext_column 'CM_BSS原创 2012-02-02 09:16:30 · 280 阅读 · 0 评论