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

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


Ïà¹ØÎĵµ£º

MS SQL ServerºÍMySQLÇø±ð

1 MySQLÖ§³Öenum,ºÍsetÀàÐÍ£¬SQL Server²»Ö§³Ö
¡¡¡¡2 MySQL²»Ö§³Önchar,nvarchar,ntextÀàÐÍ
¡¡¡¡3 MySQLµÄµÝÔöÓï¾äÊÇAUTO_INCREMENT£¬¶øMS SQLÊÇidentity(1,1)
¡¡¡¡4 MS SQLĬÈϵ½´¦±í´´½¨Óï¾äµÄĬÈÏÖµ±íʾÊÇ((0)),¶øÔÚMySQLÀïÃæÊDz»ÔÊÐí´øÁ½À¨ºÅµÄ
¡¡¡¡5 MySQLÐèҪΪ±íÖ¸¶¨´æ´¢ÀàÐÍ
¡¡¡¡6 MS SQLʶ±ð·ûÊÇ[],[type]±íÊ ......

sql ³£ÓõĴúÂë

£¨1£©
Mcirosoft JET SQL ÖУ¬ÈÕÆÚÓÑ#’¶¨½ç¡£ÈÕÆÚÒ²¿ÉÒÔÓÃDatevalue()º¯ÊýÀ´´úÌæ¡£ÔڱȽÏ×Ö·ûÐ͵ÄÊý¾Ýʱ£¬Òª¼ÓÉϵ¥ÒýºÅ’’£¬Î²¿Õ¸ñÔڱȽÏÖб»ºöÂÔ¡£
Àý£º
WHERE OrderDate>#96-1-1#
Ò²¿ÉÒÔ±íʾΪ£º
WHERE OrderDate>Datevalue(‘1/1/96’)
ʹÓà NOT ±í´ïʽÇó·´¡£
Àý£ ......

°ÑSQL ServerÊý¾Ý±íµÄÄÚÈÝת»»ÎªÏàÓ¦µÄINSERTÓï¾ä

±ÊÕßÔøÔÚ¡¶³ÌÐòÔ±¡·2009Äê11ÆÚÉÏ̽ÌÖTransact-SQLµÄÔª±à³Ì£¬¼´Í¨¹ýĿ¼ÊÓͼ¡¢ÔªÊý¾Ýº¯ÊýµÈ·½Ê½·ÃÎÊÊý¾Ý¿âµÄÔªÊý¾ÝÐÅÏ¢£¬ÔÚÖ´Ðйý³ÌÖж¯Ì¬Éú³ÉSQL½Å±¾¡£µ±Ê±ÏÞÓÚÆª·ù£¬Ëù¸øµÄÀý×Ó½ÏÉÙ¡£ÕâÀï¸ø³ö¶¯Ì¬Éú³ÉSQL½Å±¾µÄÒ»¸öµäÐÍÓ¦Ó㬰ÑÊý¾Ý±íµÄÄÚÈÝת»»ÎªÏàÓ¦µÄINSERTÓï¾ä¡£
Õâ¸öÆô·¢À´×ÔÎÒ¹ÜÀíÔ¶³ÌÊý¾Ý¿âµÄ¾­Àú¡£ÎÒ³£³£ÐèÒªÓñ¾ ......

SQL MINUSµÄÓ÷¨


< type="text/javascript">
document.body.oncopy = function() {
if (window.clipboardData) {
setTimeout(function() {
var text = clipboardData.getData("text");
......

sql ÃüÃûÎÊÌâ

ÕýÈ·µÄ£ºselect isnull(money,0) from (select  sum(money) as money,3 as b from zhangbenjilu where datepart(month,usedatetime)=3) as a
´íÎóµÄ£ºselect isnull(money,0) from (select  sum(money) as money,3  from zhangbenjilu where datepart(month,usedatetime)=3) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ