1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

SP to alter all tables in db whos datatype is FLOAT

Discussion in 'SQL - Questions and Answers' started by swapnil, Jan 8, 2008.

  1. swapnil New Member

    can any one will help me ?????????????????

    i am using SQL server 2000.
    i want to convert a cloumn with FLOAT type to NUMERIC and having SCALE 2
    their r more than 370 tables and about 200 tables contains such columns .
    so i want a SP which will do this .

    swapnilnaikshelar@gmail.com
    swapnil, Jan 8, 2008
    #1

Share This Page