Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bringing some table int osql express with data
Message
 
To
09/05/2014 07:22:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 8.1
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01599776
Message ID:
01599781
Views:
43
>i have a dbc and want to export a few tables into sqlserver express with the data attached.
>in vfp the PK was handled by an insert trigger in SQL i want to use the auto-incrementing feature
>can that be done and if yes HOW?
>
>Next I need to create an access front end. possible??
>
>thanks
>
>Peter


SET IDENTITY_INSERT TableName ON
insert rows
SET IDENTITY_INSERT TableName OFF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform