Dose MS sell SQlSerever with student rate?

Dose MS sell SQlSerever with student rate? If so, which website do I
buy from?SQL Express is a good choice for students.|||And you can't get much cheaper than free!

http://www.microsoft.com/sql/editio...ss/default.mspx

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials

"Amber" <guxiaobo1982@.gmail.com> wrote in message
news:1144136970.192061.94340@.t31g2000cwb.googlegro ups.com...
> SQL Express is a good choice for students.|||Tony Rogerson wrote:
> And you can't get much cheaper than free!
> http://www.microsoft.com/sql/editio...ss/default.mspx

Thank you.
I just found a link (may be to the same version but w/o other useful
info) at http://msdn.microsoft.com/vstudio/express/sql/

I have a question about downloading and installing it. At a link via
that site (now I could find the exact link), it says to uninstall
Visual Studio.Net 2005 express version or something like that before
installing SqlSever. I have recently installed VS.Net 2003, the
academic version I bought via my college. I was in VB.Ne c lass and so
got it for like $20. Will I need to uninstall it inorder to isntall the
SqlServer Express 2005?

Also via the link you gave, at the link of
http://msdn2.microsoft.com/en-us/library/ms143441.aspx is a link to
"Before You Install SQL Server Express". There, (at
http://msdn2.microsoft.com/en-us/li...5(SQL.90).aspx), it
says

- Uninstall .NET Framework 1.2 and later versions from your computer
(versions 1.0 and 1.1 do not have to be uninstalled). Then, install
..NET Framework 2.0. from .NET Framework 2.0 Download Center.

- Install SQL Server 2005 Express Edition from the SQL Server Express
Web site.

>From what I checked, what i currently have is Microsoft .NET Framework
SDK v1.1.

I think the frame work for Visual Studio 2005 is 1.2, am I right? So I
won't need uninstall Visual Studio 2003 in order to install this
SqlServer Express 2005, right?

A second question:

Should I learn PL/SQL using MS SqlServer or Oracle? My immediate goal
is to find an entry level work and I am wodnering what enviornment is
more pravalently used for the entry level work.

Thanks in advance.

> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
> "Amber" <guxiaobo1982@.gmail.com> wrote in message
> news:1144136970.192061.94340@.t31g2000cwb.googlegro ups.com...
> > SQL Express is a good choice for students.|||If you want to learn pl/sql then you need Oracle. Oracle offers a free
version and the regular versions may be used free for development
purposes though you should read the license terms to see which version
best fit your needs. See http://technet.oracle.com for a download
site.

SQL Server 2005 also appears to be a good product and if you want to
learn T-SQL or the Reporting tool it would be the proper choice.

IMHO -- Mark D Powell --|||Mark D Powell wrote:
> If you want to learn pl/sql then you need Oracle. Oracle offers a free
> version and the regular versions may be used free for development
> purposes though you should read the license terms to see which version
> best fit your needs. See http://technet.oracle.com for a download
> site.
> SQL Server 2005 also appears to be a good product and if you want to
> learn T-SQL or the Reporting tool it would be the proper choice.
> IMHO -- Mark D Powell --

Thanks for explaining the difference.|||Hi Mandie,

2.0 goes with .NET 2005 so the uninstall relates to that.

you can leave .net 2003 on the box - my old dev box was like that and i had
no problems.

hope that helps.

--
--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"mandie" <mandie772007@.yahoo.com> wrote in message
news:1144155144.743213.36890@.g10g2000cwb.googlegro ups.com...
> Tony Rogerson wrote:
>> And you can't get much cheaper than free!
>>
>> http://www.microsoft.com/sql/editio...ss/default.mspx
> Thank you.
> I just found a link (may be to the same version but w/o other useful
> info) at http://msdn.microsoft.com/vstudio/express/sql/
> I have a question about downloading and installing it. At a link via
> that site (now I could find the exact link), it says to uninstall
> Visual Studio.Net 2005 express version or something like that before
> installing SqlSever. I have recently installed VS.Net 2003, the
> academic version I bought via my college. I was in VB.Ne c lass and so
> got it for like $20. Will I need to uninstall it inorder to isntall the
> SqlServer Express 2005?
> Also via the link you gave, at the link of
> http://msdn2.microsoft.com/en-us/library/ms143441.aspx is a link to
> "Before You Install SQL Server Express". There, (at
> http://msdn2.microsoft.com/en-us/li...5(SQL.90).aspx), it
> says
> - Uninstall .NET Framework 1.2 and later versions from your computer
> (versions 1.0 and 1.1 do not have to be uninstalled). Then, install
> .NET Framework 2.0. from .NET Framework 2.0 Download Center.
> - Install SQL Server 2005 Express Edition from the SQL Server Express
> Web site.
>>From what I checked, what i currently have is Microsoft .NET Framework
> SDK v1.1.
> I think the frame work for Visual Studio 2005 is 1.2, am I right? So I
> won't need uninstall Visual Studio 2003 in order to install this
> SqlServer Express 2005, right?
> A second question:
> Should I learn PL/SQL using MS SqlServer or Oracle? My immediate goal
> is to find an entry level work and I am wodnering what enviornment is
> more pravalently used for the entry level work.
> Thanks in advance.
>
>>
>> --
>> Tony Rogerson
>> SQL Server MVP
>> http://sqlserverfaq.com - free video tutorials
>>
>> "Amber" <guxiaobo1982@.gmail.com> wrote in message
>> news:1144136970.192061.94340@.t31g2000cwb.googlegro ups.com...
>> > SQL Express is a good choice for students.
>|||On 4 Apr 2006 05:52:24 -0700, mandie wrote:

(snip)
>A second question:
>Should I learn PL/SQL using MS SqlServer or Oracle? My immediate goal
>is to find an entry level work and I am wodnering what enviornment is
>more pravalently used for the entry level work.

Hi mandie,

PL/SQL, as Mark explained, is the name for Oracle's proprietary
procedural additions to the SQL language.

SQL Server has also added proprietary features (both procedural and
declarative) to SQL; these are collectively called "Transact-SQL" (or
T-SQL for short).

If you want to study the version that gives you the best chance to get a
job, check the job ads in your local newspapers. If you want the best
chance of a job now AND LATER, then whatever you study, make sure that
you are aware of which features are standard and which are proprieatry;
that will save you lots of time if you later decide to (or have to)
switch to another DB platform.

--
Hugo Kornelis, SQL Server MVP|||On 3 Apr 2006 22:45:40 -0700, mandie wrote:

>Dose MS sell SQlSerever with student rate? If so, which website do I
>buy from?

Hi Mandie,

In addition to the SQL Express version you've already been pointed to,
there is also the Developer Edition. Unlike SQL Express, the Developer
Edition has all features included. The only differences between the
Developer Edition and the Enterprisse Edition are the license (Dev Ed is
good for development, test and demo use only) and price (Dev Ed is only
$ 49.99).

More info: http://www.microsoft.com/sql/editio...er/default.mspx

--
Hugo Kornelis, SQL Server MVP|||Tony Rogerson wrote:
> Hi Mandie,
> 2.0 goes with .NET 2005 so the uninstall relates to that.
> you can leave .net 2003 on the box - my old dev box was like that and i had
> no problems.
> hope that helps.

Oh, yes. It helps a lot to know clearly.

> --
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
> "mandie" <mandie772007@.yahoo.com> wrote in message
> news:1144155144.743213.36890@.g10g2000cwb.googlegro ups.com...
> > Tony Rogerson wrote:
> >> And you can't get much cheaper than free!
> >>
> >> http://www.microsoft.com/sql/editio...ss/default.mspx
> > Thank you.|||Hugo Kornelis wrote:

> Hi mandie,
> PL/SQL, as Mark explained, is the name for Oracle's proprietary
> procedural additions to the SQL language.
> SQL Server has also added proprietary features (both procedural and
> declarative) to SQL; these are collectively called "Transact-SQL" (or
> T-SQL for short).

Thanks for the clearification.

> If you want to study the version that gives you the best chance to get a
> job, check the job ads in your local newspapers. If you want the best
> chance of a job now AND LATER, then whatever you study, make sure that
> you are aware of which features are standard and which are proprieatry;
> that will save you lots of time if you later decide to (or have to)
> switch to another DB platform.

Thanks.

> --
> Hugo Kornelis, SQL Server MVP

Does Visual web developer Express edition works with Ms 2000 Database Service?

I have made my website using SQL Server Express edition. It is totally database driven and manypages use databases to display data. My problem is that after paying for webhosting fees my web host told me that they do not support SQL Server express edition. Instead they have support for MySQL and Ms Access. Except that there is this MS 2000 Database service for an additional cost. Any recommendations what I should do except changing the host? If I pay for MS 2000 Database servicem, will my website work? My user management(i.e ASPNETDB database) was created by Visual Web developer and I don't want to do user management myself. Any advice?

HI Gurus,

I am also facing the same problem, i developed asp.net 2.0 application with Sql Server 2005 Express edition, with the bundled user managment facility. After completion the project, my host told, they only support SqlServer 2000 version.

In my website every pages linked with the database (connection strings). I dont know what i need to do?

This is very urgent, can anyone help? (Include Mr. Rex lim)

Sankar

|||

Hi,

Actually you can import the aspnetdb database into your SQLServer2000 by aspnet_regsql tool, backup the database file, restore it on your server-side. In this way, you can use membership, profile with SQL Server2000 database.

More detail about the tool:http://msdn2.microsoft.com/en-us/library/ms229862(vs.80).aspx

Thanks.

Does the Report Manager use the RS WebService?

If the Report Manager uses the SOAP API to build the website, is there a way to find the code for this? This is a great working sample and I would like to see that code to help in my understanding and building of a proprietary site. There are a lot of snippets of code to show how to do things individually, but when you put them all together, it is very slow (Item Properties, Methods, etc.). //Report Mangaer does use the SOAP API to the Report Server web service, but we don't make the Report Manager source code publicly available.|||

Thanks for the response. If that is the case, I've been looking for good examples for retrieving the Report Name, Description and Parameters. When I piece together from other resources I can get it to work great! HOWEVER, it is very slow, especially the GetProperties Method!

Thanks.