calling a sql script from another sql script
Hi, does anyone know how to call a sql script (Note: not a stored
another sql script in sybase? In oracle, you just put @ before the
I haven't been able to find out how to do it in sybase. Any help will be
Yilin Cai wrote:
> Hi, does anyone know how to call a sql script (Note: not a stored
> procedure) from
> another sql script in sybase? In oracle, you just put @ before the
> script name.
> I haven't been able to find out how to do it in sybase. Any help will be
> app...Syntax to call a t-sql script from another t-sql script
I need to know how to call a t-sql script from another t-sql script.
In Oracle I can add a line: @tce_load_company.sql to a sql command file, and it
will run that file. This allows me to have a single "master" file that has all
of my lower level table initialization values. What is the syntax for doing this
"Christopher A. Emerson" wrote:
> I need to know how to call a t-sql script from another t-sql script.
> In Oracle I can add a line: @tce_load_company.sql to a sql command file, and it
> will r...GENERAL SQL SERVER: Question about the Script that setups the SQL Server Database.
This is the first time I have created a script for Sql Server 2000, and I have run into a few syntax ereas that I am not familar with. Bellow is a section of the script from the Portal server packages. At the end of the sample, is "ON [PRIMARY], Can anyone explain to me what this does and why the primary key isnt setup inside the code itself? I am basically trying to take parts of the script and incorrporate it into my own script and hate added syntax that I dont understand, makes debugging a real pain in the future.
CREATE TABLE [dbo].[Portal_Announcements] (
[ItemID] [in...How To Import Records From One SQL Tbl To Another SQL Tbl In Same DB
I need to import records from one SQL table to another SQL table. Both tables are in the same database. Does anyone know how?
Well, you could use DTS, or you could use an INSERT queryINSERT INTO newTable (column1, column2, column3...) SELECT column1, column2, column3... FROM oldTable
TerriTerri MortonEngagement Manager, NeudesicHow to ask a question
I tried using DTS and got confused. I got the query to work.
Tina...Importing SQL script to the server database using SQL Management Studio
How do i import an sql script to the server using sql management studio?
Can someone advise?
I'm not sure I understand your question. Are you trying to create a stored procedure?Please mark the post(s) that have helped you as "Answer"I'm better at brewing beer than crafting code but I have to do the latter to do the former. Will code for malt.
Do you want to open and execute the “.sql” file in SQL Server Management Studio?If I have misunderstood, please let me know.
In the SQL Server Management Studio, click File -> Open -> File…, choose the “.sql” fi...How can i import records from a sql server table in project1 to another sql server table in project2
Hi, i have a table with all employee bio-data in a completed project. Iam now working on another project with a table that needs the same data and here iam talking about 300 records that rarely change. Instead of re-entering this data in this new table, i want to import the data from the completed project into a table in this new project. Does any one have any idea how to achieve that or is there a better option to do the same.
One more thing iam realising here is that iam going to use this same data in very many applications and some one from one department is going to ...Another SQL script question.
How do i make sure that the local machine aspnet user account has privilages after installing my sql script on a local machine. ( this script gets run during my vb.net setup project. )
i was thinking about adding the user to the sql script its self. but i am unsure how to do this.
if anyone could help i would be greatly appreciative.
-Chris-I am one of those!
Check out this link.
The link is for MSDE but applies to Sql Server too. It shows the syntax for adding new users to a database server and granting them access to specific databases.
Thanks for you rep...Import into PDM model from sql script
I am trying to import a new table into my .pdm model from a SQL script. I
got the impression that I could use reverse engineering from script in PD8
to do this. When doing so I can see that something is going on and PD8
finally tells me that the reverse engineering was a succes - but I cant see
anything in the model diagram.
What do I do wrong ?
Any suggestion will be appreciated.
First, there are 2 ways to reverse engineer (RE). One is from File->Reverse
Engineer. This will create a new model.
The other is from Database->Reverse E...Importing a script into SQL Server Express
I am having trouble importing a database script into SQL Server Express. The script is from the Web Applications book from the Microsoft MCSD exams. My installation of SQL Server Express appears to be fine as I can login and create/delete databases through it. When I attempt to import the database script I get a variety of errors as follows:Msg 911, Level 16, State 1, Server ORTHANC\SQLEXPRESS, Line 1Could not locate entry in sysdatabases for database 'Contacts'. No entry found with that name. Make sure that the name is entered correctly.Msg 15401, Level 16, State 1, Server ORTHANC\SQLEXPRES...ImportExport.aspx will import to sql locally on sql express but when I upload it to my host it does not import
I have this ImportExport.aspx control http://www.codeproject.com/KB/aspnet/ImportExportCSV.aspx and it works great locally. When I upload it to my host I keep getting this error. Cannot find table 0. Error importing. Please try again It will export just fine. I am able to export a sql table to a csv so I do not beleive its my appsettings but here they are just in case<add key="connsql" value="server=sql394.mysite4now.com;database=mtgowarbots;Trusted_Connection=false;uid=users;password=KibblesNBits" />
<add key="connmsa" value="Provider=...SQL Remote ASE
did anybody know when SQL Remote support blob (image, text) replicacion for
ASE - ASE?
our company need this feature.
electro sur este s.a.a.
Support for image and text replication with SQL Remote went in as of ASA 6
and SA maintenance 5.5.04 build 1938.
Sybase Technical Support
> did anybody know when SQL Remote support blob (image, text) replicacion for
> ASE - ASE?
> our company need this feature.
> joan caceres
> electro sur este ...Problem importing SQL Anywhere to ASE on Linux
Hello to all,
we are using a SQL Anywhere database Vs.5.5 on NT4.0. Now I want to test
Sybase Adaptive Server Enterprise on linux. I have the database exportet
(data and structure) and tried to import the sql scripts to ASE over
isql. But that doesn't work because of syntax errors like comments that
in sqlanywhere begins with a % sign and in ASE is a syntax used like in
C. That is easy to correct but is ASE no so powerfull as sqlanywhere
like user defined datatypes etc.? Is ASE totally different from
sqlanywhere or is there a way to import this database in ASE.
I hope there is a...sql-remote between ASE and ASE
sql-remote document don't give us help with replication with ASE and ASE.
i need detail how to do it.
i use ASE12 + NT4.0 + SQL Remote6.0.2 .
i test it in the list
1�� define messagetype : smtp
2�� define use_name :one is publisher,the other is remote user_name
3�� define publisher,publication,subscription
4��execute ssremote.exe to receive or send message
I failed at the step of extract database .i don't extract the database .
please help me ,tell me the datail of sql-remote confige.
Thanks a lot ,
...sql remote ase to ase
can I use sql remote ro replicate data form ase to ase or only from asa to
ase and asa to asa ?
I would also recommend that you read over the following tech doc;
Implementing ASE to ASE Server SQL Remote Replication
Reg Domaratzki wrote:
> Just be aware of the limitations pointed out in the documentation when using ASE as a remote database.
> Replication and Synchronization Guide
> PART 4. Appendixes
> APPENDIX A. Enterprise and Anywhere: Differences
> Limitations ...