抽空写完啦~写完后发现用了好多知识点~
不容易啊~~
还写了个很好用的函数~~
麻烦大家测测~~
CREATE FUNCTION f_ww(@var varchar(50),@vs varchar(50))
RETURNS char(1)
AS
begin
if len(@var) <> len(@vs)
RETURN 'F '
declare @str varchar(50),@char varchar(10)
declare @varcharint int,@vscharint int
declare @varstr varchar(50),@vsstr varchar(50)
set @[email protected]+ ', '
while charindex( ', ',@str)> 0
begin
select @char=substring(@str,0,charindex( ', ',@str)),
@str=substring(@str,charindex( ', ',@str)+1,len(@str)-charindex( ', ',@str)),
@varcharint=0,@vscharint=0,
@varstr= ', '[email protected]+ ', ', @vsstr= ', '[email protected]+ ', '
while(charindex( ', '[email protected]+ ', ',@varstr))> 0
begin
select @[email protected]+1,
@varstr=substring(@varstr,charindex( ', '[email protected]+ ', ',@varstr)+1+len(@char),len(@varstr))
end
while(charindex( ', '[email protected]+ ', ',@vsstr))> 0
begin
select @[email protected]+1,
@vsstr=substring(@vsstr,charindex( ', '[email protected]+ ', ',@vsstr)+1+len(@char),len(@vsstr))
end
if(@varcharint <> @vscharint)
RETURN 'F '
end
RETURN 'T '
end
alter proc p_ww
@instr varchar(50),
@incount int
as
begin
declare @thestr varchar(50)
set @[email protected]+ ', '
create table #number(id varchar(5))
while (select count(1) from #number) <4
begin
insert into #number select substring(@thestr,0,charindex( ', ',@thestr))
set @thestr=substring(@thestr,charindex( ', ',@thestr)+1,len(@thestr))
end
create table #count(ctid varchar(5))
insert into #count select '+ '
union all select '- '
union all select '* '
union all select '/ '
select identity(int,1,1) id,
aid+b.ctid+ '( '+bid+c.ctid+ '( '+cid+d.ctid+did+ ')) '[mula1],
aid+b.ctid+ '(( '+bid+c.ctid+cid+ ') '+d.ctid+did+ ') '[mula2],
'( '+aid+b.ctid+bid+ ') '+c.ctid+ '( '+cid+d.ctid+did+ ') '[mula3],
'(( '+aid+b.ctid+bid+ ') '+c.ctid+cid+ ') '+d.ctid+did [mula4],
'( '+aid+b.ctid+ '( '+bid+c.ctid+cid+ ')) '+d.ctid+did[mula5]
into #wei
from(select DISTINCT a.id+ '.0 ' [aid],b.id+ '.0 ' [bid],c.id+ '.0 ' [cid],d.id+ '.0 ' [did]
from #number a,#number b,#number c,#number d
where dbo.f_ww(a.id+ ', '+b.id+ ', '+c.id+ ', '+d.id,@instr)= 'T ')a,
#count b,#count c,#count d
create table #show(id int,colname varchar(10),result dec(18,3))
declare @int int,@mula1 varchar(50),@mula2 varchar(50),@mula3 varchar(50),@mula4 varchar(50),@mula5 varchar(50)
set @int=1
while @int <=(select max(id)from #wei)
begin
select @mula1=[mula1],
@mula2=[mula2],
@mula3=[mula3],