Looking a function to declare a table variable

• adonetok

  SSCrazy Eights

  Points: 8395

  More actions

  May 18, 2010 at 7:20 am

  #219023

  I need to declare a table variable from another existing table.

  If I use "Script table as" will create table variable with [], like

  CREATE TABLE [dbo].[CLAIM](

  [CLAIMNO] [varchar](20) NOT NULL,

  [ACCT] [varchar](4) NOT NULL,

  ....

  Is there a function can return script without [ ]?

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  May 18, 2010 at 8:18 am

  #1168843

  Why are you concerned about the [] this works:

  DECLARE @CLAIM table(

  [CLAIMNO] [varchar](20) NOT NULL,

  [ACCT] [varchar](4) NOT NULL)

  INSERT INTO @CLAIM

  SELECT 1, 'Did' UNION ALL

  SELECT 2, 'Doit'

  SELECT * FROM @CLAIM

  /* Results:

  CLAIMNOACCT

  1Did

  2Doit

  */

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]