CREATE trigger [dbo].[Trigger_EX] on [dbo].[TABLE] for update as Declare @user_id varchar(20) Declare @result int Declare @stat_status int set @user_id = (select user_id from inserted) set @result = (select result from inserted) set @stat_status = (select stat_status from inserted) -- if UPDATE(컬럼명) 이런식으로도 가능 if @stat_status = 3 and @result <> 2 begin 사용 소스 작성 end
DECLARE @PHONE_NUMBER varchar(50) DECLARE @DEST_INFO varchar(5000) DECLARE @i int DECLARE SelectCursor CURSOR FAST_FORWARD GLOBAL FOR select cast(DEST_INFO as varchar) from send OPEN SelectCursor FETCH NEXT FROM SelectCursor INTO @PHONE_NUMBER -- 위쿼리의 값이 @PHONE_NUMBER에 입력된다. WHILE @@FETCH_STATUS <> -1 -- record가 존재하지 않을때 까지 Begin If @@FETCH_STATUS <> -2 --record가 없을경우 Begin End FETCH NEXT FROM SelectCursor INTO @PHONE_NUMBER If @@FETCH_STATUS <> 0 -- record가 존재할때 Begin End End CLOSE SelectCursor; DEALLOCATE SelectCursor;
select a.constraint_name, a.table_name, a.column_name, a.position, b.constraint_type, search_condition, r_owner, r_constraint_name, status from user_cons_columns a, user_constraints b where a.constraint_name = b.constraint_name and a.table_name = '&table_name'
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<style type="text/css">
HTML
{
scrollbar-face-color: #FFFFFF;
scrollbar-highlight-color:#bfbfbf;
scrollbar-3dlight-color: #ffffff;
scrollbar-shadow-color:#bfbfbf;
scrollbar-darkshadow-color: #FFFFFF;
scrollbar-track-color: #FFFFFF;
scrollbar-arrow-color: #bfbfbf;
}
# 다른색상
HTML
{
scrollbar-face-color:#EDEDED;
scrollbar-highlight-color:#FFFFFF;
scrollbar-3dlight-color:#FFFFFF;
scrollbar-shadow-color:#C3C3C3;
scrollbar-darkshadow-color:#C3C3C3;
scrollbar-track-color:#EDEDED;
scrollbar-arrow-color:#EAEAFF;
}
</style>
</head>
<body>
</body>
</html><SPAN id=tx_marker_caret></SPAN><textarea name="text" errname="text" mandatory="yes" style="IME-MODE:active;" maxbytelength="4000"> 페이지 로딩시 기본 한글로 입력됨! </textarea>
<body oncontextmenu="return false" ondragstart="return false" onselectstart="return false ">
<input type="text"
onkeyPress="if ((event.keyCode<48) || (event.keyCode>57)) event.returnValue=false;"
style="ime-mode:disabled;" />
사용이 베리 이지한 터미널 프로그램
원래 ssh를 써었는데 딱 한번 사용해보고
이걸로 바꿨다..
<%@ taglib uri="/WEB-INF/struts-tiles.tld" prefix="tiles"%>
PineTerm206.zip
<taglib>
<taglib-uri>/WEB-INF/tld/struts-tiles.tld</taglib-uri>
<taglib-location>/WEB-INF/tld/struts-tiles.tld</taglib-location>
</taglib>
<action path="/main1" forward=".main1" /> <action path="/menu1" forward=".submenu1" /> <action path="/menu2" forward=".submenu2" />* 본인은 struts URL 설정에서 *.do로 해두었다.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE tiles-definitions PUBLIC
"-//Apache Software Foundation//DTD Tiles Configuration 1.1//EN"
"http://jakarta.apache.org/struts/dtds/tiles-config_1_1.dtd">
<tiles-definitions>
<definition name=".main1" path="/Layout.jsp">
<put name="title" value="안냐세요" />
<put name="header" value="/header.jsp" />
<put name="menu" value="/menu.jsp" />
<put name="footer" value="/footer.jsp" />
<put name="body" value="/body.jsp" />
</definition>
<definition name=".submenu1" extends=".main1">
<put name="body" value="menu1.jsp" />
</definition>
<definition name=".submenu2" extends=".main1">
<put name="body" value="menu2.jsp" />
</definition>
</tiles-definitions>
<%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%>
<%@ taglib uri="/WEB-INF/tld/struts-tiles.tld" prefix="tiles"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>Insert title here</title>
</head>
<body>
<h1><tiles:getAsString name="title" /></h1>
<table border="1" width="100%">
<tr>
<td colspan="2"><tiles:insert attribute="header" /></td>
</tr>
<tr>
<td width="140"><tiles:insert attribute="menu" /></td>
<td><tiles:insert attribute="body" /></td>
</tr>
<tr>
<td colspan="2"><tiles:insert attribute="footer" /></td>
</tr>
</table>
</body>
</html>