How to drop database table if it exits in sql mobile version?

Hi,

I am using VB.net and Visual Studio 2005 to compile a program for a Pocket PC with Microsoft? Windows Mobile? 2003 Second Edition. I am using sql mobile also.

What I want to complete is like one of the following two queries. But when I tried them in the sql mobile, errors happened. So how can I complete the same function in sql Mobile? Thanks.

USE DBa

if exists (select * from dbo.sysobjects

where id = object_id(N'[dbo].[Table_a]')

and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop Table Table_a

or

USE DBa

IF OBJECT_ID('dbo.Table_a) IS NOT NULL

DROP TABLE dbo.Table_a

You should issue a query to check if table exists and if it does issue another query to delete it.

Please see SQL CE/Mobile books online for queries (hint: look for Information_Schema.Tables and Drop Table).

|||Thanks a lot, and your suggestion is great

How to Download trial version

Hi Everybody,

Anybody know is there any place to download trial version of the Microsoft SQL

server 2000 Report service ?

Because i have already installed the sql server 2000 but in that CD i could find out

the Report service ! so how do i install the Report Service ?

do i have to buy the SQL Server report service 2000 separately ?

any idea ? its realy help me if i can download the trial software for practice my own

withing a small period !

regards

sujithf

Did you mean the 2005 version, if so, it comes with SQL Server 2005 and all you need to do is go to Control Panel, add/remove programs and select Add components from the setup wizard. Don't remember how it worked with 2000, but it may have been a separate download.

BTW, you want to get 2005, it has lots of improvements.

How to download the english version of SQL Sever Express?

Hello,

when i try to download SQL Server Express from

http://msdn.microsoft.com/vstudio/express/sql/download/

i only get the german version. But i want to download the original english version. Because i like more to work with the english terms than the translated german ones.

Regards,

Markus

Visit this page, select English then click Change, scroll-down to the Files in This Download then click the third download-button.
Hope this helps you.
|||

Thank you. I want to download the SQL Server 2005 Express Edition with Advanced Services SP1.

Like on this page:

http://msdn.microsoft.com/vstudio/express/sql/download/

But in English, not in German. I'ts not helpful for me to work with an german version and read the english documentation.

The subset of english microsoft uses is so good and understandable that in my opinion german versions of development tools are obsolete. When all use the english version, all use the same terms.

Markus

|||Okay, take a look at this page...|||

For those of you wondering, the MSDN download page is language sensitive and automatically downloads the language version of Express based on your Browser settings, assuming we release a version in that language. For cases where you want a language other than the one your Browser is set to, you can get those languages directly from the Microsoft Download Center as described above.

I will be updating the MSDN download page in the near future to contain this information so that you will be able to get to the correct download center page for alternate language downloads directly from MSDN.

Regards,

Mike Wachal
SQL Express team

Mark the best posts as Answers!

|||

Thank you, Moayad for the link to the original version!

Mike wrote:
> I will be updating the MSDN download page in the near future to
> contain this information so that you will be able to get to the
> correct download center page for alternate language downloads
> directly from MSDN.

thank you very much!

How to download SQL 2005 Express - English version?

I try to download SQL Express but in result get a Russion version . How I could to download English version?

It is good to do to user could make choice: which version he wants .

try to down load from this link : http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

Madhu