VarChar(max)?!?

• Linson.Daniel

  Ten Centuries

  Points: 1153

  More actions

  August 18, 2008 at 12:36 am

  #859273

  A real good explanation by Simon....Im quiet clear on this one..Thanks Simon:)

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  September 15, 2008 at 6:17 am

  #871687

  --Step 1

  Declare @STR VarChar(max);

  Set @STR=Replicate(cast('*'as varchar(MAX)) ,10000)

  Print Len(@Str);

  --Step 2

  Declare @STR VarChar(max);

  Set @STR=Replicate('*' ,10000)

  Print Len(@Str);

  ----

  i m hardly got the difference between step 1 and step 2 ..please explain both ????

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  July 10, 2009 at 1:04 pm

  #1023285

  nice to have a clear explanation.

  Good question

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events