hi friends...
good morning,
i want to get the integer 1 as 0001 in a table,
is there any keyword for this...
------------------
id | cname
------------------
0001 | king
0002 | hall
0003 | jack
. | .
. | .
. | .
1000 | don
Me, again.I have in drop down list values like: 0001, 0002, 0003,...When I insert them in database they are converted to 1, 2, 3,...What type of data should I use in ms sql 2000 for this not to happen?
View 2 Replies View RelatedHi,
I am trying to transfer a table from DB2 to SQLServer 2000 through a DTS package. The DB2 table contains fields with default dates of "0001-01-01". The DTS package errors out whenever it reads this date as "invalid data value". In SQLServer 2000, the date fields are of type ShortDateTime. I have searched the Internet but did not find a workable solution. Please, can anyone help me find a solution?
Hi,
How to make (int) Identity auto increment field showed like
0001
0002
0003
0004
...
Hi
can somebody explain me how I can assign a NULL value to a datetime type field in the script transformation editor in a data flow task.
In the script hereunder, Row.Datum1_IsNull is true, but still Row.OutputDatum1 will be assigned a value '0001-01-01' which generates an error (not a valid datetime). All alternatives known to me (CDate("") or Convert.ToDateTime("") or Convert.ToDateTime(System.DBNull.Value)) were not successful.
Leaving out the ELSE clause generates following error: Error: Year, Month, and Day parameters describe an un-representable DateTime.
If Not Row.Datum1_IsNull Then
Row.OutputDatum1 = Row.Datum1
Else
Row.OutputDatum1 = CDate(System.Convert.DBNull)
End If
Any help welcome.