Insert date modified column

• Phil Parkin

  SSC Guru

  Points: 247183

  More actions

  September 26, 2019 at 6:50 pm

  #3683749

  Can you please try explaining this again, because I don't understand what the problem is.

  Note that @declare table is not valid T-SQL syntax – what do you really mean?

  Can you provide some sample code? It might make things clearer.

  ---

• ng_rai

  SSC Enthusiast

  Points: 189

  More actions

  September 26, 2019 at 6:55 pm

  #3683751

  declare @abc varchar(50)

  set @abc = 'Accesstest.dbo.[ Historical Data_' + (select cast(year(getdate()) - 2 as varchar(4))) + ']'

  declare @query varchar(max)

  set @query = '

  if object_id(''AccessTest.dbo.ABC'') is not null drop table AccessTest.dbo.ABC

  select

  [Company Number]

  ,[Company Name]

  ,[Total Equity] as TotalEquity_ABC

  ,[Net Income] as NetIncome_ABC

  Exec @Query

   

  I want to add datecreated/datemodified in "AccessTest.dbo.ABC". Hope this is helpful.

• Sean Lange

  SSC Guru

  Points: 286609

  More actions

  September 27, 2019 at 4:58 pm

  #3684105

  Why all the dynamic sql? It is not only not needed but seems to have nothing at all to do with what you are describing you want to. If you want to add a new column to a table the right way is to use the ALTER TABLE statement, not drop the table.

  Something like this.

  alter table AccessTest.dbo.ABC
  add DateCreate datetime

  My concern though is that you may have tables with dates in the name. This is a terrible design approach as that kind of information should be a column in a single table.

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/