MSSQL 쿼리문 정리

select 

SQL = "select mem_name, mem_id from TB_MEM_INFO"

SQL = SQL & " where mem_id = '"&member_id&"' order by idx desc "

insert

SQL = "insert into TB_BOARD_LIST ( Bname, Bm_id, Btitle, Bcontent, Bnum 

) VALUES"

SQL = SQL & "('"&name&"'"

SQL = SQL & ",'"&m_id&"'"

SQL = SQL & ",'"&title&"'"

SQL = SQL & ",'"&content&"'"

SQL = SQL & ","&number"

)"

db.Execute(SQL)

update

SQL = "UPDATE TB_BOARD_LIST SET Bre_step = Bre_step + 1"

SQL = SQL &" WHERE Bref=" & ref & " AND Bre_step > " & re_step

SQL = SQL & " AND BD_type = '"&BD_type&"'"

db.Execute(SQL)

delete

SQL = "delete  from TB_MEM where m_id = 'aa' "

db.execute(SQL)