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
No comments:
Post a Comment