Diff Datatypes used doubt int and bigint ........SQL SERVER 2005......Any useful links ?

Hello Frdz,

I have doubt regarding the datatypes fields used in SQL SERVER 2005.

The value for bigint Int64 is 18

The value of int Int32 is 9/10

Now,if in int i write : 1234567890 (accepted)

This gives error : 9874565656 (not accepted........why is it so ? )

Why is it so ??

I want to know the perfect size of all the datatypes used in SQLSERVER 2005.

There are also smallint,tinyint....

What's the main difference with all of them ??

Can anyone provide me the nice links which can explain me what m i asking in this post...

Please help me...I want to know all the datatypes used differences...

you cannot store 9874565656 in an int as it exceeds the max value for an int which is: 2,147,483,647

http://msdn2.microsoft.com/en-us/library/ms187745(SQL.90).aspx

|||

thanxs...i think it's helpful link..

I want to also know that in SQL SERVER 2005 can we assign or fix manually the values upto the limit...like,

Id1 int - 4

Id2 bigint - 10

like in varchar we can do

Name Varchar(20) if we take varchar(50) as datatype...

Hope u understand what i ask...this questions are not solved in my mind...

Please help me...

Thanxs again....

|||

varchar is a variable length datatype and you are allowed to set its length

you cannot do that with the integer datatypes.

|||

If you really intend to limit the value <= 4 digits ( = 9999) you can create a constraing on the column to make sure the value <= 9999.

|||

You can also create your own datatype that is based on an integer value type that can store all your possible values and has a constraint.

This may help:

http://weblogs.asp.net/alex_papadimoulis/archive/2005/10/07/426930.aspx

More complex datatype needs can be done via a CLR UDT, but I'm not sure how well they perform. Like:

http://www.devx.com/dotnet/Article/22644

|||

thanxs all of...

I think it's better to make a constraint......

Nice answers to clear my doubt...

Developer Edition

Hi All,
I have a question regarding the usage of SQL Server 2005 Developer Edition.
Can I use it in a client - server architecture say I install Developer
edition on a server and install client tools(Management studio / profiler)
on desktops and acess as we use Enterprise Edition? The purpose is only
Development (no production work). I am asking this because ours is a small
Organization with major work is done on SQL Server 2000. Only 1 team is
gonna use 2005.
Thanks,
PradThe license for Developer Edition allows you to install the client tools on
any development computer you desire, and to have as many SQL Servers
installed as you might need, for example, a dev server, a test server, a QA
server, etc.
However, each person (developer or tester -or whoever) accessing the servers
covered with the Developer Edition license MUST have a proper license. (I
think that is currently about $50 (US) each.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Prad" <pradeepk@.healthasyst.com> wrote in message
news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> I have a question regarding the usage of SQL Server 2005 Developer
> Edition.
> Can I use it in a client - server architecture say I install Developer
> edition on a server and install client tools(Management studio / profiler)
> on desktops and acess as we use Enterprise Edition? The purpose is only
> Development (no production work). I am asking this because ours is a small
> Organization with major work is done on SQL Server 2000. Only 1 team is
> gonna use 2005.
> Thanks,
> Prad
>|||Arnie,
Thanks for replying soon.
I know that we can install Dev Edn on Desktops as you said.
My doubt is whether I can install it on only one server and the
clients(desktop mc/) access it. So that I need to update (run build) only on
the Server rather than updating every m/c.
If not possible, I will have to go for Standard Edn right? Hope you
understud my requirement.
Thanks,
Prad
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
> The license for Developer Edition allows you to install the client tools
> on any development computer you desire, and to have as many SQL Servers
> installed as you might need, for example, a dev server, a test server, a
> QA server, etc.
> However, each person (developer or tester -or whoever) accessing the
> servers covered with the Developer Edition license MUST have a proper
> license. (I think that is currently about $50 (US) each.)
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Prad" <pradeepk@.healthasyst.com> wrote in message
> news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
>|||You can install SQL Server Developer Edition on any computer you desire. You
can install it on one or more servers to be accessed by other computers
acting as clients.
Each client that accesses the Developer Edition MUST have a Developer
Edition license. (And of course, they must properly qualify for the
Developer Edition license.)
No Cost for one or more Servers, Developer Edition license for each client
(user).
AS long as ALL the usage qualifies for the Developer Edition license.
Licensing -Developer Edition
My understanding of the Developers Edition license is that you are covered
for a Development server, an Integration/Staging server, even a QA/Test
server, local servers on the developers computer, etc. -as long as no one
except developers access those SQL Servers, and as long as each developer
and/or Tester has a Developer Edition License.
For a more definitive answer, check with the VL folks at: (800) 426-9400.
From: http://www.microsoft.com/sql/editio...er/default.mspx
Each license of SQL Server 2005 Developer Edition entitles one developer to
use the software on as many systems as necessary and additional developers
can use the software by purchasing additional licenses.
From:
http://download.microsoft.com/downl...censingv1.1.doc
DEVELOPER EDITION
SQL Server Developer Edition is a separate product and is used for
development and testing purposes only. It is licensed per developer or
tester (person).
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Prad" <pradeepk@.healthasyst.com> wrote in message
news:OA6SOtY%23GHA.4888@.TK2MSFTNGP04.phx.gbl...
> Arnie,
> Thanks for replying soon.
> I know that we can install Dev Edn on Desktops as you said.
> My doubt is whether I can install it on only one server and the
> clients(desktop mc/) access it. So that I need to update (run build) only
> on the Server rather than updating every m/c.
> If not possible, I will have to go for Standard Edn right? Hope you
> understud my requirement.
> Thanks,
> Prad
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
>|||Thanks a lot. Ive got my doubt cleared...
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eyyhfLZ%23GHA.3312@.TK2MSFTNGP02.phx.gbl...
> You can install SQL Server Developer Edition on any computer you desire.
> You can install it on one or more servers to be accessed by other
> computers acting as clients.
> Each client that accesses the Developer Edition MUST have a Developer
> Edition license. (And of course, they must properly qualify for the
> Developer Edition license.)
> No Cost for one or more Servers, Developer Edition license for each client
> (user).
> AS long as ALL the usage qualifies for the Developer Edition license.
> Licensing -Developer Edition
> My understanding of the Developers Edition license is that you are covered
> for a Development server, an Integration/Staging server, even a QA/Test
> server, local servers on the developers computer, etc. -as long as no one
> except developers access those SQL Servers, and as long as each developer
> and/or Tester has a Developer Edition License.
> For a more definitive answer, check with the VL folks at: (800) 426-9400.
> From: http://www.microsoft.com/sql/editio...er/default.mspx
> Each license of SQL Server 2005 Developer Edition entitles one developer
> to
> use the software on as many systems as necessary and additional developers
> can use the software by purchasing additional licenses.
> From:
> http://download.microsoft.com/downl...censingv1.1.doc
> DEVELOPER EDITION
> SQL Server Developer Edition is a separate product and is used for
> development and testing purposes only. It is licensed per developer or
> tester (person).
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Prad" <pradeepk@.healthasyst.com> wrote in message
> news:OA6SOtY%23GHA.4888@.TK2MSFTNGP04.phx.gbl...
>

Developer Edition

Hi All,
I have a question regarding the usage of SQL Server 2005 Developer Edition.
Can I use it in a client - server architecture say I install Developer
edition on a server and install client tools(Management studio / profiler)
on desktops and acess as we use Enterprise Edition? The purpose is only
Development (no production work). I am asking this because ours is a small
Organization with major work is done on SQL Server 2000. Only 1 team is
gonna use 2005.
Thanks,
PradThe license for Developer Edition allows you to install the client tools on
any development computer you desire, and to have as many SQL Servers
installed as you might need, for example, a dev server, a test server, a QA
server, etc.
However, each person (developer or tester -or whoever) accessing the servers
covered with the Developer Edition license MUST have a proper license. (I
think that is currently about $50 (US) each.)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Prad" <pradeepk@.healthasyst.com> wrote in message
news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> I have a question regarding the usage of SQL Server 2005 Developer
> Edition.
> Can I use it in a client - server architecture say I install Developer
> edition on a server and install client tools(Management studio / profiler)
> on desktops and acess as we use Enterprise Edition? The purpose is only
> Development (no production work). I am asking this because ours is a small
> Organization with major work is done on SQL Server 2000. Only 1 team is
> gonna use 2005.
> Thanks,
> Prad
>|||Arnie,
Thanks for replying soon.
I know that we can install Dev Edn on Desktops as you said.
My doubt is whether I can install it on only one server and the
clients(desktop mc/) access it. So that I need to update (run build) only on
the Server rather than updating every m/c.
If not possible, I will have to go for Standard Edn right? Hope you
understud my requirement.
Thanks,
Prad
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
> The license for Developer Edition allows you to install the client tools
> on any development computer you desire, and to have as many SQL Servers
> installed as you might need, for example, a dev server, a test server, a
> QA server, etc.
> However, each person (developer or tester -or whoever) accessing the
> servers covered with the Developer Edition license MUST have a proper
> license. (I think that is currently about $50 (US) each.)
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Prad" <pradeepk@.healthasyst.com> wrote in message
> news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
>> Hi All,
>> I have a question regarding the usage of SQL Server 2005 Developer
>> Edition.
>> Can I use it in a client - server architecture say I install Developer
>> edition on a server and install client tools(Management studio /
>> profiler) on desktops and acess as we use Enterprise Edition? The purpose
>> is only Development (no production work). I am asking this because ours
>> is a small Organization with major work is done on SQL Server 2000. Only
>> 1 team is gonna use 2005.
>> Thanks,
>> Prad
>|||You can install SQL Server Developer Edition on any computer you desire. You
can install it on one or more servers to be accessed by other computers
acting as clients.
Each client that accesses the Developer Edition MUST have a Developer
Edition license. (And of course, they must properly qualify for the
Developer Edition license.)
No Cost for one or more Servers, Developer Edition license for each client
(user).
AS long as ALL the usage qualifies for the Developer Edition license.
Licensing -Developer Edition
My understanding of the Developers Edition license is that you are covered
for a Development server, an Integration/Staging server, even a QA/Test
server, local servers on the developers computer, etc. -as long as no one
except developers access those SQL Servers, and as long as each developer
and/or Tester has a Developer Edition License.
For a more definitive answer, check with the VL folks at: (800) 426-9400.
From: http://www.microsoft.com/sql/editions/developer/default.mspx
Each license of SQL Server 2005 Developer Edition entitles one developer to
use the software on as many systems as necessary and additional developers
can use the software by purchasing additional licenses.
From:
http://download.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensingv1.1.doc
DEVELOPER EDITION
SQL Server Developer Edition is a separate product and is used for
development and testing purposes only. It is licensed per developer or
tester (person).
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Prad" <pradeepk@.healthasyst.com> wrote in message
news:OA6SOtY%23GHA.4888@.TK2MSFTNGP04.phx.gbl...
> Arnie,
> Thanks for replying soon.
> I know that we can install Dev Edn on Desktops as you said.
> My doubt is whether I can install it on only one server and the
> clients(desktop mc/) access it. So that I need to update (run build) only
> on the Server rather than updating every m/c.
> If not possible, I will have to go for Standard Edn right? Hope you
> understud my requirement.
> Thanks,
> Prad
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
>> The license for Developer Edition allows you to install the client tools
>> on any development computer you desire, and to have as many SQL Servers
>> installed as you might need, for example, a dev server, a test server, a
>> QA server, etc.
>> However, each person (developer or tester -or whoever) accessing the
>> servers covered with the Developer Edition license MUST have a proper
>> license. (I think that is currently about $50 (US) each.)
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "Prad" <pradeepk@.healthasyst.com> wrote in message
>> news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
>> Hi All,
>> I have a question regarding the usage of SQL Server 2005 Developer
>> Edition.
>> Can I use it in a client - server architecture say I install Developer
>> edition on a server and install client tools(Management studio /
>> profiler) on desktops and acess as we use Enterprise Edition? The
>> purpose is only Development (no production work). I am asking this
>> because ours is a small Organization with major work is done on SQL
>> Server 2000. Only 1 team is gonna use 2005.
>> Thanks,
>> Prad
>>
>|||Thanks a lot. Ive got my doubt cleared...
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eyyhfLZ%23GHA.3312@.TK2MSFTNGP02.phx.gbl...
> You can install SQL Server Developer Edition on any computer you desire.
> You can install it on one or more servers to be accessed by other
> computers acting as clients.
> Each client that accesses the Developer Edition MUST have a Developer
> Edition license. (And of course, they must properly qualify for the
> Developer Edition license.)
> No Cost for one or more Servers, Developer Edition license for each client
> (user).
> AS long as ALL the usage qualifies for the Developer Edition license.
> Licensing -Developer Edition
> My understanding of the Developers Edition license is that you are covered
> for a Development server, an Integration/Staging server, even a QA/Test
> server, local servers on the developers computer, etc. -as long as no one
> except developers access those SQL Servers, and as long as each developer
> and/or Tester has a Developer Edition License.
> For a more definitive answer, check with the VL folks at: (800) 426-9400.
> From: http://www.microsoft.com/sql/editions/developer/default.mspx
> Each license of SQL Server 2005 Developer Edition entitles one developer
> to
> use the software on as many systems as necessary and additional developers
> can use the software by purchasing additional licenses.
> From:
> http://download.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensingv1.1.doc
> DEVELOPER EDITION
> SQL Server Developer Edition is a separate product and is used for
> development and testing purposes only. It is licensed per developer or
> tester (person).
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Prad" <pradeepk@.healthasyst.com> wrote in message
> news:OA6SOtY%23GHA.4888@.TK2MSFTNGP04.phx.gbl...
>> Arnie,
>> Thanks for replying soon.
>> I know that we can install Dev Edn on Desktops as you said.
>> My doubt is whether I can install it on only one server and the
>> clients(desktop mc/) access it. So that I need to update (run build) only
>> on the Server rather than updating every m/c.
>> If not possible, I will have to go for Standard Edn right? Hope you
>> understud my requirement.
>> Thanks,
>> Prad
>> "Arnie Rowland" <arnie@.1568.com> wrote in message
>> news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
>> The license for Developer Edition allows you to install the client tools
>> on any development computer you desire, and to have as many SQL Servers
>> installed as you might need, for example, a dev server, a test server, a
>> QA server, etc.
>> However, each person (developer or tester -or whoever) accessing the
>> servers covered with the Developer Edition license MUST have a proper
>> license. (I think that is currently about $50 (US) each.)
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "Prad" <pradeepk@.healthasyst.com> wrote in message
>> news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
>> Hi All,
>> I have a question regarding the usage of SQL Server 2005 Developer
>> Edition.
>> Can I use it in a client - server architecture say I install Developer
>> edition on a server and install client tools(Management studio /
>> profiler) on desktops and acess as we use Enterprise Edition? The
>> purpose is only Development (no production work). I am asking this
>> because ours is a small Organization with major work is done on SQL
>> Server 2000. Only 1 team is gonna use 2005.
>> Thanks,
>> Prad
>>
>>
>