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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.