본문 바로가기
[MS SQL]Transaction begin tran --트랜잭션 시작 commit tran --트랜잭션 완료 rollback tran --트랜잭션 취소 select @@error --에러 count CREATE proc tran01 @tbname varchar(10), @types varchar(5), @comment varchar(20) AS begin tran INSERT tableinfo(tbname, comment, types) VALUES(@tbname, @comment, @types) IF @@error>0 --오류가 발생하면 begin print '오류방생!' rollback tran end else begin print '제대로 실행!' commit tran end exec tran01 'aaa','board','테스트' 더보기
[java] sendMail with attached file http://www.okjsp.pe.kr/lecture/lec02/javamail03.htm 더보기
[SQL Server] 날짜 연산 DATEDIFF() http://technet.microsoft.com/ko-kr/library/ms189794.aspx DATEDIFF ( datepart , startdate , enddate ) :int DATEADD() http://technet.microsoft.com/ko-kr/library/ms186819.aspx DATEADD (datepart , number , date ) :date datepart약어 year yy, yyyy quarter qq, q month mm, m dayofyear dy, y day dd, d week wk, ww hour hh minute mi, n second ss, s millisecond ms microsecond mcs nanosecond ns 더보기

티스토리툴바