06 2010 档案
存储过程分页(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) 推荐(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... 阅读全文
posted @ 2010-06-11 22:03 fery