sql ѧϰ×ÊÁÏ
Çë´ó¼Ò¸øµãsql¸ß¼¶±à³ÌµÄ×ÊÁÏ
°¡£¿²»Êǰɣ¬Õâ¸öÊÇsilverlightƵµÀ£¬ÏëÒªsqlµÄ×ÊÁÏÈ¥sqlƵµÀ£¬ÄÇÀïºÜ¶àµÄ¡£¡£¡£ÅµÅµµÄ˵һ¾ä£¬¸Ð¾õÕâ¸öÎÊÌâºÃɵ°¦¡£¡£¡£ºÙºÙ
·¢Õâô¶à¡£¡£¡£
¸øÄãÒ»¸öÊղصĶ«Î÷¸øÄã¡£
Áí£ºÊµ¼ù³öÕæÖª
http://topic.csdn.net/u/20080515/16/6f359854-5403-4397-89e3-b1b8dd71d527.html
http://www.zaoxue.com/down/tech-11575.htm
http://www.zychina.com.cn/code/1886.html
http://download.chinaitlab.com/database/files/10806.html
http://www.itxuexi.com/resource/5659/
ÍøÉϺܶࡣ
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
--drop table #T1
--drop table #T2
create Table #T1(ID int,
QueryID nvarchar(20),
ResultID1 nvarchar(20),
ResultID2 nvarchar(20))
create Table #T2(SortNo int,
QueryID nvarchar(20),
ResultID1 nv ......