0

hi all
i wanna to use sql server 2005
but i never use it or any sql server before
can any one help me
what steps i should follow to learn it
i will use jsp .
as i used it before but with access
thank u

2
Contributors
1
Reply
2
Views
11 Years
Discussion Span
Last Post by noman78
0

hi all
i wanna to use sql server 2005
but i never use it or any sql server before
can any one help me
what steps i should follow to learn it
i will use jsp .
as i used it before but with access
thank u

hello
it is very easy to just begin with SQL
i m just assuming u will use ODBC connectivity
in converting Database from access to SQL u only need to consider these things
1-isnull function id different in SQL, u cant compare
isnull(fldname)=true, u have to do it like isnull(fldname,'')=''
2-First function is not supported , tru use MAX
3-Date is handelled differently instead of # use ', use date is string
4-iif function to be repalced with Case block

if u convert all ur code to these changes ur exisiting Access application will work fine with SQL
take care
for any further help u can get back

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.