ad13adsa的博客

class MysqlClass { private MySqlConnection SqlConn; public MysqlClass(string ServerIp,string Port, string SQLUserName, string SQLUserPass, string DataBase) { t...

SELECTCONVERT(varchar(100),GETDATE(),0):0516200610:57AMSELECTCONVERT(varchar(100),GETDATE(),1):05/16/06SELECTCONVERT(varchar(100),GETDATE(),2):06.05.16SELECTCONVERT(varchar(100),GETDA...

BEGIN TRY begin tran --开启事务 insert into xx commit transaction --提交事务，执行sql end try begin catch rollback transaction-- 回滚事务 end catch...

update table1set field1=table2.field1,field2=table2.field2 from table2 where table1.id=table2.idupdate d set d.iprice=b.iprice,d.iunitcost=d.iprice/d.iquantity from rdrecord a,rdrecords b,rdrecord ...

DECLARE MyCursor CURSOR FOR /*定义游标*/select count(*) as irowno,dls.DLID from DispatchLists dls where dls.DLID in (select dl.DLID from DispatchList dl where (dl.dDate <= '2014-12-31')) group by...