摘要：SELECT 表名=case when a.colorder=1 then d.name else '' end, 表说明=case when a.colorder=1 then isnull(f.value,'') else '' end, 字段序号=a.colorder, 字段名=a.name, 标识=case when COLUMNPROPERTY( a.id,a.name,'IsIden... 阅读全文

摘要：前期准备如下： /**//*插入30万条记录模拟分页操作*/create table Table_A( [Guid] [nvarchar] (40) NOT NULL DEFAULT (newid()), Client_ID nvarchar(8), Client_Name nvarchar(8), Client_Age int)select * from Table_A... 阅读全文

摘要：1if 2exists 3( 4select * 5from dbo.sysobjects 6where id = object_id(N'[dbo].[t]') and OBJECTPROPERTY(id, N'IsUserTable') = 1 7) 8drop table [dbo].[t] 9GO 10 11CREATE TABLE [dbo].[t] ( 12... 阅读全文

摘要：CREATE function dbo.f_split(@SourceSql varchar(8000),@StrSeprate varchar(10))returns @temp table(sqlstr varchar(100))--实现split功能 的函数--date :2005-5-30--Author :as begin declare @i int set @S... 阅读全文