Ho all SQL gurus, I've searched for samples on how to automatically
scripting SQL2000 tables to export data between databases via a sql
script. (somehing like:
INSERT INTO [ges1gara].[dbo].[CategAtleti]([CodCat], [Denominazione],
[LimiteBassoDonne], [LimiteBasso], [LimiteAltoDonne], [LimiteAlto])
VALUES(<CodCat,smallint,3>,
<Denominazione,varchar(50),"Maschietti/Bambine">,
<LimiteBassoDonne,smallint,6>, <LimiteBasso,smallint,6>,
<LimiteAltoDonne,smallint,6>, <LimiteAlto,smallint,6>)
INSERT INTO [ges1gara].[dbo].[CategAtleti]([CodCat], [Denominazione],
[LimiteBassoDonne], [LimiteBasso], [LimiteAltoDonne], [LimiteAlto])
VALUES(<CodCat,smallint,4>,
<Denominazione,varchar(50),"Giovanissimi/Giovanissime">,
<LimiteBassoDonne,smallint,7>, <LimiteBasso,smallint,7>,
<LimiteAltoDonne,smallint,7>, <LimiteAlto,smallint,7>)
)
Can you pls.point me to the right direction? TIA
from tesis-Italy
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! 4 1879
"Saverio Tedeschi" <te***@tesis.org> wrote in message
news:40*********************@news.frii.net... Ho all SQL gurus, I've searched for samples on how to automatically scripting SQL2000 tables to export data between databases via a sql script. (somehing like: INSERT INTO [ges1gara].[dbo].[CategAtleti]([CodCat], [Denominazione], [LimiteBassoDonne], [LimiteBasso], [LimiteAltoDonne], [LimiteAlto]) VALUES(<CodCat,smallint,3>, <Denominazione,varchar(50),"Maschietti/Bambine">, <LimiteBassoDonne,smallint,6>, <LimiteBasso,smallint,6>, <LimiteAltoDonne,smallint,6>, <LimiteAlto,smallint,6>) INSERT INTO [ges1gara].[dbo].[CategAtleti]([CodCat], [Denominazione], [LimiteBassoDonne], [LimiteBasso], [LimiteAltoDonne], [LimiteAlto]) VALUES(<CodCat,smallint,4>, <Denominazione,varchar(50),"Giovanissimi/Giovanissime">, <LimiteBassoDonne,smallint,7>, <LimiteBasso,smallint,7>, <LimiteAltoDonne,smallint,7>, <LimiteAlto,smallint,7>) ) Can you pls.point me to the right direction? TIA
from tesis-Italy
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! http://vyaskn.tripod.com/code.htm#inserts http://www.rac4sql.net/objectscriptr_main.asp
Simon
"Saverio Tedeschi" <te***@tesis.org> wrote in message
news:40*********************@news.frii.net... Ho all SQL gurus, I've searched for samples on how to automatically scripting SQL2000 tables to export data between databases via a sql script. (somehing like: INSERT INTO [ges1gara].[dbo].[CategAtleti]([CodCat], [Denominazione], [LimiteBassoDonne], [LimiteBasso], [LimiteAltoDonne], [LimiteAlto]) VALUES(<CodCat,smallint,3>, <Denominazione,varchar(50),"Maschietti/Bambine">, <LimiteBassoDonne,smallint,6>, <LimiteBasso,smallint,6>, <LimiteAltoDonne,smallint,6>, <LimiteAlto,smallint,6>) INSERT INTO [ges1gara].[dbo].[CategAtleti]([CodCat], [Denominazione], [LimiteBassoDonne], [LimiteBasso], [LimiteAltoDonne], [LimiteAlto]) VALUES(<CodCat,smallint,4>, <Denominazione,varchar(50),"Giovanissimi/Giovanissime">, <LimiteBassoDonne,smallint,7>, <LimiteBasso,smallint,7>, <LimiteAltoDonne,smallint,7>, <LimiteAlto,smallint,7>) ) Can you pls.point me to the right direction? TIA
from tesis-Italy
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! http://vyaskn.tripod.com/code.htm#inserts http://www.rac4sql.net/objectscriptr_main.asp
Simon
Hi Simon,
Thank you very much for your reply; that's all I need!
from tesis-Italy
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Hi Simon,
Thank you very much for your reply; that's all I need!
from tesis-Italy
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Rodd Snook |
last post by:
I have an application which makes extensive use of the
Scripting.Dictionary object. I'm not doing anything silly like putting
them outside the page scope -- just creating quite a few of them and...
|
by: Saverio Tedeschi |
last post by:
Ho all SQL gurus, I've searched for samples on how to automatically
scripting SQL2000 tables to export data between databases via a sql
script. (somehing like:
INSERT INTO ..(, ,
, , , )...
|
by: Robin Tucker |
last post by:
Hi there,
Getting ready for deployment and I would like to be able to run an install
script that will not just generate the schema, but fill in some of the
tables with default data. Is there a...
|
by: Wolfgang Keller |
last post by:
Hello,
I'm looking for a spreadsheet application (MacOS X prefered, but
Windows, Linux ar available as well) with support for Python scripting
(third-party "plug-ins" are ok) and a database...
|
by: Scott M. |
last post by:
How can I disable the cross-site scripting check for one particular page of
a site?
| |
by: Ryan |
last post by:
Is there an easy way to script the tables from within a database to
include the indexes etc...
Basically, if I want to script a number of tables, I can right hand
click on them and generate the...
|
by: nonsensitor |
last post by:
I would like to greate groups of collapsible (and expandable) rows in a data table. I understand this should be achievable with tbody and visibility: collapse?
The bit of reading I've done so far...
|
by: farseer |
last post by:
Hi,
I need to take data from a SQL Serer 2005 database, and load into a
remote 2000 database. I've already been able to script and create the
database objects (MS SQL Server 2005 has a nifty...
|
by: Banfa |
last post by:
The project I work on has a bespoke hardware platform which is designed to go into a variety of different situations. However to keep things simple we really want the software for the platform to...
|
by: Jeff |
last post by:
hi
asp.net 2.0
sql server 2005 (I'm using that Express version)
I have a asp.net project here which I'm wondering how to deploy the database
of. Right now I locally created a database and...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |