數(shù)據(jù)庫(kù)我的租房網(wǎng)-預(yù)覽頁(yè)
【正文】 INSERT INTO copy(copy) VALUES(39。) INSERT INTO copy(copy) VALUES(39。) INSERT INTO copy(copy) VALUES(39。)DECLARE userid INTDECLARE streetid INTDECLARE htid INTDECLARE price DECIMALDECLARE htime DATETIMEDECLARE topic VARCHAR(50)DECLARE contents VARCHAR(50)DECLARE copy VARCHAR(50)DECLARE num INTBEGIN TRANSACTIONSET num = 0WHILE num30BEGIN SET userid=(SELECT TOP 1 UserId FROM sys_user ORDER BY NEWID())SET streetid=(SELECT TOP 1 streetid FROM hos_street ORDER BY NEWID()) SET htid=(SELECT TOP 1 htid FROM hos_type ORDER BY NEWID()) 租金在4000之間隨機(jī)產(chǎn)生SET price=1000+CAST(3000*RAND() AS INT)發(fā)布時(shí)間htime，要求小于當(dāng)前系統(tǒng)時(shí)間，發(fā)布時(shí)間在當(dāng)前系統(tǒng)時(shí)間一年內(nèi)SET htime=CAST(DATEADD(DAY,CAST(RAND()*DATEPART(DAYOFYEAR,GETDATE()) AS INT),GETDATE()) AS DATE)SET topic=(SELECT TOP 1 topic FROM topic ORDER BY NEWID())PRINT topicSET contents=(SELECT TOP 1 content FROM content ORDER BY NEWID())SET copy=(SELECT TOP 1 copy FROM copy ORDER BY NEWID())INSERT INTO hos_house(UserId,StreetId,HTId,Price,Topic,Contents,HTime,Copy) VALUES(userid,streetid,htid,price,topic,contents,htime,copy)SET num=num+1END COMMIT TRANSACTION實(shí)訓(xùn)三：綜合查詢(xún)(1) 分頁(yè)顯示查詢(xún)出租房屋信息查詢(xún)輸出第610條出租房屋信息：216。 使用內(nèi)聯(lián)接inner join查詢(xún)和子查詢(xún)實(shí)現(xiàn)。街道39。標(biāo)題39。房源描述39。備注39。 使用where子句和內(nèi)查詢(xún)實(shí)現(xiàn)。街道39。標(biāo)題39。房源描述39。備注39。戶(hù)型39。區(qū)縣39。季度39。街道39。數(shù)量39。39。
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1