lundi 9 février 2015

ISNULL() OR Is NULL in UPDATE statement


I have to run UPDATE statement on live online database about 5 lac records so i want to know which statement are run faster


Update Table set REC_ID = isnull(REC_ID,'')


Update Table set REC_ID = '' where REC_ID is null


i am using microsoft sql server 2012





Aucun commentaire:

Enregistrer un commentaire