开发者

storing a Book using SQL Server

开发者 https://www.devze.com 2023-02-13 13:30 出处:网络
Hi and thank you for your attention I\'m working on a database system project and i must implement a digital library using SQL Server.

Hi and thank you for your attention

I'm working on a database system project and i must implement a digital library using SQL Server.

I dont know how can i store a book with 1000 pages (page by page and with serching ability) in SQL Server

I was thinking about creating a table with 1000 columns with ntext type,but i think it isn't really a wise way.

could anyone help me with a suitable method for this problem.

I also going to store multipage image books and voice books

thank you开发者_C百科.


1000 columns? No rather a 1000 rows in a table such as:

Table BookPage:
   BookId int
   PageId int
   PageText ntext

You could then have another table for the book:

Table Book:
   BookId int
   Title nvarchar
   Author nvarchar
0

精彩评论

暂无评论...
验证码 换一张
取 消