use dsr_ylh
--select*from 包卡消费明细 where 包卡编号='800002865'
insert into 包卡消费明细(包卡编号,姓名,编号,商品名称,次数,预定日期,消费否,消费日期,ID)values('800002876','感恩卡','173','植丽素面部护理','1','2009-07-10 00:00:00.000','0','NULL','20090710ylhx001')
insert into 包卡消费明细(包卡编号,姓名,编号,商品名称,次数,预定日期,消费否,消费日期,ID)values('800002876','感恩卡','173','植丽素面部护理','2','2009-07-17 00:00:00.000','0','NULL','20090710ylhx002')
insert into 包卡消费明细(包卡编号,姓名,编号,商品名称,次数,预定日期,消费否,消费日期,ID)values('800002876','感恩卡','174','肾部保养护理','1','2009-07-10 00:00:00.000','0','NULL','20090710ylhx003')
insert into 包卡消费明细(包卡编号,姓名,编号,商品名称,次数,预定日期,消费否,消费日期,ID)values('800002876','感恩卡','174','肾部保养护理','2','2009-07-17 00:00:00.000','0','NULL','20090710ylhx004')
服务器: 消息 241,级别 16,状态 1,行 1
从字符串转换为 datetime 时发生语法错误。
请高手指点
--select*from 包卡消费明细 where 包卡编号='800002865'
insert into 包卡消费明细(包卡编号,姓名,编号,商品名称,次数,预定日期,消费否,消费日期,ID)values('800002876','感恩卡','173','植丽素面部护理','1','2009-07-10 00:00:00.000','0','NULL','20090710ylhx001')
insert into 包卡消费明细(包卡编号,姓名,编号,商品名称,次数,预定日期,消费否,消费日期,ID)values('800002876','感恩卡','173','植丽素面部护理','2','2009-07-17 00:00:00.000','0','NULL','20090710ylhx002')
insert into 包卡消费明细(包卡编号,姓名,编号,商品名称,次数,预定日期,消费否,消费日期,ID)values('800002876','感恩卡','174','肾部保养护理','1','2009-07-10 00:00:00.000','0','NULL','20090710ylhx003')
insert into 包卡消费明细(包卡编号,姓名,编号,商品名称,次数,预定日期,消费否,消费日期,ID)values('800002876','感恩卡','174','肾部保养护理','2','2009-07-17 00:00:00.000','0','NULL','20090710ylhx004')
服务器: 消息 241,级别 16,状态 1,行 1
从字符串转换为 datetime 时发生语法错误。
请高手指点
--select*from 包卡消费明细 where 包卡编号='800002865'
insert into 包卡消费明细(包卡编号,姓名,编号,商品名称,次数,预定日期,消费否,消费日期,ID)values('800002876','感恩卡 ','173','植丽素面部护理','1','2009-07-10 00:00:00.000','0',null,'20090710ylhx001')
insert into 包卡消费明细(包卡编号,姓名,编号,商品名称,次数,预定日期,消费否,消费日期,ID)values('800002876','感恩卡 ','173','植丽素面部护理','2','2009-07-17 00:00:00.000','0',null,'20090710ylhx002')
insert into 包卡消费明细(包卡编号,姓名,编号,商品名称,次数,预定日期,消费否,消费日期,ID)values('800002876','感恩卡 ','174','肾部保养护理','1','2009-07-10 00:00:00.000','0',null,'20090710ylhx003')
insert into 包卡消费明细(包卡编号,姓名,编号,商品名称,次数,预定日期,消费否,消费日期,ID)values('800002876','感恩卡 ','174','肾部保养护理','2','2009-07-17 00:00:00.000','0',null,'20090710ylhx004')