²»´íµÄSQLÃæÊÔÌ⣨¶þ£©
ÎÊÌâÃèÊö£º
±¾ÌâÓõ½ÏÂÃæÈý¸ö¹Øϵ±í£º
CARD ½èÊ鿨¡£ CNO ¿¨ºÅ£¬NAME ÐÕÃû£¬CLASS °à¼¶
BOOKS ͼÊé¡£ BNO ÊéºÅ£¬BNAME ÊéÃû,AUTHOR ×÷Õߣ¬PRICE µ¥¼Û£¬QUANTITY ¿â´æ²áÊý
BORROW ½èÊé¼Ç¼¡£ CNO ½èÊ鿨ºÅ£¬BNO ÊéºÅ£¬RDATE »¹ÊéÈÕÆÚ
±¸×¢£ºÏÞ¶¨Ã¿ÈËÿÖÖÊéÖ»ÄܽèÒ»±¾£»¿â´æ²áÊýËæ½èÊé¡¢»¹Êé¶ø¸Ä±ä¡£
ÒªÇóʵÏÖÈçÏÂ15¸ö´¦Àí£º
1£® д³ö½¨Á¢BORROW±íµÄSQLÓï¾ä£¬ÒªÇó¶¨ÒåÖ÷ÂëÍêÕûÐÔÔ¼ÊøºÍÒýÓÃÍêÕûÐÔÔ¼Êø¡£
2£® ÕÒ³ö½èÊ鳬¹ý5±¾µÄ¶ÁÕß,Êä³ö½èÊ鿨ºÅ¼°Ëù½èͼÊé²áÊý¡£
3£® ²éѯ½èÔÄÁË"Ë®ä°"Ò»ÊéµÄ¶ÁÕߣ¬Êä³öÐÕÃû¼°°à¼¶¡£
4£® ²éѯ¹ýÆÚδ»¹Í¼Ê飬Êä³ö½èÔÄÕߣ¨¿¨ºÅ£©¡¢ÊéºÅ¼°»¹ÊéÈÕÆÚ¡£
5£® ²éѯÊéÃû°üÀ¨"ÍøÂç"¹Ø¼ü´ÊµÄͼÊ飬Êä³öÊéºÅ¡¢ÊéÃû¡¢×÷Õß¡£
6£® ²éѯÏÖÓÐͼÊéÖм۸ñ×î¸ßµÄͼÊ飬Êä³öÊéÃû¼°×÷Õß¡£
7£® ²éѯµ±Ç°½èÁË"¼ÆËã·½·¨"µ«Ã»Óнè"¼ÆËã·½·¨Ï°Ì⼯"µÄ¶ÁÕߣ¬Êä³öÆä½èÊ鿨ºÅ£¬²¢°´¿¨ºÅ½µÐòÅÅÐòÊä³ö¡£
8£® ½«"C01"°àͬѧËù½èͼÊéµÄ»¹ÆÚ¶¼ÑÓ³¤Ò»ÖÜ¡£
9£® ´ÓBOOKS±íÖÐɾ³ýµ±Ç°ÎÞÈ˽èÔĵÄͼÊé¼Ç¼¡£
10£®Èç¹û¾³£°´ÊéÃû²éѯͼÊéÐÅÏ¢£¬Ç뽨Á¢ºÏÊʵÄË÷Òý¡£
11£®ÔÚBORROW±íÉϽ¨Á¢Ò»¸ö´¥·¢Æ÷£¬Íê³ÉÈçϹ¦ÄÜ£ºÈç¹û¶ÁÕß½èÔĵÄÊéÃûÊÇ"Êý¾Ý¿â¼¼Êõ¼°Ó¦ÓÃ"£¬¾Í½«¸Ã¶ÁÕߵĽèÔļǼ±£´æÔÚBORROW_SAVE±íÖУ¨×¢ORROW_SAVE±í½á¹¹Í¬BORROW±í£©¡£
12£®½¨Á¢Ò»¸öÊÓͼ£¬ÏÔʾ"Á¦01"°àѧÉúµÄ½èÊéÐÅÏ¢£¨Ö»ÒªÇóÏÔʾÐÕÃûºÍÊéÃû£©¡£
13£®²éѯµ±Ç°Í¬Ê±½èÓÐ"¼ÆËã·½·¨"ºÍ"×éºÏÊýѧ"Á½±¾ÊéµÄ¶ÁÕߣ¬Êä³öÆä½èÊ鿨ºÅ£¬²¢°´¿¨ºÅÉýÐòÅÅÐòÊä³ö¡£
14£®¼Ù¶¨ÔÚ½¨BOOKS±íʱûÓж¨ÒåÖ÷Â룬д³öΪBOOKS±í×·¼Ó¶¨ÒåÖ÷ÂëµÄÓï¾ä¡£
15£®¶ÔCARD±í×öÈçÏÂÐ޸ģº
a. ½«NAME×î´óÁпíÔö¼Óµ½10¸ö×Ö·û£¨¼Ù¶¨ÔΪ6¸ö×Ö·û£©¡£
b. Ϊ¸Ã±íÔö¼Ó1ÁÐNAME£¨ÏµÃû£©£¬¿É±ä³¤£¬×î´ó20¸ö×Ö·û¡£
1. д³ö½¨Á¢BORROW±íµÄSQLÓï¾ä£¬ÒªÇó¶¨ÒåÖ÷ÂëÍêÕûÐÔÔ¼ÊøºÍÒýÓÃÍêÕûÐÔÔ¼Êø
--ʵÏÖ´úÂ룺
CREATE TABLE BORROW(
CNO int FOREIGN KEY REFERENCES CARD(CNO),
BNO int FOREIGN KEY REFERENCES BOOKS(BNO),
RDATE datetime,
PRIMARY KEY(CNO,BNO))
2. ÕÒ³ö½èÊ鳬¹ý5±
Ïà¹ØÎĵµ£º
SQL°æ£º
alter proc testguo
(
@cityid int,
@cityname nvarchar(100) output
)
as
select @cityname = city_name from BA_Hot_City where cityid = @cityid
select @cityname
go
declare @cityname nvarchar(100)
exec testguo 1,@cityname output
ÁíÒ»°æ£º
ht ......
T-SQL Script
Output format
SELECT CONVERT(VARCHAR(100), GETDATE(), 0)
03 6 2010 4:19PM
SELECT CONVERT(VARCHAR(100), GETDATE(), 1)
03/06/10
SELECT CONVERT(VARCHAR(100), GETDATE(), 2)
10.03.06
SELECT CONVERT(VARCHAR(100), GETDATE(), 3)
06/03/10
SELECT CONVERT(VA ......
sql server ÁÙʱ±íµÄʹÓà ÒÔ¼°¸øÁÙʱ±í²åÈëÖ÷¼üÁÐ
--ijʱ¼ä¶ÎÄÚij×é·þÎñÆ÷µÄÏû·ÑÅÅÐÐ
CREATE PROCEDURE biling_order_consume
@begin_date datetime,
@end_date datetime
AS
select identity(int,1,1) as ID,charge_credit into #tmp from crm_biling
where @begin_date <= convert(datetime,convert( ......
@SuppressWarnings("unchecked")
public List<ZxFunction> selectFunctionParentByUserId(final int userId) {
try {
final String sql = "select * from zx_function ......
select convert(numeric(10,4),iinvnowcost) from ...
decimal ºÍ numeric (À´Ô´sql Áª»ú´ÔÊé)
´ø¶¨µã¾«¶ÈºÍСÊýλÊýµÄ numeric Êý¾ÝÀàÐÍ¡£
decimal[(p[, s])] ºÍ numeric[(p[, s])]
¶¨µã¾«¶ÈºÍСÊýλÊý¡£Ê¹ÓÃ×î´ó¾«¶Èʱ£¬ÓÐЧֵ´Ó - 10^38 +1 µ½ 10^38 - 1¡£decimal µÄ SQL-92 ͬÒå´ÊÊÇ dec ºÍ dec(p, s)¡£
p£¨¾«¶È£© ......