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

sqlÖÐÑ­»·²åÈë´óÁ¿²âÊÔÊý¾Ý

declare @a int
set @a = 1  
while @a<1000000  
begin
    insert into Test(name) values(@a)  
    set @a = @a + 1  
end


Ïà¹ØÎĵµ£º

SQL Server 2005/2008Êý¾Ý¿âÓʼþ

Æô¶¯Êý¾Ý¿âÓʼþ¹¦ÄÜ
 
sp_configure 'show advanced', 1;
GO
RECONFIGURE;
GO
sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE;
GO
 
 
 
 -- ÅäÖÃÊý¾Ý¿âÓʼþ
 -- Ìí¼ÓÓʼþÕË»§
execute msdb.dbo.sysmail_add_account_sp
    @account_name = 'ÓÊÏäÕ ......

¹ØÓÚDB2 sql:0206n ´íÎó

½ñÌìÅöµ½Ò»¸ösql:0206nµÄ´íÎó£¬ÎÒʹÓÃselect * from xxx¿ÉÒԲ鿴±í½á¹¹ºÍÄÚÈÝ£¬È»¶øµ±ÎÒʹÓÃselect aaa from xxxµÄʱºòÈ´¸øÎÒ±¨´í£¬×îºóÅŲéÔ­ÒòÊÇÎÒʹÓù¤¾ß½¨±í£¬½¨±íÓï¾äÊÇÀàËÆÕâÑùµÄ£ºcreate table("id" int,"name" varchar)£¬ºÃÁ˽á¹û¾ÍÊÇ×ֶθø¼ÓÁËÒýºÅ£¬ÔÚ²éѯµÄʱºòʹÓÃ*¿ÉÒÔ²éѯ£¬Ê¹Óõ¥¸ö×ֶβ»Äܲéѯ£¬ÎÒ¹À¼Æ¾ÍÊ ......

sql server°²×°°æ±¾²é¿´


SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
productversion£º²úÆ·°æ±¾£¨ÀýÈ磬10.0.1600.22£©
productlevel£º²úÆ·¼¶±ð£¨ÀýÈ磬RTM£©
edition£º°æ±¾£¨ÀýÈ磬 Enterprise£¨ÆóÒµ°æ£©¡¢Developer Edition£¨¿ª·¢°æ£©£©
SELECT @@VERSION
΢Èí¾ßÌå˵Ã÷£º
......

sql¶à±íÁªºÏ²éѯµÄÎÊÌâ

ÏÖÔÚÓöµ½Á˸öÊý¾Ý¿â²éÕÒµÄÎÊÌ⣬Á¬½Ó²éÕÒ£¬ÏÖÔÚÓÐÈý¸ö±íusers ±í£¬sex±í£¬languages±í£¬sex±íÖеÄlang_id ºÍmotherlang_idÊÇÖ÷¼üÍâ¼ü¹ØÏµ
ͼƬ£º
ÁªºÏ²éÕÒÐÅϢʱ
Èç¹ûÐÅÏ¢ÍêÕûµÄ»°ÊÇ¿ÉÒÔ²éÕÒ³öÀ´µÄ£¬µ«ÊÇÐÅÏ¢²»ÍêÕûµÄ»°¾Í²îÕÒ²»³öÀ´¡££¨Èç Óû§tanaka¾ÍÎÞ·¨²é³öÐÅÏ¢£©²éÕÒÓï¾äÈçÏ£º
select users.id,username,sex_name ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ