用代码实现新建一个库或表的语句如下:
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'R&D')
DROP DATABASE [R&D]
GOCREATE DATABASE [R&D] ON (NAME = N'R&D_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\R&D_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'R&D_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\R&D_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS
GO
问题:
在删除前显示一对话框,警告将要删除数据库或表,做出确认选择,“是”则执行Drop语句,“否”则不执行,这对话是用什么命令实现的?如提示或显示可用“select”或“print”
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'R&D')
DROP DATABASE [R&D]
GOCREATE DATABASE [R&D] ON (NAME = N'R&D_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\R&D_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'R&D_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\R&D_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS
GO
问题:
在删除前显示一对话框,警告将要删除数据库或表,做出确认选择,“是”则执行Drop语句,“否”则不执行,这对话是用什么命令实现的?如提示或显示可用“select”或“print”
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'R&D')
SELECT 1 AS RESULT
ELSE
SELECT 0 AS RESULT客户端判断返回的RESULT=1,就先提示确认再执行
DROP
和
CREATE
如果返回的RESULT=0,直接执行
CREATE