i need differ between

Posted by Jayakumars under ASP.NET on 9/13/2011 | Points: 10 | Views : 1884 | Status : [Member] [MVP] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hi

I need Difference Between Both Sql command

1.Tbl_BookIssue.BookDate >='09/13/2010' and Tbl_BookIssue.BookDate <= '09/15/2011'

2.Tbl_BookIssue.BookDate Between '09/13/2010' and '09/13/2011'

i have didnot proper output.

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Sathya4260 on: 9/13/2011 [Member] Starter | Points: 25

0	There is no difference, both would produce the same result with consuming same time, Any way the second query is implicitly converted as below and executed Tbl_BookIssue.BookDate>=CONVERT_IMPLICIT(datetime,[@1],0) AND Tbl_BookIssue.BookDate<=CONVERT_IMPLICIT(datetime,[@2],0)" So there might be no difference. Mark as answer, if you got expected answer Sathish Kumar S Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

There is no difference, both would produce the same result with consuming same time, Any way the second query is implicitly converted as below and executed

Tbl_BookIssue.BookDate>=CONVERT_IMPLICIT(datetime,[@1],0) AND Tbl_BookIssue.BookDate<=CONVERT_IMPLICIT(datetime,[@2],0)"

So there might be no difference.

Mark as answer, if you got expected answer

Sathish Kumar S

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts