Change Column datatype

• Devendra Thakur

  SSCommitted

  Points: 1762

  More actions

  April 11, 2017 at 1:04 pm

  #342425

  Comments posted to this topic are about the item Change Column datatype

• sqlfriend

  SSC Guru

  Points: 52733

  More actions

  April 24, 2017 at 9:59 am

  #1939584

  Thanks for the nice script.

  One question, about the select top 1, is there a reason to use top 1 instead of just select?

  Thanks

• Devendra Thakur

  SSCommitted

  Points: 1762

  More actions

  April 24, 2017 at 7:43 pm

  #1939694

  sqlfriends - Monday, April 24, 2017 9:59 AM

  Thanks for the nice script.

  One question, about the select top 1, is there a reason to use top 1 instead of just select?

  Thanks

  Thanks, it is not important. I am using it just to double check we get one and only one value.

• adelio.stevanato 21159

  SSC Enthusiast

  Points: 194

  More actions

  April 26, 2017 at 2:48 am

  #1939884

  You have missed out specifying/using the table schema as well as the table name.