随笔分类 - SQLServer

SQLserver Delete from where 与Oracle delete from where 的差异

摘要：1.SQLserver 版本： select @@version; Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) Dec 28 2012 20:23:12 Copyright (c) Microsoft Corporation Enterpr 阅读全文

posted @ 2016-03-11 16:00 Alex-Zeng 阅读(5393) 评论(0) 推荐(0)

Sqlserver循环嵌套

摘要：1.游标的状态，游标的开启游标的选择都是需要注意的。USE [ccnu]GO/****** Object: StoredProcedure [dbo].[P_ADD_DATA_XSBLHYCQK] Script Date: 2015/2/13 10:32:46 ******/SET ANSI... 阅读全文

posted @ 2015-02-13 10:40 Alex-Zeng 阅读(2375) 评论(0) 推荐(0)