Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
sql_server 217
t-sql 211
tsql 116
sqlserver 96
BRH 78
#SQLServer 66
#TSQL 56
SQL Server 34
function 11
SSMS 9

Archive · View All
August 2007 17
August 2010 8
June 2012 7
June 2011 7
November 2007 7
August 2012 6
May 2012 6
November 2011 6
August 2011 6
October 2011 6

Madhivanan's TSQL Blog

Identity column with decimal datatype

Jan 30 2012 1:14AM by Madhivanan   

One of the members in the forum asked about using decimal datatype in identity column. The question was "Is decimal point allowed in the identity column?" Ok. The identity column can never have any decimal points. It is a whole number. The decimal datatype can be used to have a bigger number in the identity column as decimal can have maximum of 38 digits.

The following are the code to create an identity column with decimal datatype

1 Specify scale as 0

declare @t table(i decimal(38,0) identity(1,1))
insert into @t default values
select * from @t

2 Omit scale part

declare @t table(i decimal(38) identity(1,1))
insert into @t default values
select * from @t

Tags: t-sql, sql_server, decimal, sqlserver, tsql, identity,


Madhivanan
3 · 40% · 12899
8 Readers Liked this
Atul Liked this on 2/11/2012 1:12:00 AM
Profile
Guru Samy Liked this on 2/25/2012 3:23:00 AM
Profile · Blog
Nakul Vachhrajani Liked this on 2/6/2012 11:41:00 PM
Profile · Blog · Facebook · Twitter
Madhivanan Liked this on 1/30/2012 2:27:00 AM
Profile · Blog · Facebook · Twitter
Kirti M.Darji Liked this on 1/31/2012 1:47:00 AM
Profile · Blog · Facebook · Twitter
Alpesh Gorasia Liked this on 2/7/2012 6:36:00 AM
Profile
Jacob Sebastian Liked this on 2/11/2012 1:51:00 AM
Profile · Blog · Facebook · Twitter
Himani Liked this on 3/5/2012 1:35:00 AM
Profile
8
Liked
 
0
Lifesaver
 
0
Refreshed
 
 
0
Incorrect



Submit

2  Comments  

  • It's interesting to use the decimal data-type as an identity column.

    commented on Feb 6 2012 11:42PM
    Nakul Vachhrajani
    4 · 36% · 11606
  • by using decimal type, the range values may be increased with respect to bigint type

    commented on Feb 11 2012 1:13AM
    Atul
    784 · 0% · 38

Your Comment


Sign Up or Login to post a comment.

"Identity column with decimal datatype" rated 5 out of 5 by 8 readers
Identity column with decimal datatype , 5.0 out of 5 based on 8 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]