¿ÉÊÓ»¯´´½¨Ìí¼ÓµÄSQLÊý¾Ý¿âÔõôÌáÈ¡*.sqlÎļþ
ÈçÌâ¡£
ÎÒ¿ÉÊÓ»¯²Ù×÷µÄ¡£
ÎÒÏëÌáÈ¡³öÄÇÖÖ¡£sqlÓï¾ä¡£ ³ÉÒ»¸ö*¡£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ת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
--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 ......
Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿
Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ.....
ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡
½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......