- 博客(6)
- 资源 (5)
- 收藏
- 关注
RSS订阅原创 服务器端url,form操作方法,js输出方法等封装
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.Security;using System.Web.UI.WebControls;namespace Test{ ///
2012-10-29 13:58:22
476
原创 根据名称检索存储过程内容和根据内容检索存储过程
-- GetContentByProcedureName '[dbo].[存储过程名]'ALTER procedure [dbo].[GetContentByProcedureName](@ProcedureName nvarchar(500))as if exists (select * from dbo.syscomments where id=object_id(N'
2012-10-26 11:13:25
497
原创 查询sql数据库中的所有表和表描述
获取数据库中所有的表select name as tablename, isnull((select value from sys.extended_properties where sysobjects.id=major_id and minor_id=0),'') as tabledesc from sysobjects where type='U' and name 根据
2012-10-22 13:57:29
1160
原创 检索数据库中有哪些触发器
select * from dbo.sysobjects where deltrig0 or updtrig select name, text ,o.xtype from sysobjects o, syscomments s where o.id = s.id and o.xtype like '%tr%'
2012-10-22 13:12:27
355
原创 根据文本来检索存储过程
ALTER procedure [dbo].[GetSPFNNameContainText]( @text varchar(500))as select name, text from sysobjects o, syscomments s where o.id = s.id and text like '%'+@text
2012-10-17 14:11:00
475
原创 表的数据插入相关操作(identity,临时表,获取表列)
alter procedure [dbo].[xxxx]( @newDatabaseName varchar(500), -- cn new database @oldDatabaseName varchar(500)--us database)asbegin /*TEST DATA set @newDatabaseName='[eData_wqlNew]'; s
2012-10-16 17:20:51
1137
1
SharePoint_2010_Developer_Walkthrough_Guide.pdf
2011-08-24
SharePoint_2010_Developer_Evaluation_Guide.pdf
2011-08-24
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人