![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQLSERVER2005
文章平均质量分 81
bobo_mayday
这个作者很懒,什么都没留下…
展开
-
sql2005带参数的分页存储过程
<br />USE [CustomerManagementCenter]<br />GO<br />/****** Object: StoredProcedure [dbo].[sp_SearchCustomers] Script Date: 11/01/2010 13:51:23 ******/<br />SET ANSI_NULLS ON<br />GO<br />SET QUOTED_IDENTIFIER ON<br />GO<br />-- =========================原创 2010-12-01 17:15:00 · 461 阅读 · 1 评论 -
CMC项目总结
1:TextBoxWatermarkExterder 属性:watermarktext="默认提示" 当鼠标离开焦点后 自动提示但是在做搜索查询的时候要去做判断2:只能输入数字:FilteredTextBoxExtender 3:刷新加载时候小菊花:原创 2010-12-30 14:15:00 · 944 阅读 · 0 评论 -
sqlserver2005多选,多条件查询存储过程
<br />USE [CustomerManagementCenter]<br />GO<br />/****** Object: StoredProcedure [dbo].[sp_ManyIfSearch] Script Date: 12/30/2010 14:27:00 ******/<br />SET ANSI_NULLS ON<br />GO<br />SET QUOTED_IDENTIFIER ON<br />GO<br />ALTER PROCEDURE [dbo].[sp_ManyI原创 2010-12-30 14:28:00 · 2017 阅读 · 1 评论 -
AspNetPager控件分页存储过程
<br />USE [CustomerManagementCenter]<br />GO<br />/****** Object: StoredProcedure [dbo].[sp_SelectGroupNameByPage] Script Date: 12/30/2010 14:25:03 ******/<br />SET ANSI_NULLS ON<br />GO<br />SET QUOTED_IDENTIFIER ON<br />GO<br /> <br />ALTER PROCEDUR原创 2010-12-30 14:26:00 · 338 阅读 · 0 评论 -
存储过程分页
<br />USE [CustomerManagementCenterTest]<br />GO<br />/****** Object: StoredProcedure [dbo].[sp_QueryCityInformationByPage] Script Date: 03/16/2011 12:04:04 ******/<br />SET ANSI_NULLS ON<br />GO<br />SET QUOTED_IDENTIFIER ON<br />GO<br />-- ==========原创 2011-03-16 16:43:00 · 292 阅读 · 0 评论 -
CMC插入查询
<br />set ANSI_NULLS ON<br />set QUOTED_IDENTIFIER ON<br />go<br /><br />-- =============================================<br />-- Author: <Andy Shen><br />-- Create date: <2010-11-22><br />-- Description: <查询客户基础表的信息再插入到客户关系表中并且去重><br />--原创 2011-05-05 11:01:00 · 510 阅读 · 0 评论