SQLSERVER - 随笔分类 - Tony_yrb

摘要：replace(convert(varchar(20),regtime,112)+convert(varchar(40),regtime,114),':','') 阅读全文

posted @ 2006-08-28 17:39 Tony_yrb 阅读(361) 评论(0) 推荐(0)

摘要：select left(strMobileNo,4),count( strMobileNo)from no_kldby_userinfowhere dteRegTime >= '2006-08-14 00:00:00' group by left(strMobileNo ,4) 阅读全文

posted @ 2006-08-21 17:55 Tony_yrb 阅读(1301) 评论(0) 推荐(0)

指令书

摘要：步进状态阅读全文

posted @ 2006-08-10 15:19 Tony_yrb 阅读(271) 评论(0) 推荐(0)

sql

摘要：select top 1 @other_int=id,@outtext =tab1 ,@other_str = tab2 from jzwd_content order by newid() 阅读全文

posted @ 2006-07-06 13:44 Tony_yrb 阅读(146) 评论(0) 推荐(0)

easylearning