retrieving out of a SQL command into variables.

• jbonapart

  SSC Rookie

  Points: 36

  More actions

  November 11, 2003 at 2:29 am

  #160910

  Hi Folks,

  How can I catch the output(columns) of the following SQL

  command in a table or each column in variables?

  RESTORE FILELISTONLY

  FROM DISK='c:\temp\FlexKIDS.bak'

  I have tried the following construction, which did NOT work:

  CREATE TABLE #LIST_FILE

  (LogicalName varchar(120),

  PhysicalName varchar(500),

  L_Type char(1),

  L_FileGROUP varchar(60),

  L_size int,

  Max_size int)

  INSERT #LIST_FILE EXEC RESTORE FILELISTONLY FROM DISK='c:\temp\FlexKIDS

• paul_richardson

  SSCarpal Tunnel

  Points: 4594

  More actions

  November 11, 2003 at 2:42 am

  #481555

  Hi,

  i use this :-

  select @load_source = "'c:\temp\FlexKIDS'"

  select @sqlstring = "RESTORE FILELISTONLY FROM DISK=" + @load_source

  insert into #list_file exec (@sqlstring)

  HTH

  Paul

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  November 11, 2003 at 7:04 am

  #481573

  
  
  INSERT #List
  
  EXEC('RESTORE FILELISTONLY FROM DISK = ''c:\temp\FlexKIDS''')

  I suggest using the bigint data type for the size columns.

  --Jonathan

  
  
  --Jonathan