SQLÑ»·ÓαêµÄʹÓÃ
½ñÌì¸ãµÄ£¬°ïͬʲéѯÊý¾Ý£¬ÏÈд¸ö´¥·¢Æ÷£¬½ØÈ¡http://www.chinaroyalgroup.cn/aspnet_client/system_web/2_0_50727/dispbbs.asp?boardid=1&id=836ÀïµÄÓòÃû
IF EXISTS (SELECT name from sysobjects
WHERE name = 'gs_MySub' AND type = 'P')
DROP PROCEDURE gs_MySub
GO
create proc gs_MySub
@www varchar(100),
@result varchar(100) output,
@end int = 0
as
set @www = REPLACE(@www, 'http://', '') --Ìæ»»µôhttp://
set @end = PATINDEX('%/%', @www) --µÃµ½µÚÒ»´Î³öÏÖ'/'µÄλÖÃ
set @result = SUBSTRING(@www, 0, @end) --½ØÈ¡
GO
SQL²éѯ·ÖÎöÆ÷À
declare cur_domain1 cursor
for
select domain from test1
open cur_domain1
declare @result varchar(100)
declare @domain varchar(100)
Fetch next from cur_domain1
while (@@fetch_status<>-1)
begin fetch next from cur_domain1
INTO:@domain
exec gs_MySub @domain, @result output
print @result
end
close cur_domain1
Ïà¹ØÎĵµ£º
C#Á¬½ÓSQL ServerµÄSqlConnectionµÄ×Ö·û´®£¬Ðí¶à¶¼ÊDz»ÄÜÁ¬½ÓµÄ¡£ÏÖÔÚ¸øÒ»¸öÄÜÁ¬½ÓµÄ£º
using System.Data.SqlClient;
public class sqlServerConnection {
//
public static void Main() {
//ÏÂÃæ¾ÍÊDZê×¼µÄÁ¬½Ó£¬×¢ÒâSERVERÊÇÎҵļÆËã»úÃû¡£SQLEXPRESSÊÇÊý¾Ý¿âʵÀý¡£SSPI±íʾʹÓÃWindowsµÇ½µÄÕÊ»§¡£masterÊÇÒªÁ¬½Óµ ......
½üÆÚÒò¹¤×÷ÐèÒª£¬Ï£Íû±È½ÏÈ«ÃæµÄ×ܽáÏÂ
SQL SERVER
Êý¾Ý¿âÐÔÄÜÓÅ»¯Ïà¹ØµÄ×¢ÒâÊÂÏÔÚÍøÉÏËÑË÷ÁËÒ»ÏÂ
,
·¢ÏֺܶàÎÄÕÂ
,
ÓеͼÁгöÁËÉϰÙÌõ
,
µ«ÊÇ×Ðϸ¿´·¢ÏÖ£¬ÓкܶàËÆÊǶø·Ç»òÕß¹ýʱ
(
¿ÉÄܶÔ
SQL SERVER6.5
ÒÔǰµÄ°æ±¾»òÕß
ORACLE
ÊÇÊÊÓõÄ
)
µÄÐÅÏ¢£¬Ö»ºÃ×Ô¼º¸ù¾ÝÒÔǰµÄ¾ÑéºÍ²âÊÔ½á¹û½øÐÐ×ܽáÁË¡£
ÎÒ ......
ËäȻ˵ÎÒÃǾ¡Á¿ÔÚд³ÌÐòµÄʱºò¿ØÖƲåÈëµ½Êý¾Ý¿âµÄÊý¾Ý£¬¶ø²»ÒªÓÃÊý¾Ý¿âÈ¥ÅжÏÊý¾ÝµÄ¶Ô´í£¬µ«ÊÇÓÐʱºòΪÁË·½±ã»¹ÊÇÐèÒªÊý¾Ý¿â×ÔÉíµÄÈÝ´íÄÜÁ¦À´°ïÖúÎÒÃǴﵽĿµÄµÄ¡£¾ÙÀý˵Ã÷£º
´´½¨ÈçÏÂÊý¾Ý±í
CREATE TABLE `book` (
`id` int(11) default NULL,
`num` int(11) unsigned default NULL
) ENGINE=InnoDB DE ......
--sql server 2005
-- 1. ±í½á¹¹ÐÅÏ¢²éѯ
-- ========================================================================
-- ±í½á¹¹ÐÅÏ¢²éѯ
-- ×Þ½¨ 2005.08(ÒýÓÃÇë±£Áô´ËÐÅÏ¢)
-- ========================================================================
SELECT
TableName=CASE WHEN ......
´¥·¢Æ÷ʵ¼ÊÉϾÍÊÇÒ»ÖÖÌØÊâÀàÐ͵Ĵ洢¹ý³Ì£¬ÆäÌØÊâÐÔ±íÏÖÔÚ£ºËüÊÇÔÚÖ´ÐÐÌØ¶¨µÄT-SQL ×Ô¶¯Ïà¼ÓµÄ¡£
´¥·¢Æ÷·ÖΪÁ½Àࣺ
&nbs ......