雁丘词元好问大三sql课后习题答案
第二章
3.上机练习题
02 程序代码如下：
呼兰河传读书心得STUDENT1 DATABASE CREATE ON PRIMARY
(NAME= STUDENT1_data, FILENAME='E:\DATA\',
SIZE=3,
MAXSIZE=unlimited, FILEGROWTH=15%)
LOG ON
(NAME= STUDENT1_log, FILENAME='E:\DATA\',
SIZE=2,
MAXSIZE=30, FILEGROWTH=2)
03 程序代码如下：
create databa students
on primary
(name=students1,黄师塔
filename='E:\DATA\',
size=5,
maxsize=75,
filegrowth=10%),
(name= students12,
filename='E:\DATA\',
size=10,
maxsize=75,
filegrowth=1)651错误代码连不上网
log on
(name=studentslog1, filename='E:\DATA\',
size=5,
maxsize=30,
filegrowth=1),
(name=studentslog2, filename='E:\DATA\',
,5=size
maxsize=30,
搞笑作文笑死人filegrowth=1)
第三章：
3 上机练习题
01 程序代码如下：
--创建表book的Transact-SQL语句：
USE test01
GO
CREATE TABLE book(
book_id nchar(6)NOT NULL,
book_name nchar(30 )NULL,
price numeric(10, 2)NULL,
CONSTRAINT PK_book PRIMARY KEY CLUSTERED
(
book_id ASC)
)ON PRIMARY
--创建表uthor的Transact-SQL语句：
CREATE TABLE(
anthor_name nchar(4)NOT NULL,
book_id nchar(6)NOT NULL,
address nchar(30)NOT NULL
)ON [PRIMARY]
-
-设置book中的book_id为主键，author表中的book_id为外键ALTER TABLE WITH CHECK
ADD CONSTRAINT FK_ book_author FOREIGN KEY(book_id) REFERENCES(book_id)
02 程序代码如下：
--利用Transact-SQL语句创建表booksales的代码。
菠菜怎么吃USE test01
GO
CREATE TABLE booksales(
book_id nchar(6)NOT NULL,
llnum int NOT NULL,
lldate datetime NOT NULL
)ON PRIMARY
添加数据：booksales语句为表inrt利用--
INSERT INTO booksales VALUES('m00011',7,20/12/2008)
INSERT INTO booksales(book_id,llnum,lldate)VALUES('m00017',3,17/11/2008 ) --利用update语句为表booksales更新数据：
UPDATE booksales SET llnum =11
WHERE book_id ='m00011'
--利用delete语句删除表booksales的数据：
DELETE FROM booksales
WHERE book_id ='m00011'
03 程序代码如下：
USE test01
GO
CREATE RULE llnum_rule
典韦铭文
AS@llnum >=0
EXEC sp_bindrule'llnum_rule',''
04 程序代码如下：
--删除年以前的数据
DELETE FROM booksales
WHERE lldate <'1/1/2009'
--删除所有数据
Truncate Table booksales
第四章
3 上机练习题
01 程序代码如下：
DECLARE@bookname nchar(16)
t@bookname ='SQL Server数据库编程'
02 程序代码如下：
USE test01
GO．
SET NOCOUNT ON
DECLARE @startdate datetime,@enddate datetime
SET @startdate ='1/7/2008 12:12 AM'
SET @enddate ='11/10/2009 12:00 AM'
SELECT DATEDIFF(year,@startdate,@enddate)
SELECT DATEDIFF(month,@startdate,@enddate)
SELECT DATEDIFF(day,@startdate,@enddate)
SELECT DATEDIFF(minute,@startdate,'1/8/2007 12:17 AM')
SELECT DATEDIFF(minute,@startdate,GETDATE())
SET NOCOUNT OFF
GO
03 程序代码如下：
DECLARE @count INT,@SUM INT
SET @count =51
SET @SUM=0
WHILE @count <=100
BEGIN
IF(CEILING(@count/<=FLOOR(@count/)
BEGIN
SET @SUM = @SUM + @count
END
SET @count = @count+2
END
入党发言稿PRINT'50到之间的所有能被整除的奇数之和'+CAST(@SUM AS NCHAR(4))第五章
3 上机练习题
01 程序代码如下：
