convert varchar to datetime
-
hi i havae to insert data from one record to another for that i created a trigger CREATE TRIGGER trigInsertion on master AFTER insert as INSERT into child SELECT Convert(varchar(50),master_date,105) FROM inserted in this i need to convert varchar to datetime and insert these values into child table but it is not working padma
-
hi i havae to insert data from one record to another for that i created a trigger CREATE TRIGGER trigInsertion on master AFTER insert as INSERT into child SELECT Convert(varchar(50),master_date,105) FROM inserted in this i need to convert varchar to datetime and insert these values into child table but it is not working padma
hi for converting varchar to date use convert(datetime,FIELD) try to include the error message..so that we can identify the problem Regards Joe
-
hi for converting varchar to date use convert(datetime,FIELD) try to include the error message..so that we can identify the problem Regards Joe
in sql express How we know that user has inserted new row or update old row, is there any keyword to find out. padma
-
hi i havae to insert data from one record to another for that i created a trigger CREATE TRIGGER trigInsertion on master AFTER insert as INSERT into child SELECT Convert(varchar(50),master_date,105) FROM inserted in this i need to convert varchar to datetime and insert these values into child table but it is not working padma
-
hi i havae to insert data from one record to another for that i created a trigger CREATE TRIGGER trigInsertion on master AFTER insert as INSERT into child SELECT Convert(varchar(50),master_date,105) FROM inserted in this i need to convert varchar to datetime and insert these values into child table but it is not working padma
I WILL TRY TO HELP YOU SOON THANKS MAHEN