sql ´æ´¢¹ý³Ì
ÎÒÒª×öÒ»¸ö¶¨µãʼþ£¬ÊÇÿÌìÍíÉÏ12µã¾Í°ÑÈý¸ö±íÀïµÄÐÅÏ¢·ÅÈëÒ»¸ö±íÀÎÒÏëÓô洢¹ý³ÌÀ´Ð´£¬ÔõÃ´Ð´ÄØ£¿£¬ÄÇλ¸ßÊÖ°ï°ïæ°É£¬·Ç³£¸Ðл£¡
Óû§ÃûÊÇΨһµÄ
±íA ×Ö¶Î
Óû§Ãû£ºName ,ÓÊÏ䣺Email£¬ ÁªÏµµç»°£ºPhome
±íB ×Ö¶Î
Óû§Ãû£ºName £¬ ½»Ò××ʽð£ºCapital £¬Ê±¼ä£ºTime
±íC ×Ö¶Î
Óû§Ãû£ºName £¬ ×ÜÊÕÈ룺Revenue £¬ÀûÈó£ºProfits
Òª°ÑÕâÈý¸ö±íµÄÐÅÏ¢·ÅÈëD±íÀïÃæ
±íD ×Ö¶Î
Name Email Phome Capital Time Revenue Profits
·Ç³£¸Ðл°ï°ïæ°É
insert into D(Name ,Email, Phome, Capital, Time, Revenue, Profits )
Select A.Name,A.Email,A.Phome,B.Capital,B.Time,C.Revenue,C.Profits
from A Inner Join B On A.Name=B.Name
Inner Join C On A.Name=C.Name
ÎÒÒª×öÒ»¸ö¶¨µãʼþ£¬ÊÇÿÌìÍíÉÏ12µã¾Í°ÑÈý¸ö±íÀïµÄÐÅÏ¢·ÅÈëÒ»¸ö±íÀ
дSQL JOB×÷Òµ¶¨Ê±Ö´ÐÐ,
SQL code:
insert into D(Name ,Email, Phome, Capital, Time, Revenue, Profits )
Select A.Name,A.Email,A.Phome,B.Capital,B.Time,C.Revenue,C.Profits
from A Inner Join B On A.Name=B.Name
Inner Join C On A.Name=C.Name
°ÑÓï¾ä·ÅÈë×÷ÒµÖÐ
SQL code:
Create Procedure P
a
Ïà¹ØÎÊ´ð£º
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......
ÏÖÔÚÓÐa1,a2Á½±í
a1
id name aa cc
001 aaaa bbb cc
002 bbb bbb bbb
003 ccc ccc ccc
004 ddd ddd ddd
005 eee eee eee
a2
id ida2 ff b ......
pl/SqlÈçºÎ²éѯ×Ö·û´®°üÀ¨%,
ÀýÈç:TABLE a
columnA
'222'
'33%44'
ÈçºÎ²éѯ±íaÖÐcolumnA×Ö¶ÎÖÐÄÄЩÐаüº¬'%'
лл
select * from a
where columna like '%/%%' escape '/'
UP
SELECT * from a ......