sql server
iteye_5269
这个作者很懒,什么都没留下…
展开
-
一个语句备份
try { sql = "select a.tr_trnbr,a.tr_part,a.tr_rev,a.tr_custitmcode,a.tr_stockcode,left(CONVERT(varchar(12),a.tr_date, 121 ),10) as date,DATEDIFF(day,a.tr_date,'"+stoptime+"') as day,a.tr_nbr,isnull...2009-05-15 11:14:04 · 108 阅读 · 0 评论 -
sql server 交叉表 行转列 显示
[color=red]三个表(要求把学生每次考试情况列出来)[/color] [color=red]CREATE TABLE [dbo].[score]( [stuid] [int] NOT NULL, [sid] [int] NOT NULL, [score] [int] NOT NULL, [examtimes] [int] NULL )[/color] INSERT ...原创 2010-05-11 12:18:03 · 182 阅读 · 0 评论