没有用过dtpicker,查询两个时间: select * from table where table.时间 between datevalue('01-01-01') and datevalue('02-02-02')
1.把你的触发器代码贴出来 2.select * from xxx where xxx<'2002-05-12' and xxx>'2002-05-01'用format(dtpicker1.value,"YYYY-MM-DD")转换一下3.有现成的控件可以用
同意 antshome(我也.net了) 触发器没有代码是不知道什么问题的。
我是第一次做这方面的东西,看书也只懂的模模糊糊,请大家多多指教 以下是触发器代码: Create Trigger Client_Trigger1 On dbo.Client For Delete As delete * from C_family where C_family.cnum=Client.cnum
select * from table where table.时间 between datevalue('01-01-01') and datevalue('02-02-02')
2.select * from xxx where xxx<'2002-05-12' and xxx>'2002-05-01'用format(dtpicker1.value,"YYYY-MM-DD")转换一下3.有现成的控件可以用
触发器没有代码是不知道什么问题的。
以下是触发器代码:
Create Trigger Client_Trigger1
On dbo.Client
For Delete
As
delete * from C_family where C_family.cnum=Client.cnum
On dbo.Client
For Delete
As
delete C_family
from deleted
where C_family.cnum=deleted.cnum
go
现在出现这样的错误:ado错误:line 8:Incorrect syntax near'go'.
Create Trigger Client_Trigger1
On dbo.Client
For Delete
As
delete C_family
from deleted inner join C_family
on C_family.cnum=deleted.cnum
delete from tablename
2,select * from tablename where 时间 between convert(char(10),date1,111) and convert(char(10),date2,111)