MS SQL

new in sql world

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Oct 2005

Posts: 4

Reputation: maya_cs is an unknown quantity at this point

Solved Threads: 1

maya_cs

Offline

Newbie Poster

new in sql world

Oct 23rd, 2005

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

•

Join Date: Nov 2005

Posts: 40

Reputation: noman78 is an unknown quantity at this point

Solved Threads: 0

noman78

Offline

Light Poster

Re: new in sql world

Nov 23rd, 2005

•

Originally Posted by maya_cs

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