Create a database with dynamic name by using storedproceure

Question

How can create a database using stored procedure but the database name is passed as parameter or how can i create a database with dynamic name

jayakrishnan Morayur · Answer

CREATE PROCEDURE CreateDB -- Add the parameters for the stored procedure here @DBName varchar(max) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; Declare @dbString varchar(max) set @dbString = 'CREATE DATABASE ' + @DBName exec(@dbString) END GO