如何将db-Name传递给存储过程 [英] How to pass a db-Name to a stored procedure

问题描述

大家好，
我想知道，要将db-Name传递给存储过程

编辑
我的代码就像

Hi all,
I''d like to know, to pass a db-Name to a stored procedure

EDIT
my code is like

USE [master];
GO
 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
 
CREATE PROCEDURE [dbo].[usp_BACKUP_DB]
(
@DB_Name	VARCHAR(50),	-- Provide the DB''s Name, whitch is to Back Up
@Drive	 VARCHAR(1)	-- Provide a Drive-Letter, e.g. C
)
 
AS
 
SET NOCOUNT ON 
 
IF (NOT @DB_Name IS NULL) AND (NOT @Drive IS NULL)
 
SET @_DB_Name = RTRIM(LTRIM(@DB_Name))
SET @_Drive = UPPER(RTRIM(LTRIM(@Drive)))
 
ALTER DATABASE @DB_Name
SET RECOVERY FULL;	 -- SET Recovery-Mode to FULL
GO

但是SQL Server不接受@DB_Name和@Drive:
消息102，级别15，状态1，过程usp_BACKUP_DB，第20行
``@DB_Name''附近的语法不正确...

But @DB_Name and @Drive are not accepted by SQL Server:
Msg 102, Level 15, State 1, Procedure usp_BACKUP_DB, Line 20
Incorrect syntax near ''@DB_Name''...

推荐答案

作为字符串.

As a string.

一些可以帮助您的示例-
http://forums.databasejournal.com/showthread.php?t=36588 [ ^ ]
http://itknowledgeexchange.techtarget.com/itanswers/passing -a-database-name-as-a-stored-procedure-parameter/ [

Some examples that could help you -
http://forums.databasejournal.com/showthread.php?t=36588[^]
http://itknowledgeexchange.techtarget.com/itanswers/passing-a-database-name-as-a-stored-procedure-parameter/[^]

这篇关于如何将db-Name传递给存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！