- 博客(4)
- 收藏
- 关注
原创 T-Sql多表查询
use pubsgo--查看p2121,p3087a 订单的定购数---讲点,分组来统计select ord_num, sum(qty) from sales group by ord_numselect ord_num, sum(qty) from sales group by ord_num -- having ord_num in(P2121,P3087a)
2006-05-05 07:45:00 1030
原创 T-Sql表查询
select * from sales where payterms=ON invoiceselect top 2 qty from sales where payterms=net 60select * from sales order by qtyselect * from sales where payterms=net 60 order by qtyselect
2006-05-05 07:44:00 596
原创 sql server表操作T-sql
create table StudentInfo( Stu_id varchar(10) primary key, Stu_Name varchar(20) not null, Stu_Sex varchar(2) default(男) check( Stu_sex in(女,男)), Brith_date datetime check(Brith_date Jion_date
2006-05-05 07:42:00 706
原创 年月日三级联动
function YYYYMMDDstart() { MonHead = [31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31]; //先给年下拉框赋内容 var y = new Date().getFullYear(); for (var i = (y-60); i {
2006-05-05 07:40:00 762
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人