Home Forums Article Discussions Article Discussions by Author Discuss content posted by Deepthi Viswanathan Nair Dynamic creation of Insert, Update, Delete Stored procedure RE: Dynamic creation of Insert, Update, Delete Stored procedure

  • July 15, 2010 at 7:10 am

    #1193455

    to check your decimal(p,s) you can do this :

    CaseWhen systypes.xusertype =106 Then '(' + Convert(varchar(10),syscolumns.xprec) +','+Convert(varchar(10),syscolumns.xscale)+')'