
November 2nd, 2003, 04:48 PM
|
|
Junior Member
|
|
Join Date: Nov 2003
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
ms sql syntax
hi all,
I need help translating some ms sql syntax
can anyone tell me what the folloing line means?
I've never worked with ms sql before, currently I have to translate a given ms sql db schema into mysql. Can anyone help?
Thank
----------------------------
"SELECT DB,ACCNT_CODE, ACCNT_NAME, ANL_A1, ANL_A2, ANL_A7, DB_FLAG, CONVERT(VARCHAR,DATE_FOR_ACTION,103) AS DATE_FOR_ACTION FROM SSR WHERE ACCNT_CODE='" & strID & "'"
|