DataBase/MS-SQL
[MS-SQL] EXISTS , ISNULL문 사용법
IF NOT EXISTS (SELECT * FROM Test_Table WHERE PK_ID = #PID#) BEGIN Insert Test_Table(PK_ID, IsUseWeb, LastUpdateUserID, LastUpdateDateTime) VALUES(#PID#, #IsUseWeb#, #LoginUserID#, GETDATE()) END ELSE BEGIN UPDATE Test_Table SET IsUseWeb = #IsUseWeb# ,LastUpdateUserID = #UserID# ,LastUpdateDateTime = GETDATE() WHERE PK_ID = #PID# END IF ISNULL(#IsUseWeb#,'') != '' and ISNULL(#UserID#,'') != '' B..
2019. 7. 2. 10:20