SQL code:
SQL> select * from student;
NAME AGE
---------- ----------
a 18
b 18
c 18
d 19
e 19
f 19
g 18
h 18
i 18
� ......
求个SQL2005里命令集
最好有解释的!
同求.
不过好象联机帮助里面有.
MSDN
联机丛书.
哦;我以前有笔记的;但是丢了;郁闷...谢谢各位了;分数平均分哦@_@
去书店看那种像砖一样重的书，肯定会很全
也可以买回来
http://hi.csdn.net/space.php?uid=3834954&do=thread&id=3068
http://b ......
两个sql的版本：
SQL code:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 ......
各位高手, 本人想以下資料只取每隻MODEL之最尾ORDER NO
modelno order no
MODELA A09001
MODELA A09002
MODELB A09004
MODELB A09005
MODELC A09006
MODELC A09007
本人想要之答案是
MODELA A09002
MODELB ......
数据库的表有信息表SMS，如下
SMSID SenderType SenderID ReceiverID Title
1 0 3 1,2 hi
2 ......
select a.*,b.OutTime,b.InTime,convert(numeric(3,1),(datediff(minute,b.InTime,b.OutTime)-60)/60.0) as TotalTime
from BeProDailyReport as a
left join BM001Duty as b
on a.ReportDate=b.CheckDay and a.EmployeeID=b.EmployeeID
sql里面有没有判断的语句
类似于C#：
int a;
int ......
最新文章 :