SQL SERVER
文章平均质量分 76
ceozhg2009
这个作者很懒,什么都没留下…
展开
-
SQL 存储过程示例01
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO----将DCM中的系统用户资料同步到WebOrder用户表ALTER PROCEDURE [dbo].[SP_WO_SYNC_SYS_USERS] ( @IsFirst int, --是否是第一次导入 @WebOrderDBName nvarchar(50) --原创 2012-02-01 09:12:53 · 311 阅读 · 0 评论 -
SQL 存储过程示例02
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO--获取销售订单编号ALTER PROCEDURE [dbo].[DCM_GenerateSaleOrderNo] ASDECLARE @ErrorCode nvarchar(10)DECLARE @ErrorMsg nvarchar(255)DECLARE @OrderN原创 2012-02-01 09:14:39 · 194 阅读 · 0 评论 -
将表中数据转换成Insert语句
/****** Object: StoredProcedure [dbo].[spGenInsertSQL] Script Date: 02/01/2012 10:48:38 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER procedure [dbo].[spGenInsertSQL] @tablen转载 2012-02-01 10:47:05 · 482 阅读 · 0 评论 -
SQL Function示例程序01
/****** Object: UserDefinedFunction [dbo].[GetActualBaseSalary] Script Date: 02/01/2012 10:52:12 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO--获取员工实际底薪--@oid 促销员号--@caculate_end_d原创 2012-02-01 10:54:11 · 339 阅读 · 0 评论 -
SQL Procedure示例程序03
ALTER PROCEDURE [dbo].[AssignAreaRightToUsers] ASBEGIN -- 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 · 244 阅读 · 0 评论 -
SQL Procedure示例程序01
/****** Object: StoredProcedure [dbo].[SP_HRXZ_CACULATE_ITEMS] Script Date: 02/01/2012 10:50:37 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[SP_HRXZ_CACU原创 2012-02-01 10:48:55 · 475 阅读 · 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 · 530 阅读 · 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 · 461 阅读 · 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 · 274 阅读 · 0 评论