存储过程分页(sql2005)
摘要:create database Teston primary ( name='Test_Data.mdf', filename='D:\我的资料\sql\备份\Test_Data.mdf')log on( name='Test_Data.ldf', filename='D:\我的资料\sql\备份\Test_Data.ldf')if object_id('tb') is not null drop...
阅读全文
posted @
2010-06-27 09:47
fery
阅读(293)
推荐(0)
分隔字符串
摘要:IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE OBJECT_ID = OBJECT_ID(N'[dbo].[SplitByChar]') AND TYPE IN(N'FN',N'IF',N'TF',N'FS',N'FT'))DROP FUNCTION [dbo].[SplitByChar]GOCREATE FUNCTION [dbo].[SplitByChar...
阅读全文