calling a sql script from another sql scriptHi, 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
greatly
appreciated.
-Yilin
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
> greatly
> app...
Syntax to call a t-sql script from another t-sql scriptI 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
in SQLServer?
Thanks,
Chris Emerson
"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
Hello All,
I need to import records from one SQL table to another SQL table. Both tables are in the same database. Does anyone know how?
Thank you,
Tina
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
tmorton,
I tried using DTS and got confused. I got the query to work.
Thank You!
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.
Hi,
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.
Hey all,
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.
TIA
-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 scriptHello
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.
Best regards
Flemming
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 ASEhi
did anybody know when SQL Remote support blob (image, text) replicacion for
ASE - ASE?
our company need this feature.
joan caceres
electro sur este s.a.a.
Hello Joan,
Support for image and text replication with SQL Remote went in as of ASA 6
mainline, 6.0.01.1256,
and SA maintenance 5.5.04 build 1938.
Regards,
Bob Bauer
Sybase Technical Support
jmcd wrote:
> hi
>
> 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 LinuxHello 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 ASEhello!
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 asecan 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
http://my.sybase.com/detail?id=1009730
Ian Bater
iAnywhere Solutions
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 ...