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