Home Forums SQL Server 2005 SQL Server 2005 Compact Edition ADD A COLUMN TO A TABLE IN T-SQL RE: ADD A COLUMN TO A TABLE IN T-SQL

  • June 14, 2010 at 4:46 am

    #1179752

    Check this...

    http://msdn.microsoft.com/en-us/library/ms174123(SQL.90).aspx

    And you can use if condition in your application code. Generate data set from the query to check the column using Information_Schema and take decission at application level code.

    Stored Procedures are NOT supported in SQL Server CE.

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]