11 2011 档案
摘要：-- ALTER SCHEMA 新架构 TRANSFER 旧架构.对象名称ALTER SCHEMA [dbo] TRANSFER espow.[TransactionsList]
阅读全文
摘要：--提取分页数据，返回总记录数createprocedure Proc_GetDataPaging_ReturnDataCount(@SqlString varchar(6000), --查询语句@PageNumber int,--当前的页码@PageSize int, --每页显示的数据量@SequenceField varchar(100), --排序字段@DataCount int out --总数据量)asbegin--提取总记录数declare @Sql nvarchar(2000)set @Sql = N'select @countNum = count(1) from (
阅读全文
摘要：/// <summary> /// 线程给lable赋值 /// </summary> /// <param name="value"></param> private delegate void SetTextDelegate(string value); private void WriteLabel(string s) { if (label1.InvokeRequired) { SetTextDelegate d = new SetTextDelegate(WriteLabel); label1.Invoke(d, n
阅读全文
摘要：--新增表字段ALTER procedure [dbo].[sp_Web_TableFiled_Insert](@TableName varchar(100),@FieldName varchar(100),@FieldExplain varchar(200),@DataType varchar(100),@ConnectTableName varchar(100),@FieldLength int,@NewsID int output)asbegin transaction mytrandeclare @errorSum intif not exists (SELECT * FROM sys
阅读全文
