Re: WEird Column as Int property returns Decimal!!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tracy Myint (mswebwyz_at_hotmail.com)
Date: 06/21/04 

Date: Mon, 21 Jun 2004 09:40:10 -0700

I had the same problem and have solved this.

My table's identity column was on Integer type. Before, my stored proc
had only:

(... sproc body ...)
SELECT @@IDENTITY
GO

@@IDENTITY in SQL Server is of type numeric value. In SQL Server, the
numeric data type is equivalent to the decimal data type.

Now, I have this, which returns an Integer type.

DECLARE @request_id int
(... sproc body ...)
SET @request_id = @@IDENTITY

SELECT @request_id

GO

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Sizes of Integer Types
    ... an integer type of "at least" 32 bits, which is what I'd get if I ... If your target platform does not have an 8-bit data type, ... a.c.l.l.c-c++ FAQ: http://www.comeaucomputing.com/learn/faq ...
    (comp.lang.c)
  • Re: Sizes of Integer Types
    ... Kelsey Bjarnason wrote: ... way to get that data type is to use int32_t. ... close equivalents. ... an integer type of "at least" 32 bits, which is what I'd get if I used ...
    (comp.lang.c)
  • Re: Visual Studio 2005 x64 mode.
    ... just like in GCC. ... What again are you complaining about? ... order to get 64-bit integer type one should use `long long' type: ... "Data Type Ranges" ...
    (microsoft.public.vc.language)
  • Re: Access 2007 Query
    ... There's been no change in this regards from access 2003 to 2007, ... is perhaps the column that you've defined is an integer or long integer type ... I would open up the table in design mode and check the data type that you ... Albert D. Kallal ...
    (microsoft.public.access.queries)
  • Re: Sizes of Integer Types
    ... way to get that data type is to use int32_t. ... close equivalents. ... an integer type of "at least" 32 bits, which is what I'd get if I used ...
    (comp.lang.c)