MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

ESSENTIALS: Home | Tips | Search | Categories | Top 10 | Products | Authors | Blogs | Forums | Webcasts | Advertise | About
col name from parameter -

in Search

col name from parameter

Last post 06-05-2008 2:48 PM by MohammedU. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 05-29-2008 9:03 AM

    col name from parameter

    How can i access col name from parameter?

    CREATE PROCEDURE [dbo].[r_CreateCol]

    @col nvarchar(100)
    AS
    ALTER TABLE Summary
    ADD @col  nvarchar(100);
    GO

  • 05-29-2008 9:32 AM In reply to

    • aprato
    • Top 10 Contributor
    • Joined on 12-01-2007
    • Greater Boston
    • Posts 153

    Re: col name from parameter

     In this case, you'd need dynamic sql

    CREATE PROCEDURE [dbo].[r_CreateCol]

    @col nvarchar(255)
    AS

    declare @sql nvarchar(1000)
    select @sql = 'ALTER TABLE dbo.Summary ADD ' + @col + ' nvarchar(100)'

    exec sp_executesql @sql

    GO
     
    exec r_CreateCol 'newcol'
    go

    sp_help Summary
    go
     

  • 06-05-2008 2:48 PM In reply to

    Re: col name from parameter

    What are you benifitting from this proc...

    MohammedU
    SQL Server MVP
Page 1 of 1 (3 items)