专注于互联网--专注于架构

最新标签
网站地图
文章索引
Rss订阅
<!--# file="inc/conn.asp"--> <% dim rs,sql,filename,fso,myfile,x Set fso = server.CreateObject("scripting.filesystemobject") filename = Server.MapPath("download.txt") fso.FileExists(filename) then fso.DeleteFile(filename) end '--创建txt文件 myfile = fso.CreateTextFile(filename,tru [阅读全文] [PDF]
/*三明电力临时卡处理SQL代码,临时卡为专门一类卡,消费时五折优惠,月消费有限额,采取策略是“钱多存,消费少报”*/SELECT dbo.T_Station.StatName AS 工作站, dbo.T_Cashiers.Name AS 出纳员, lll.OpDt AS 日期, lll.InFare AS 存款额, lll.InCount AS 存款次数, lll.OutFare AS 取款额, lll.OutCount AS 取款次数, ISNULL(lll.suminfare, 0) / 2 AS 让利额, ISNULL( [阅读全文] [PDF]
//第一种写法:MM_conn_STRING = \"Driver={SQL Server};server=(local);uid=sa;pwd=;database=infs;\"Set conn = Server.Createobject(\"ADODB.Connection\")conn.open MM_conn_STRINGSET RS=SERVER.CreateObject(\"ADOBD.recordset\")SQL=\"SELECT * FROM TABLE ORDER BY ID DESC\"RS.open SQL, [阅读全文] [PDF]
1 共3条 分1页