sql ²éѯ³öÀ´Ò»¸ö±íÔÚ²åÈëµ½ÁíÒ»¸ö±íÀï
ALTER FUNCTION [dbo].[fun_tongji]()
RETURNS @t1 table (
yue int ,
money int
)
AS
begin
Declare @i int
set @i=1
-- declare @t1 table (
-- yue int ,
-- money int
-- )
while (@i<=12)
begin
INSERT into @t1 (yue,money) select isnull(sum(money),0) as money,@i as yue from zhangbenjilu where datepart(month,usedatetime)=@i
set @i=@i+1
end
return ;
end
Ïà¹ØÎĵµ£º
USE Test
--Create 2 tables as an example
CREATE TABLE ExampleTable
(
[ID] int PRIMARY KEY
,[Name] nvarchar(256)
)
CREATE TABLE ExampleTable2
(
[ID] int PRIMARY KEY
,[Name] nvarchar(256)
)
----way1
SELECT *
from sys.objects [table]
WHERE
[Name] LIKE 'ExampleTable%'
FOR XML AUTO, ROOT ......
Ò»¡¢Ê²Ã´ÊÇSQL×¢Èëʽ¹¥»÷?
¡¡¡¡ËùνSQL×¢Èëʽ¹¥»÷£¬¾ÍÊǹ¥»÷Õß°ÑSQLÃüÁî²åÈëµ½Web±íµ¥µÄÊäÈëÓò»òÒ³ÃæÇëÇóµÄ²éѯ×Ö·û´®£¬ÆÛÆ·þÎñÆ÷Ö´ÐжñÒâµÄSQLÃüÁî¡£ÔÚijЩ±í
µ¥ÖУ¬Óû§ÊäÈëµÄÄÚÈÝÖ±½ÓÓÃÀ´¹¹Ôì(»òÕßÓ°Ïì)¶¯Ì¬SQLÃüÁ»ò×÷Ϊ´æ´¢¹ý³ÌµÄÊäÈë²ÎÊý£¬ÕâÀà±íµ¥ÌرðÈÝÒ×Êܵ½SQL×¢Èëʽ¹¥»÷¡£³£¼ûµÄSQL×¢Èëʽ¹¥
»÷¹ý³ÌÀàÈ磺
......
AcessÓëSQLµÄÇø±ð
ÒÔÏÂ總結ÁË×Ô¼ºÔÚ項Ä¿ÖÐËùÓöµ½µÄÓÐ關Acess與SQL²î異µÄһЩµØ·½£º
1£¬¶ÔÓÚÈÕÆÚ×Ö¶Î×Ö¶Î
¡¡¡¡access±íʾΪ:#1981-28-12#
¡¡¡¡SQLSERVER2000±íʾΪ:''1981-02-12''
¡¡¡¡2,SQLÓï¾äÇø±ð£¬_select,_updateÔÚ¶Ôµ¥±í²Ù×÷ʱ¶¼²î²»¶à£¬
¡¡¡¡µ«¶à±í²Ù×÷ʱupdateÓï¾ ......
·þÎñÓë·þÎñÆ÷ÊÇÁ½¸ö²»Í¬µÄ¸ÅÄ·þÎñÆ÷ÊÇÌṩ·þÎñµÄ¼ÆËã»ú£¬ÅäÖ÷þ
ÎñÆ÷Ö÷ÒªÊǶÔÄÚ´æ¡¢´¦ÀíÆ÷¡¢°²È«ÐԵȼ¸¸ö·½ÃæÅäÖá£ÓÉÓÚSQL Server 2005·þÎñÆ÷µÄÉèÖòÎÊý±È½Ï¶à£¬ÕâÀïѡһЩ±È½Ï³£ÓõĽéÉÜ¡£
ÅäÖÃSQL Server 2005·þÎñÆ÷µÄ°ì·¨£ºÆô¶¯¡¾SQL
Server Management
Studio¡¿£¬ÔÚ¡¾¶ÔÏó×ÊÔ´¹ÜÀíÆ÷¡¿´°¿ÚÀÓÒ»÷ÒªÅäÖõķþÎ ......
×ªÔØ£º
http://blog.sina.com.cn/s/blog_5f4ed9cb0100dza0.html
http://wowh.wuyan.org/2008/04/15/sqlserver-2k-system-error-126/
ÔÚ°²×°sql server ¾³£Óöµ½ÕâÑù¡¢ÄÇÑùµÄ´íÎ󣬽ñÌìÔÚËѵ½±È½ÏÈ«ÃæµÄ£¬¾ÍÌù³öÀ´£¬·ÖÏíÏ£¡
SQL
Server°²×°ÎÊÌâ´óÈ«
(2007-09-06
09:24:28)
±êÇ©£ºIT/¿Æ¼¼
Ò¼¡£WINDOWS XP ......