data type real 4

I have a value in a SQL table of -1.#IND for a data type of real 4. I am
wondering what the value of -1.#IND means.
--
Thanks Jeff DaunIt generally means you hit an issue with values using
approximate data types - there are some values where the
representation of the value gets hosed out. You will see
values along the lines of 1.#NF or 1.#ND for approximate
data types when you hit this in SQL Server.
-Sue
On Tue, 17 Jan 2006 09:26:06 -0800, Jeff Daun
<JeffDaun@.discussions.microsoft.com> wrote:
>I have a value in a SQL table of -1.#IND for a data type of real 4. I am
>wondering what the value of -1.#IND means.|||Thank you
--
Thanks Jeff Daun
"Sue Hoegemeier" wrote:
> It generally means you hit an issue with values using
> approximate data types - there are some values where the
> representation of the value gets hosed out. You will see
> values along the lines of 1.#NF or 1.#ND for approximate
> data types when you hit this in SQL Server.
> -Sue
> On Tue, 17 Jan 2006 09:26:06 -0800, Jeff Daun
> <JeffDaun@.discussions.microsoft.com> wrote:
> >I have a value in a SQL table of -1.#IND for a data type of real 4. I am
> >wondering what the value of -1.#IND means.
>|||I was wondering how would I be able to view the data in the column so that I
can find the value being put in the field from the application so that I can
find the correct precision to use?
--
Thanks Jeff Daun
"Sue Hoegemeier" wrote:
> It generally means you hit an issue with values using
> approximate data types - there are some values where the
> representation of the value gets hosed out. You will see
> values along the lines of 1.#NF or 1.#ND for approximate
> data types when you hit this in SQL Server.
> -Sue
> On Tue, 17 Jan 2006 09:26:06 -0800, Jeff Daun
> <JeffDaun@.discussions.microsoft.com> wrote:
> >I have a value in a SQL table of -1.#IND for a data type of real 4. I am
> >wondering what the value of -1.#IND means.
>|||I don't think so as it has a value that the SQL Server can't
represent. It's not really a matter of the precision as much
as a value getting in there that shouldn't have. If I
remember, the issue is due to SQL Server not fully
implementing the IEEE 754 standard for binary representation
of floating point numbers.
-Sue
On Wed, 18 Jan 2006 07:09:03 -0800, Jeff Daun
<JeffDaun@.discussions.microsoft.com> wrote:
>I was wondering how would I be able to view the data in the column so that I
>can find the value being put in the field from the application so that I can
>find the correct precision to use?

data type real 4

I have a value in a SQL table of -1.#IND for a data type of real 4. I am
wondering what the value of -1.#IND means.
--
Thanks Jeff DaunIt generally means you hit an issue with values using
approximate data types - there are some values where the
representation of the value gets hosed out. You will see
values along the lines of 1.#NF or 1.#ND for approximate
data types when you hit this in SQL Server.
-Sue
On Tue, 17 Jan 2006 09:26:06 -0800, Jeff Daun
<JeffDaun@.discussions.microsoft.com> wrote:

>I have a value in a SQL table of -1.#IND for a data type of real 4. I am
>wondering what the value of -1.#IND means.|||Thank you
--
Thanks Jeff Daun
"Sue Hoegemeier" wrote:

> It generally means you hit an issue with values using
> approximate data types - there are some values where the
> representation of the value gets hosed out. You will see
> values along the lines of 1.#NF or 1.#ND for approximate
> data types when you hit this in SQL Server.
> -Sue
> On Tue, 17 Jan 2006 09:26:06 -0800, Jeff Daun
> <JeffDaun@.discussions.microsoft.com> wrote:
>
>|||I was wondering how would I be able to view the data in the column so that I
can find the value being put in the field from the application so that I can
find the correct precision to use?
--
Thanks Jeff Daun
"Sue Hoegemeier" wrote:

> It generally means you hit an issue with values using
> approximate data types - there are some values where the
> representation of the value gets hosed out. You will see
> values along the lines of 1.#NF or 1.#ND for approximate
> data types when you hit this in SQL Server.
> -Sue
> On Tue, 17 Jan 2006 09:26:06 -0800, Jeff Daun
> <JeffDaun@.discussions.microsoft.com> wrote:
>
>|||I don't think so as it has a value that the SQL Server can't
represent. It's not really a matter of the precision as much
as a value getting in there that shouldn't have. If I
remember, the issue is due to SQL Server not fully
implementing the IEEE 754 standard for binary representation
of floating point numbers.
-Sue
On Wed, 18 Jan 2006 07:09:03 -0800, Jeff Daun
<JeffDaun@.discussions.microsoft.com> wrote:

>I was wondering how would I be able to view the data in the column so that
I
>can find the value being put in the field from the application so that I ca
n
>find the correct precision to use?

data type real 4

I have a value in a SQL table of -1.#IND for a data type of real 4. I am
wondering what the value of -1.#IND means.
Thanks Jeff Daun
It generally means you hit an issue with values using
approximate data types - there are some values where the
representation of the value gets hosed out. You will see
values along the lines of 1.#NF or 1.#ND for approximate
data types when you hit this in SQL Server.
-Sue
On Tue, 17 Jan 2006 09:26:06 -0800, Jeff Daun
<JeffDaun@.discussions.microsoft.com> wrote:

>I have a value in a SQL table of -1.#IND for a data type of real 4. I am
>wondering what the value of -1.#IND means.
|||Thank you
Thanks Jeff Daun
"Sue Hoegemeier" wrote:

> It generally means you hit an issue with values using
> approximate data types - there are some values where the
> representation of the value gets hosed out. You will see
> values along the lines of 1.#NF or 1.#ND for approximate
> data types when you hit this in SQL Server.
> -Sue
> On Tue, 17 Jan 2006 09:26:06 -0800, Jeff Daun
> <JeffDaun@.discussions.microsoft.com> wrote:
>
>
|||I was wondering how would I be able to view the data in the column so that I
can find the value being put in the field from the application so that I can
find the correct precision to use?
Thanks Jeff Daun
"Sue Hoegemeier" wrote:

> It generally means you hit an issue with values using
> approximate data types - there are some values where the
> representation of the value gets hosed out. You will see
> values along the lines of 1.#NF or 1.#ND for approximate
> data types when you hit this in SQL Server.
> -Sue
> On Tue, 17 Jan 2006 09:26:06 -0800, Jeff Daun
> <JeffDaun@.discussions.microsoft.com> wrote:
>
>
|||I don't think so as it has a value that the SQL Server can't
represent. It's not really a matter of the precision as much
as a value getting in there that shouldn't have. If I
remember, the issue is due to SQL Server not fully
implementing the IEEE 754 standard for binary representation
of floating point numbers.
-Sue
On Wed, 18 Jan 2006 07:09:03 -0800, Jeff Daun
<JeffDaun@.discussions.microsoft.com> wrote:

>I was wondering how would I be able to view the data in the column so that I
>can find the value being put in the field from the application so that I can
>find the correct precision to use?

data type

IN on table I have a column with this type : ZusatzText
what means ?
What is the lenght of this colunm ?
thanks
Try running this sp in QA or go to "Enterprise Manager", expand the server,
expand the db, click on "User Defined data Types".
use your_db
go
exec sp_MShelptype 'ZusatzText', 'uddt'
go
AMB
"tlft" wrote:

> IN on table I have a column with this type : ZusatzText
> what means ?
> What is the lenght of this colunm ?
> thanks
|||SQL allows you to define your own user-defined data type, based on a system
type. For instance you might define a data type called ZipCodeType
char(5)... You may then use this type in table definitions.. The intention
is to assist you in providing standard lengths, etc for commonly used fields
in multiple databases and tables.
What you are looking at is probably a user-defined data type.
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
"tlft" <tlft@.discussions.microsoft.com> wrote in message
news:33732009-785F-4337-BA4D-0D36ADF930BA@.microsoft.com...
> IN on table I have a column with this type : ZusatzText
> what means ?
> What is the lenght of this colunm ?
> thanks

data type

IN on table I have a column with this type : ZusatzText
what means ?
What is the lenght of this colunm ?
thanksTry running this sp in QA or go to "Enterprise Manager", expand the server,
expand the db, click on "User Defined data Types".
use your_db
go
exec sp_MShelptype 'ZusatzText', 'uddt'
go
AMB
"tlft" wrote:

> IN on table I have a column with this type : ZusatzText
> what means ?
> What is the lenght of this colunm ?
> thanks|||SQL allows you to define your own user-defined data type, based on a system
type. For instance you might define a data type called ZipCodeType
char(5)... You may then use this type in table definitions.. The intention
is to assist you in providing standard lengths, etc for commonly used fields
in multiple databases and tables.
What you are looking at is probably a user-defined data type.
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
"tlft" <tlft@.discussions.microsoft.com> wrote in message
news:33732009-785F-4337-BA4D-0D36ADF930BA@.microsoft.com...
> IN on table I have a column with this type : ZusatzText
> what means ?
> What is the lenght of this colunm ?
> thanks

data type

IN on table I have a column with this type : ZusatzText
what means ?
What is the lenght of this colunm ?
thanksTry running this sp in QA or go to "Enterprise Manager", expand the server,
expand the db, click on "User Defined data Types".
use your_db
go
exec sp_MShelptype 'ZusatzText', 'uddt'
go
AMB
"tlft" wrote:
> IN on table I have a column with this type : ZusatzText
> what means ?
> What is the lenght of this colunm ?
> thanks|||SQL allows you to define your own user-defined data type, based on a system
type. For instance you might define a data type called ZipCodeType
char(5)... You may then use this type in table definitions.. The intention
is to assist you in providing standard lengths, etc for commonly used fields
in multiple databases and tables.
What you are looking at is probably a user-defined data type.
--
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
"tlft" <tlft@.discussions.microsoft.com> wrote in message
news:33732009-785F-4337-BA4D-0D36ADF930BA@.microsoft.com...
> IN on table I have a column with this type : ZusatzText
> what means ?
> What is the lenght of this colunm ?
> thanks