Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : sqlserver

sqlserver Êý¾Ý¿â±¸·ÝÎÊÌâ

ÎÒÔÚ±¾µØÓÃMicrsosoft sql server managementÁ¬½Ó·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÎÒÏë°Ñ·þÎñÆ÷ÉϵÄÊý¾Ý¿â ±¸·Ýµ½ÎÒ±¾µØ¡£¿ÉÒÔÔõôҲ²»³É¹¦¡£
µÚÒ»ÖÖ·½·¨ÊÇÓÃsql£º
Backup Database test_database
To disk='C:\test_database.bak'
µÚ¶þÖÖ·½·¨£º
Ñ¡ÔñÊý¾Ý-ÈÎÎñ-±¸·Ý
ÕâÁ½ÖÖ·½·¨ ¶¼Ìáʾ¡°¶ÔÊý¾Ý¿â¡°test_database¡±µÄ±¸·ÝÒԳɹ¦Íê³ ......

ÈçºÎÆÁ±ÎSQLSERVERµÇ¼Óû§ºÍÆô¶¯µÇ¼Óû§

ÈçºÎÆÁ±ÎSQLSERVERµÇ¼Óû§ºÍÆô¶¯µÇ¼Óû§
ÆÁ±ÎʲôÒâ˼¡£¡£¡£¡£


°²ÐÔÐÔ,µÇ¼Ãû,Ñ¡ÔñµÇ¼Óû§,ÓÒ¼üÊôÐÔ,״̬,½ûÓõǼ

SQL Server Management Studio-->°²È«ÐÔ-->µÇ¼Ãû-->Ñ¡ÔñµÇ¼Óû§-->ÓÒ¼üÊôÐÔ-->״̬-->½ûÓÃ/ÆôÓõǼ

ΪʲôÎÒÓÒ¼üÊôÐÔûÓÐ״̬ÄØ~ÎÒµÄÊÇ2000

2000ûÓÐ
......

ÇóÀàËÆsqlserverÖÐisnull()º¯ÊýÔÚaccessÖÐÈçºÎʵÏÖ

isnull(a,b)
¼´Èç¹ý×Ö¶ÎaΪnullÔò·µ»Øb
eg:
select isNUll(a,b) from table_1;

Ö±½Ó IFNULL¾ÍÐÐÁË¡£
SQL code:
mysql> select ifnull(null,2);
+----------------+
| ifnull(null,2) |
+----------------+
| 2 |
+----------------+
1 row in set (0.01 sec)
mysql> select ifnull(1,2) ......

¸ß·ÖÇósqlserverдexcel - MS-SQL Server / ÒÉÄÑÎÊÌâ

1.Ôõô°ÑÊý¾Ý´ÓsqlserverÀïÃæµÄÊý¾ÝдÈëµ½Ö¸¶¨Â·¾¶µÄexcel
±ÈÈç
declare @¹«Ë¾Ãû³Æ char(50)
set @¹«Ë¾Ãû³Æ = (select ¹«Ë¾Ãû³Æ from ¹«Ë¾ÐÅÏ¢)
EXEC [master]..xp_cmdshell 'bcp "select * from [master].tab_a" queryout D:\'+ convert(varchar,@¹«Ë¾Ãû³Æ)+'\ssss.xls -c -q -S"." -U"sa&q ......

sqlserver ɾ³ýÖظ´¼Ç¼ÁôÒ»Ìõ

sqlserver ɾ³ýÖظ´¼Ç¼ÁôÒ»Ìõ£¬¼´ÓÐÖظ´×Ö¶ÎÖ»Òª±£ÁôÒ»Ìõ¼Ç¼ÆäÓàµÄ¶¼É¾³ý¡£
»áÓÐÈËÌùµÄ¡£¡£


´¦Àí±íÖظ´¼Ç¼(²éѯºÍɾ³ý)

Â¥ÉϵĺÜÈ«ÁË

http://www.sohu.com
<a href="www.hao123.com">xianlaoy</a>
......

sqlserverÖÐתÒåµÄд·¨ÎÊÌâ

select * from export where Æ·ÅÆ is not null and ÎÄÕ±êÌâ like '%»¹ÒªÈ̶à¾Ã?·áÌïµÄ'ɲ³µ'Óë'»Ø¹é'%'
Õâ¾ä²éѯÓï¾äתÒåÔõôдѽ£¬Çë´ó¼Ò°ïÏÂ棬лÁË
SQL code:
select * from export where Æ·ÅÆ is not null
and ÎÄÕ±êÌâ like '%»¹ÒªÈ̶à¾Ã?·áÌïµÄ''ɲ³µ''Óë''»Ø¹é''%'

SQL code:
select * from export w ......
×ܼǼÊý:322; ×ÜÒ³Êý:54; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [2] [3] [4] [5] 6 [7] [8] [9] [10] [11]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ