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 1878
"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: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
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,...
| |