存储过程的问题

2011-04-24 04:08:24 137 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

.NET MAUI跨平台串口通讯方案 MAUI跨平台串口通信架构设计采用分层模式，核心是共享业务逻辑层与平台特定实现。通过定义统一的ISerialPortService接口，实现了Windows、Android、iOS和macOS四大平台的串口通信功能。Windows平台使用System.IO.Ports类库，Android通过USB Host模式实现，iOS基于ExternalAccessory框架，macOS则采用IOKit。该设计支持串口连接管理、数据收发等核心功能，并通过事件机制实现异步通信。架构采用条件编译区分各平台实现，确保代码复用阅读详情

我想写一个存储过程，功能：创建一个数据库输入参数：数据库名

以下是代码：
运行后提示
消息 102，级别 15，状态 1，过程 createDB，第 24 行
'\' 附近有语法错误。
请问该怎么解决，谢谢了啊



CREATE PROCEDURE createDB 

	-- Add the parameters for the stored procedure here

	@name varchar(20) = 'test'

	--<@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>, 

	--<@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0>

AS

BEGIN

	-- SET NOCOUNT ON added to prevent extra result sets from

	-- interfering with SELECT statements.

	SET NOCOUNT ON;

    -- Insert statements for procedure here

	IF @name IS NULL

		RETURN 1

	ELSE

		IF exists (SELECT * FROM sys.databases WHERE name = @name) 

			Exec ( 'drop database' + @name )

		DECLARE   @s   varchar(1000)

		set   @s   =   ' 

			CREATE DATABASE School

			ON

			(

				NAME = @DBname,

				FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\' + @DBname + '.mdf',

				SIZE = 10,

				MAXSIZE = 50,

				FILEGROWTH = 5

			)

			LOG ON

			(

				NAME = @DBname + 'Log',

				FILENAME = "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\'+@DBname+'Log.ldf",

				SIZE = 5MB,

				MAXSIZE = 25MB,

				FILEGROWTH = 5MB

			)

		'

		EXEC  @s

END

GO

...全文

用ESP32和HomeSpan自制HomeKit智能灯，手把手教你从零接入苹果家庭App 本文详细介绍了如何使用ESP32开发板和HomeSpan开源库自制原生HomeKit智能灯，从硬件搭建到软件配置，再到通过苹果家庭App控制的全过程。项目绕过了苹果MFi认证，成本低廉但功能完整，支持Siri语音控制、自动化场景等高级功能，是智能家居DIY的实用指南。阅读详情

ogiso_pest

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

ogiso_pest 2011-04-24

打赏
举报

运行后没有创建数据库啊

--小F-- 2011-04-24

打赏
举报



CREATE PROCEDURE createDB 

    -- Add the parameters for the stored procedure here

    @DBname varchar(20) = 'test'

    --<@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>, 

AS

BEGIN

    -- SET NOCOUNT ON added to prevent extra result sets from

    -- interfering with SELECT statements.

    SET NOCOUNT ON;

    -- Insert statements for procedure here

    

    IF exists (SELECT * FROM sys.databases WHERE name = @DBname) 

        Exec ( 'drop database' + @DBname )

    DECLARE   @s   varchar(1000)

    set   @s   =   ' 

        CREATE DATABASE School

        ON

        (

            NAME = @DBname,

            FILENAME = ''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\'' + @DBname + ''.mdf'',

            SIZE = 10,

            MAXSIZE = 50,

            FILEGROWTH = 5

        )

        LOG ON

        (

            NAME = @DBname + ''Log'',

            FILENAME = ''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\'' + @DBname + ''Log.ldf'',

            SIZE = 5MB,

            MAXSIZE = 25MB,

            FILEGROWTH = 5MB

        )

    '

    EXEC  @s

END

GO





DROP PROCEDURE createDB

go

ogiso_pest 2011-04-24

打赏
举报



DROP PROCEDURE createDB



CREATE PROCEDURE createDB 

	-- Add the parameters for the stored procedure here

	@DBname varchar(20) = 'test'

	--<@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>, 

AS

BEGIN

	-- SET NOCOUNT ON added to prevent extra result sets from

	-- interfering with SELECT statements.

	SET NOCOUNT ON;

    -- Insert statements for procedure here

	

	IF exists (SELECT * FROM sys.databases WHERE name = @DBname) 

		Exec ( 'drop database' + @DBname )

	DECLARE   @s   varchar(1000)

	set   @s   =   ' 

		CREATE DATABASE School

		ON

		(

			NAME = @DBname,

			FILENAME = ''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\'' + @DBname + ''.mdf'',

			SIZE = 10,

			MAXSIZE = 50,

			FILEGROWTH = 5

		)

		LOG ON

		(

			NAME = @DBname + ''Log'',

			FILENAME = ''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\'' + @DBname + ''Log.ldf'',

			SIZE = 5MB,

			MAXSIZE = 25MB,

			FILEGROWTH = 5MB

		)

	'

	EXEC  @s

END

GO

出现了消息 111，级别 15，状态 1，过程 createDB，第 15 行
'CREATE/ALTER PROCEDURE' 必须是查询批次中的第一个语句。

ogiso_pest 2011-04-24

打赏
举报

经典了下

DROP PROCEDURE createDB

CREATE PROCEDURE createDB
-- Add the parameters for the stored procedure here
@DBname varchar(20) = 'test'
--<@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>,
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here

IF exists (SELECT * FROM sys.databases WHERE name = @DBname)
Exec ( 'drop database' + @DBname )
DECLARE @s varchar(1000)
set @s = '
CREATE DATABASE School
ON
(
NAME = @DBname,
FILENAME = ''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\'' + @DBname + ''.mdf'',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5
)
LOG ON
(
NAME = @DBname + ''Log'',
FILENAME = ''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\'' + @DBname + ''Log.ldf'',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB
)
'
EXEC @s
END
GO

ogiso_pest 2011-04-24

打赏
举报

这个问题
消息 2714，级别 16，状态 3，过程 createDB，第 38 行
数据库中已存在名为 'createDB' 的对象。



CREATE PROCEDURE createDB 

	-- Add the parameters for the stored procedure here

	@DBname varchar(20) = 'test'

	--<@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>, 

	--<@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0>

AS

BEGIN

	-- SET NOCOUNT ON added to prevent extra result sets from

	-- interfering with SELECT statements.

	SET NOCOUNT ON;

    -- Insert statements for procedure here

	IF @DBname IS NULL

		RETURN 1

	ELSE

		IF exists (SELECT * FROM sys.databases WHERE name = @DBname) 

			Exec ( 'drop database' + @DBname )

		DECLARE   @s   varchar(1000)

		set   @s   =   ' 

			CREATE DATABASE School

			ON

			(

				NAME = @DBname,

				FILENAME = ''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\'' + @DBname + ''.mdf'',

				SIZE = 10,

				MAXSIZE = 50,

				FILEGROWTH = 5

			)

			LOG ON

			(

				NAME = @DBname + ''Log'',

				FILENAME = ''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\'' + @DBname + ''Log.ldf'',

				SIZE = 5MB,

				MAXSIZE = 25MB,

				FILEGROWTH = 5MB

			)

		'

		EXEC  @s

END

GO

rucypli 2011-04-24

打赏
举报

FILENAME = ''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\'''

存储过程的问题

相关推荐