- 博客(5)
- 收藏
- 关注
RSS订阅原创 ASP:JMail
Set jmail = Server.CreateObject("JMail.Message") jmail.From =" ittest@163.com "jmail.AddRecipientCC "bb@163.com "Mail.AddAddress "aa@163.com"jmail.Subject="For JMail Test"jmail.Encoding = "base64"
2008-05-02 12:17:00
349
原创 ASP:ASPMAIL
Set Mail = Server.CreateObject("Persits.MailSender") Mail.From= "ittest@163.com" Mail.AddCC "bb@163.com","bb" Mail.AddAddress "aa@163.com","aa" Mail.Subject = "asp mail test"Mail.IsHTML = True
2008-05-02 12:09:00
487
原创 SQL_SP:CrossTable(Rows change to Columns)
CREATE PROCEDURE rowchgtocol ASset nocount oncreate table #tblA( [logrecid] [numeric](18, 0) IDENTITY (1, 1) NOT NULL , BH char(3) not null, GZLB varchar(3) not null, JE int, )
2008-05-02 12:01:00
365
原创 SQL_SP:COMPARE WITHIN TWO TABLES
CREATE procedure sp_Compare ( @TableA varchar(50), @TableB varchar(50), @ExcludeFields varchar(255), @JoinFields varchar(255), @CompType int = 0, @debug bit = 0 )asbegin --
2008-05-02 11:41:00
364
原创 SQL_SP:分頁
CREATE PROCEDURE sp_pagination(@SQL nVARCHAR(4000), --不带排序语句的SQL语句@Page int, --页码@RecsPerPage int, --每页容纳的记录数@ID VARCHAR(255), --需要排序的不重复的ID号@Sort VARCHAR(255) --排序字段及规则)ASDECLARE @Str nVARCHAR(4000)
2008-05-02 11:37:00
257
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人