Hi to all
I am working with Sql server ce for mobile application with vb.net.
I want to crete a table before that i have to check weather the table exists or not.
Also want to know about Object id in sql server and how to create it.
Thanks and Regards
Sugan
suganzeni
0
Newbie Poster
Recommended Answers
Jump to PostYou could do that with sql:
CREATE TABLE IF NOT EXISTS foo (bar int)
This creates a table foo, only if it hasn't been created before.
Jump to Postreplace the 'ntext' with 'text' in your SQL-query.
and I think you meant 'starttime datetime' instead of 'starttime ntext'
All 8 Replies
Nick Evan
4,005
Industrious Poster
Team Colleague
Featured Poster
suganzeni
0
Newbie Poster
Nick Evan
4,005
Industrious Poster
Team Colleague
Featured Poster
suganzeni
0
Newbie Poster
Nick Evan
4,005
Industrious Poster
Team Colleague
Featured Poster
suganzeni
0
Newbie Poster
AaronASterling
0
Light Poster
vinu_32123
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.