HTML5 Mobile
Written by: Max Firtman
Featured Refcardz: Top Refcardz:
  1. Git
  2. Data Mining
  3. Spring Data
  4. Subversion
  5. HTML5 Mobile
  1. HTML5 Mobile
  2. HTML5
  3. Subversion
  4. Git
  5. Java
150+ Refcardz Available · Get them all

Link Details

Previous | Next

Surprise Me!

Link 914733 thumbnail
User 1049989 avatar

By indiana_joy
via sqlknowledgebank.blogspot.in
Submitted: Jan 29 2013 / 04:05

Need Suggestion
When I am reviewing code of a stored procedure I find some interesting facts. The developer sends the date parameter as a string and then converts the date columns of the table to string to compare value. Like this WHEN CONVERT(VARCHAR, examdate, 105) = CONVERT(VARCHAR, @P_Examdt, 105); @P_Examdt – The parameters of stored procedure 1. I don't understand why ? 2. Is it decreasing the performance of the query ? If anyone have any comments please suggest.
Vote up
Vote down
  • 2
  • 0
  • 67
  • 27
SaveShareSend Tags: , ,

Comments

Add your comment
User 1049989 avatar

Joydeep Das replied ago:

0 votes Vote down Vote up Reply

Please make some comments on it…

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (2)



Voters Against This Link (0)