win7Éϰ²×°sqlserver - MS-SQL Server / ÒÉÄÑÎÊÌâ
ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000ûÊÔ¹ý¡£
ÎÒÔÚWINDOWS 2008 R2ÉÏ×°¹ý¡£¿ÉÒÔµÄ
win2008ÊÇ·þÎñÆ÷Âï
¾Ý˵sql2005ÔÚ°²×°sp3ºó¾Í¿ÉÒÔÁË
²»¹ý±¾ÈËʹÓÃsql2k¶àÒ»µã£¬sql2005»¹²»Ï°¹ß¡£
WIN7¶¼Ã»ÓÐ×°¹ý,¾Í±ðÌá×°SQL SERVER
Â¥ÉÏáÝ·ðÊÇÅ£ÈË
2000ÊÇ×°²»É쵀 N¶àÈ˶¼ÕâÑù˵
Ïà¹ØÎÊ´ð£º
sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔÎ µ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
--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 ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......