07 2012 档案

摘要：DECLARE @dt1 DATETIMESET @dt1='2013-01-01'insert into dd_trust_calendar(Date, SalesType)SELECT @dt1+number,case Datepart(weekday, convert(datetime,@dt1+number)-1) when 5 then 'pk' when 6 then 'spk' else 'std' end AS dtFROM master.dbo.spt_values AS aWHERE type='P&# 阅读全文

摘要：执行语句如下:SELECT * FROM OPENROWSET('MSDASQL','DRIVER={MySQL ODBC 5.1 Driver};SERVER=127.0.0.1;PORT=3306;DATABASE=test;USER=root;PASSWORD=123456;STMT=set names gb2312;OPTION=6049','select * from t_user')go 阅读全文

摘要：360浏览器用window.open的话，session会丢失要用window.location.href才能保存session到新窗口 阅读全文