Viewing 5 posts - 31 through 35 (of 35 total)
Hi Kraig,
We cannot create a identity column on the table, it is a varchar field.
Is there any other way we can accomplish this ?
October 4, 2012 at 2:27 pm
#1545800
concatente 001-00- to 000001 (first number in the list)
in my case 1 is different from 000001
October 1, 2012 at 1:49 pm
#1544132
It works like a champ
Thank you very much Chris !!
September 24, 2012 at 7:26 am
#1541394
Thanks Luis for your reply,
Sample Data with decimal(18,0) datatype to be converted to datetime2
19970811
19970812
19970813
As the Datatype is in Decimal i convert into Varchar(27) as i need to convert to datetime2
Query...
September 24, 2012 at 7:01 am
#1541384
Hi ,
I need to convert the varchar(30) to datetime2 in SQL server , which works well in a select statement
-select
--cast(convert(datetime2,cast(clx.aprvdt as varchar(10)),101)as datetime2) ApprovalDate
--from CLMEXPM clx where clx.aprvdt<>0
but...
September 21, 2012 at 2:41 pm
#1540976