Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Does SQL CE support Computed Columns ? Expand / Collapse
Author
Message
Posted Thursday, December 30, 2010 9:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 2, 2011 2:56 PM
Points: 23, Visits: 117
Hi All,
I am trying to add a computed column in SQL CE table. SQL Query for the same change in SQL Server 2008 is like this:

ALTER TABLE table_name
ADD [hash_c2] AS (CONVERT([binary (20),hashbytes('sha1',TEST_CONDITION),0))

Is there a way to add a computed column like this in SQL CE?

Thank You.
Post #1040965
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse