Which of the commands below has better performance in Sql Server 2000
1) If Not Exists(Select Cliente.CD_Cliente From Cliente Where Cliente.CD_Cliente = @CD_Cliente)
or
2) If (Select count (*) From Cliente Where Cliente.CD_Cliente = @CD_Cliente) = 0)
I am using this commands inside of Store Procedure, or other form would exist of executing this better command.
Thankful at once.
Claudinei
Brazul Transport of Vehicles Ltd.
Visual Basic
Sql Server
ASP
Visual Basic
Sql Server
ASP