difference between BCP and DTS

Hi Experts,
please tell me the difference between BCP and DTS

provide me links if possible.

thankyou very muchHai friend

refer this link
http://www.google.co.in/search?hl=en&q=difference+between+BCP+and+DTS&meta=

thanks
Vssp

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...

Diagrams a tool anyone can recommend

Hi want to produce a DB diagram on MSQSL 2000.
all I want to do is create links which exist diagrammatically only.
Instead as I UNDERSTAND it the SQL wants to physically create these
constraints on the DB. I DO NOT WANT THIS.
Pls don't answer that I should be using constraints, FK etcs. Not my
call and too late.
Is it possible to simply produce a diagram where I draw links between
fields without effecting underlying DB.
Is there a tool that will do this? Or should I just throw it into word
and make the links myself or use Visio. Preferably would like to
create diagram in MMSQL but which didn't change underlying DB.
Itzik, shalom
I'm afraid you are not able to do that with SQL Server.
Perhaps , there are some third part software to be able to do it for you.
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.co m...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.
|||I generally use Visio for this... But you could use any 3rd party modelling
tool like Erwin, you'd have to set up the PK, FK etc in the logical
model... Just don't push it out to the physical database
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.co m...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.

Diagrams a tool anyone can recommend

Hi want to produce a DB diagram on MSQSL 2000.
all I want to do is create links which exist diagrammatically only.
Instead as I UNDERSTAND it the SQL wants to physically create these
constraints on the DB. I DO NOT WANT THIS.
Pls don't answer that I should be using constraints, FK etcs. Not my
call and too late.
Is it possible to simply produce a diagram where I draw links between
fields without effecting underlying DB.
Is there a tool that will do this? Or should I just throw it into word
and make the links myself or use Visio. Preferably would like to
create diagram in MMSQL but which didn't change underlying DB.Itzik, shalom
I'm afraid you are not able to do that with SQL Server.
Perhaps , there are some third part software to be able to do it for you.
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.|||I generally use visio for this... But you could use any 3rd party modelling
tool like Erwin, you'd have to set up the PK, FK etc in the logical
model... Just don't push it out to the physical database
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.

Diagrams a tool anyone can recommend

Hi want to produce a DB diagram on MSQSL 2000.
all I want to do is create links which exist diagrammatically only.
Instead as I UNDERSTAND it the SQL wants to physically create these
constraints on the DB. I DO NOT WANT THIS.
Pls don't answer that I should be using constraints, FK etcs. Not my
call and too late.
Is it possible to simply produce a diagram where I draw links between
fields without effecting underlying DB.
Is there a tool that will do this? Or should I just throw it into word
and make the links myself or use Visio. Preferably would like to
create diagram in MMSQL but which didn't change underlying DB.Itzik, shalom
I'm afraid you are not able to do that with SQL Server.
Perhaps , there are some third part software to be able to do it for you.
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.|||I generally use Visio for this... But you could use any 3rd party modelling
tool like Erwin, you'd have to set up the PK, FK etc in the logical
model... Just don't push it out to the physical database
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.|||I have used Erwin for several years. I have created
diagrams of what the database I am working on should look
like when I am done with it. Just reverse engineer it and
make all the connections.
Gary.
>--Original Message--
>Hi want to produce a DB diagram on MSQSL 2000.
>all I want to do is create links which exist
diagrammatically only.
>Instead as I UNDERSTAND it the SQL wants to physically
create these
>constraints on the DB. I DO NOT WANT THIS.
>Pls don't answer that I should be using constraints, FK
etcs. Not my
>call and too late.
>Is it possible to simply produce a diagram where I draw
links between
>fields without effecting underlying DB.
>Is there a tool that will do this? Or should I just throw
it into word
>and make the links myself or use Visio. Preferably would
like to
>create diagram in MMSQL but which didn't change underlying DB.
>.
>