G gmwing Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-27 #1 我想在SQL SERVER中搜索某一记录,若应记录存在,则执行UPDATE语句,否则就执行INTSTER语句; 我应怎样编写这一功能??请指教!
D dz2050 Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-27 #2 try update table set ... except insert table values end
P pengjinlongex Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-27 #3 sql server : if exists (select ...) insert into ... else update ...
L LUCKWZY Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-27 #4 SELECT * FROM TABLE1 WHERE <条件> IF @@ROWCOUN>0 UPDATE ELSE INSERT