Change Column datatype

  • Devendra Thakur

    SSCommitted

    Points: 1762

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

  • sqlfriend

    SSC Guru

    Points: 52347

    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

    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: 176

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

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply