SQL Server static page export Technology 3

server| static | page border= "BORDER" align= "CENTER" ><th><tr>' Year ' + @yue + ' month Else
INSERT INTO # #daylist
VALUES (' </tr></table><table border= "BORDER" align= "CENTER" ><th><tr>CONVERT (varchar (4), @year) + ' year ' + @yue + ' month End
If @tt <>0
If @xingqi < 7
Set @outchar = @outchar + ' <td><a href= ' + @date + '/index.htm ' target= ' new ' > ' +convert (varchar (2), @ri) + ' < /a></td> '
Else
Set @outchar = @outchar + ' <td><a href= ' + @date + '/index.htm ' target= ' new ' > ' +convert (varchar (2), @ri) + ' < /a></td></tr><tr> '
Else
Begin
Set @tt =1
Set @outchar =
Case
When @xingqi =1 then '
When @xingqi =2 then ' <td></td> '
When @xingqi =3 then ' <td></td><td></td> '
When @xingqi =4 then ' <td></td><td></td><td></td> '
When @xingqi =5 then ' <td></td><td></td><td></td><td></td> '
When @xingqi =6 then ' &LT;TD&GT;&LT;/TD&GT;&LT;TD&GT;&LT;/TD&GT;&LT;TD&GT;&LT;/TD&GT;&LT;TD&GT;&LT;/TD&GT;&LT;TD ></td> '
When @xingqi =7 then ' &LT;TD&GT;&LT;/TD&GT;&LT;TD&GT;&LT;/TD&GT;&LT;TD&GT;&LT;/TD&GT;&LT;TD&GT;&LT;/TD&GT;&LT;TD ></td><td></td> '
End
If @xingqi < 7
Set @outchar = @outchar + ' <td><a href= ' + @date + '/index.htm ' target= ' new ' > ' +convert (varchar (2), @ri) + ' < /a></td> '
Else
Set @outchar = @outchar + ' <td><a href= ' + @date + '/index.htm ' target= ' new ' > ' +convert (varchar (2), @ri) + ' < /a></td></tr><tr> '
End

INSERT INTO # #daylist values (@outchar)

Set @yue2 = @yue
Set @outchar = '

Fetch POINT3 into
@dy, @date, @yue, @ri, @xingqi, @year
End
Close Point3
Deallocate Point3

Execute sp_makewebtask
@outputfile = ' d:\test\daylist.htm ',
@query = ' select * from # #daylist ',
@templatefile = ' d:\test\rili.tml ',
@codepage =936
drop TABLE # #daylist
First, ask the reader to read through the above code to get a general idea of it. Under