--if object_id('guestbook') is null--CREATE TABLE guestbook (id int PRIMARY KEY, visitor VARCHA
--if object_id('guestbook') is null
--CREATE TABLE guestbook (id int PRIMARY KEY, visitor VARCHAR(40),comments TEXT,entrydate DATETIME)
--insert into guestbook values(3,'a','123','2016-05-12')
--insert into guestbook values(4,'a','1234','2016-05-12')
--insert into guestbook values(5,'a','12345','2016-05-12')
--if object_id('guestbook') is not null
--drop table guestbook
--if exists(select * from sysobjects where name='guestbook')
--drop table guestbook
--update guestbook set visitor='b' where id='4'
--select * from guestbook
--delete guestbook where id='3'
--truncate table guestbook
--结束END--
本文标题: SQL -- 简单语句学习总结7条
本文链接: https://www.lsjlt.com/news/45004.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0