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

sql server 2000 ÈÕÖ¾ÒÑÂú

ÎÒÔÚ²éѯ·ÖÎöÆ÷ Ö´ÐÐÁËsql Óï¾ä ÌáʾÈÕÖ¾ÒÑÂú

¸½¼Ó·ÖÀë¿ÉÒÔ½â¾ö

Çë½ÌÓ¦¸ÃÔõÑùдsql Óï¾ä ÈÃÆä²»Ôö¼ÓÈÕÖ¾

SQL code:
ÏÂÃæµÄʾÀý·ÖÀë pubs Êý¾Ý¿â£¬²¢½« skipchecks ÉèΪ true¡£

EXEC sp_detach_db 'pubs', 'true'
?

ÎÒÊÔÊÔ

Êý¾Ý¿â->ÊôÐÔ->Ñ¡Ïî->Ä£ÐÍ  ÉèÖÃΪ¼òµ¥

Çë½ÌÓ¦¸ÃÔõÑùдsql Óï¾ä ÈÃÆä²»Ôö¼ÓÈÕÖ¾

Õâ¸ö¿ÉÒÔÏÞÖÆÔö³¤


Äĸö¿ÉÒÔÏÞÖÆÔö³¤£¿


ÎÒÔ­ÏÈÉèÖõÄÊǼòµ¥

ÒýÓÃ
SQL code--ÉèÖÃÈÕÖ¾¼Ç¼ģʽΪ×îСALTERDATABASE  Êý¾Ý¿âÃûSET  RECOVERY  simplego

ͬÒâ,²»ÖªµÀ»¹ÓÐÆäËûʲô·½·¨

use twfy
go
Truncate table  ybdata_new
go
BULK INSERT  ybdata_new from 'd:\ybdata.txt'WITH(FIELDTERMINATOR='\t',ROWTERMINATOR='\n',MAXERRORS=3)   
go

delete Ò½±£¶ÔÓ¦±í where itemtype = 'TJCJYPXX' or    itemtype = 'TJCJZLXX'
go
INSERT INTO Ò½±£¶ÔÓ¦±í (itemtype,itemnoyb,itemnameyb,itempym,itemmemoyb1,itemmemoyb2,itemmemoyb3,itemmemoyb4,itemmemoyb5,itemmemoyb6,itemmemoyb7,itemmemoyb8,itemmemoyb9,itemmemoyb10,itemmemoyb11,itemmemoyb12,itemmemoyb13,itemmemoyb14,itemmemoyb15,itemdatayb1,itemdatayb2,itemdatayb3,itemdatayb4,itemdatayb5,itemdatayb6,itemmemoyb17,itemmemoyb16)  sel


Ïà¹ØÎÊ´ð£º

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

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ת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

ÇóÒ»Ìõoracle¶à±í²éѯµÄsql£¬Çó¸ßÊÖÃDz»ÁߴͽÌ~

table1:
uID    uName
1      СÀî 
2      СÕÅ

table2:
pID  uID  type
1    1    H1
2    ......

SqlÅÅÐò - MS-SQL Server / »ù´¡Àà

ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ