www.3112.net > SQL查询中,"SELECT 学号,姓名,性别 FROM 学生 W...

SQL查询中,"SELECT 学号,姓名,性别 FROM 学生 W...

String s = "sf"; String sql = "select * from stu where stuName like '%"+s+"%'";

string sql=string.Format("select * from student where date='{0}' ",DateTime.Parse("2014-08-16 13:00:00")); 改成上面语句试试先,如果上面语句运行不报错说明是你的txtDate.Text不是时间格式的字符串

1.select * from works where not exists(select 1 from data_1 where works.id=data_1.w_id) 2..select * from works where exists(select 1 from data_1 where works.id=data_1.w_id)

这两个东西看起来应该是自定义的两个函数,比如sql_r的作用可能是执行括号里面的select语句,得到的结果集合赋值给rs

from e191_sporter x --x是e191_sporter的临时表名字, from e191_sporter w,e191_grade y --w y也是 from e191_grade z 这些可以这样写:from e191_grade as z (其中一个作用就是简化写法) y.pno 其实就是e191_grade.pno

网站地图

All rights reserved Powered by www.3112.net

copyright ©right 2010-2021。
www.3112.net内容来自网络,如有侵犯请联系客服。zhit325@qq.com