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
