Does SQL CE support Computed Columns ?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server CE » Does SQL CE support Computed Columns ?

Does SQL CE support Computed Columns ?

Rate Topic

Display Mode

Topic Options

Author

Message

akhandels

Posted Thursday, December 30, 2010 9:02 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, August 02, 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 »

Permissions