declare @C_ID varchar(36)
set @C_ID='4d2c77ef---------'
declare @N_ID varchar(36)
set @N_ID='4d2c77ef'
declare @N_TITLE varchar(36)
set @N_TITLE='4d2c77ef'
declare @N_SORT int
set @N_SORT=1
declare @N_CONTENT varchar(36)
set @N_CONTENT='4d2c77ef'
if exists(select 1 from Dynamicnews where N_ID=@N_ID) begin update Dynamicnews set [N_TITLE]=@N_TITLE,[N_CONTENT]=@N_CONTENT,[N_SORT]=@N_SORT where N_ID=@N_ID end else begin insert into Dynamicnews([C_ID],[N_TITLE],[N_CONTENT],[N_SORT]) values(@C_ID,@N_TITLE,@N_CONTENT,@N_SORT) end
posted on 2009-04-08 17:32
sanmao 閱讀(115)
評論(0) 編輯 收藏