11,850
社区成员




declare @t varchar(max)
set @t=
'
EXEC dbo.sp_executesql @statement = ''N--============
--作 者:abc
--创建日期:2008-10-25
--功 能:返回所有单据编号的存储过程
--最后修改日期:2008-10-25
--drop procedure p_get_bill_code
--=================
CREATE procedure [dbo].[p_get_bill_code]
@billcode varchar(50) output,
@table_name varchar(50),
@code_fieldname varchar(50),
@prefix varchar(50) = '''' --前缀,默认为空
as begin
--set nocount on
declare @max_code varchar(50)
declare @str_number varchar(50)
declare @sql varchar(2000)
'
select * into #t from [dbo].[m_split](@t,char(13)) where col<>''
update #t
set col=left(col,case charindex('--',col)
when 0 then len(col) else charindex('--',col)-1 end)
declare @sql varchar(max) set @sql=''
select @sql=@sql+col+char(13) from #t
where col<>'' and col<>char(13) and col<>char(9) and col<>char(10)
select @sql
/*
EXEC dbo.sp_executesql @statement = 'N
CREATE procedure [dbo].[p_get_bill_code]
@billcode varchar(50) output,
@table_name varchar(50),
@code_fieldname varchar(50),
@prefix varchar(50) = ''
as begin
declare @max_code varchar(50)
*/
drop table #t
/*
create function [dbo].[m_split](@c varchar(2000),@split varchar(2))
returns @t table(col varchar(200))
as
begin
while(charindex(@split,@c)<>0)
begin
insert @t(col) values (substring(@c,1,charindex(@split,@c)-1))
set @c = stuff(@c,1,charindex(@split,@c),'')
-- SET @c = substring(@c,charindex(' ',@c)+1,len(@c))
end
insert @t(col) values (@c)
return
end
*/
declare @t varchar(max)
set @t=
'
EXEC dbo.sp_executesql @statement = ''N--============
--作 者:abc
--创建日期:2008-10-25
--功 能:返回所有单据编号的存储过程
--最后修改日期:2008-10-25
--drop procedure p_get_bill_code
--=================
CREATE procedure [dbo].[p_get_bill_code]
@billcode varchar(50) output,
@table_name varchar(50),
@code_fieldname varchar(50),
@prefix varchar(50) = '''' --前缀,默认为空
as begin
--set nocount on
declare @max_code varchar(50)
declare @str_number varchar(50)
declare @sql varchar(2000)
'
select * into #t from [dbo].[m_split](@t,char(13)) where col<>''
update #t
set col=left(col,case charindex('--',col)
when 0 then len(col) else charindex('--',col)-2 end)
declare @sql varchar(max) set @sql=''
select @sql=@sql+col+char(13) from #t
where col<>'' and col<>char(13) and col<>char(9) and col<>char(10)
select @sql
/*
EXEC dbo.sp_executesql @statement = '
CREATE procedure [dbo].[p_get_bill_code]
@billcode varchar(50) output,
@table_name varchar(50),
@code_fieldname varchar(50),
@prefix varchar(50) = ''
as begin
declare @max_code varchar(50)
declare
*/
drop table #t