|
skima (m)
|
I just converted a desktop application to online based (real big work). the software uses MSSql, so i'd developed the application wit mysql so what i did was to develop a module that will dump the data from mysql to mssql, the module worked fine. so d only error is the datetime data types in MSSQL since the format is different from that of MYSQL. i wrote a function that will do the conversion (like this from 2008-02-22 to 22/02/2008) so while inserting into the MSSQL i got error that NULL value not allowed even when there is a visible data. the date column in MSSQL DOES NOT ACCEPT NULL that is the column is compulsory.
example : INSERT INTO table_name (user_id,uname,date_reg) VALUES ('0','myname','22/02/2008')
that exactly how the generated insertion script works. so it always return NULL value not accepted for the date field.
i do not have wide experience in MSSQL, but i do for MYSQL.
help please
|
|
|
|
|
|
ThePhantom (m)
|
You said you are moving data from Mysql to MSql, maybe you do have a row without data? Anyway this is how you fix it, go into Enterprise manager in MSSQL right click on the table click design table and select "allow null". Also if you are using the insert statement as you showed above you can include "ISNULL"
example : INSERT INTO table_name (user_id,uname,date_reg) VALUES ('0','myname',ISNULL(Date,'unknown')
If there is a null in the date field it will change it to "unknown"
|
|
|
|
|
|
skima (m)
|
@phantom thanx man i will try it out.
is the Date ISNULL(Date,'unknown') a reserved in the query?
|
|
|
|
|
|
ThePhantom (m)
|
Sorry, I just used that as an example.
replace the date with the name of the field you are appending from
ISNULL([your date field],'unknown')
|
|
|
|
|
|
skima (m)
|
thanx man. i took time to run some queries direct on the mssql den debug straight from there. its now working fine.
thanx.
|
|
|
|
|
|
![Nairaland [Nigerian Forum] Home](http://www.nairaland.com/Themes/default/images/english/home.gif)
Author
