new in sql world

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 391,998 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,175 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser:

Thread Tools Display Modes

Views: 1853 | Replies: 1

•

Join Date: Oct 2005

Posts: 4

Reputation: maya_cs is an unknown quantity at this point

Rep Power: 0

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

Location: Dubai,UAE

Posts: 36

Reputation: noman78 is an unknown quantity at this point

Rep Power: 3

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