Home > Archive > MS SQLCE > October 2005 > Create view









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Create view
Javier Gutiérrez

2005-10-27, 7:52 am

I want to create a view in SQL Server CE, I write the following: create view
vw_test as select field_1 from table_1

I receive the following error: DB_E_ERRORSINCOMMAND


Sql server CE supports views?

Thanks!


marciocamurati

2005-10-27, 7:52 am

Javier,

SQL Server CE don't support views or procedures, only T-SQL commands at
the application to make the queries.

[]s

Marcio Camurati

Javier Gutiérrez

2005-10-27, 7:52 am

Sql server 2005 mobile edition supports views?

Thanks!

"marciocamurati" <marcio.camurati@gmail.com> escribió en el mensaje
news:1129662470.982449.268800@f14g2000cwb.googlegroups.com...
> Javier,
>
> SQL Server CE don't support views or procedures, only T-SQL commands at
> the application to make the queries.
>
> []s
>
> Marcio Camurati
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com