Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¿ÉÊÓ»¯´´½¨Ìí¼ÓµÄSQLÊý¾Ý¿âÔõôÌáÈ¡*.sqlÎļþ


ÈçÌâ¡£

ÎÒ¿ÉÊÓ»¯²Ù×÷µÄ¡£

ÎÒÏëÌáÈ¡³öÄÇÖÖ¡£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µ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

ÇóÒ»ÌõSQL - MS-SQL Server / ÒÉÄÑÎÊÌâ

--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 ......

sql server - Java / Eclipse

Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿
Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ.....

ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡

½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ