[SQL Server] 123456
运用SQL语言实现的沙发客数据库系统，包含文档和sql源代码
Use the SQL language of the realization of the sofa guest database system, including documents and SQL source code
(2012-07-16, SQL, 80KB, 下载3次)
[SQL Server] Transact-SQL
Teaching e-book
Transact-SQL 對使用 Microsoft® SQL Server™ 非常重要。與 SQL Server 通訊的所有應用程序都通過向服務器發送 Transact-SQL 語句來進行通訊
Teaching e-book
Transact-SQL Microsoft ® SQL Server ™ is very important. All applications to communicate with SQL Server through Transact-SQL statements to the server to send communications (2012-05-05, SQL, 1068KB, 下载2次)
[SQL Server] twitter
twitter可以看成是一种微博客，其基本结构由发布者和跟随者组成。设计如下表格：
user(uid, uname, rank), 初始时rank＝0； follow(idol, fan), 表示fan跟随了idol；message(msg_id, uid, msg_content)，存储所有发布的消息，uid是消息发布者的标识。
使用触发器完成如下功能：当往message表中插入新消息后，检索follow表，把该消息发送给它的生成者的fans，当然只要显示“***收到了****消息”即可。
同时使用触发器维护user表中的rank，rank＝（用户发布的消息数*该用户的fans数量）/100，当然你可以给出更精确的定义。
twitter can be seen as a micro blog, its basic structure from the publisher and the composition of the follower. Design the form as follows:
user (uid, uname, rank), initially rank = 0 follow (idol, fan), said the fan following of the idol message (msg_id, uid, msg_content), store all the news published, uid is the message publisher identity.
Use the trigger to complete the following functions: When the message table to insert new messages, the search follow the table, to the message sent to it the formation of those fans, of course, as long as the display "******* received the message" can .
Also use triggers to maintain user in the table rank, rank = (number of users to publish news of the fans* The number of users)/100, of course, you can give a more precise definition. (2010-06-13, SQL, 1KB, 下载26次)
[SQL Server] PcCode_200885212847484
奔票面厅局级老一辈[这夺喹 大无畏 厅天地
Towards the older generation of the department or bureau level par [This dauntless Office quinoline world away (2009-03-29, SQL, 63KB, 下载2次)
[SQL Server] cfxt
pb与sql2000 咖啡厅管理
coffee house management of pb and sql2000 (2004-08-26, SQL, 1920KB, 下载30次)