KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
What's the best in performance to determined if an item exist or not specially if the table contain more than 700,000 row if (Select count(id) from Registeration where email='email@w.cn') > 0 print 'Exist' else print 'Not Exist' OR if Exists(Select id from Registeration where email='email@w.cn') print 'Exist' else print 'Not Exist'
Tags (comma-separated)
Save Edits
Cancel