sql-scripts Questions
5
Is there a way to specify that when executing a sql script it stops when encountering the first error on the script, it usually continues, regardless of previous errors.
Spleen asked 18/12, 2010 at 21:54
10
Solved
Is there a command in Microsoft SQL Server T-SQL to tell the script to stop processing?
I have a script that I want to keep for archival purposes, but I don't want anyone to run it.
Ician asked 8/1, 2010 at 14:10
2
Although I can find (on the web) a lot of information about the PreDeploy and PostDeploy Build Action for SQL scripts in a Visual Studio 2012 Database project and I understand that None does not co...
Kinney asked 11/8, 2016 at 13:8
7
Solved
I am developing a Spring Boot application. At the moment some of my configs are hard coded (e.g. Hystrix properties).
So I would like to get these configs on my application start up time or just a...
Bakemeier asked 1/9, 2016 at 20:26
2
Solved
I am using Spring Boot Database initialization using Spring JDBC with schema.sql file.I am using MYSQL
If I have simple table creation in schema.sql as follows it works fine
CREATE TABLE Persons
...
Busload asked 8/3, 2017 at 15:3
7
Solved
I have a case where i have got 10+ SQL script.
I don't want to go and run all my scripts 1 by 1.
Is there a way that i can run all my scripts in succession in SQL Management studio.
I found this...
Bespoke asked 13/1, 2012 at 7:27
12
Solved
I want to execute an SQL script file in Java without reading the entire file content into a big query and executing it.
Is there any other standard way?
Chemoprophylaxis asked 15/1, 2010 at 13:14
2
Solved
I have many .sql files in a folder (/home/myHSH/scripts) in linux debian. I want to know the command to execute or run all sql files inside the folder into postgreSQL v9.1 database.
PostgreSQL inf...
Titty asked 25/10, 2012 at 5:31
6
Solved
First, this question relates to Oracle SQL Developer 3.2, not SQL*Plus or iSQL, etc. I've done a bunch of searching but haven't found a straight answer.
I have several collections of scripts that ...
Gupta asked 2/6, 2014 at 20:22
3
Solved
So I have been blindly using ansi_nulls on, quoted_identifier on when creating scripts, because sqlserver generates them automatically when scripting objects..
I don't really have time to concern...
Quito asked 19/2, 2019 at 11:20
3
Solved
Is there any sql script to find out when the database in SQL server is last updated?
I want to know the last updated date time for the changes done on meta data of the database rather than actual...
Trimer asked 9/4, 2015 at 9:45
3
Solved
I have an empty database:
DB_Clients
And I want to restore the database from a .bak file:
OldDBClients.bak
This is the path:
C:\OldDBClients.bak
And this is my script:
USE [master]
GO
R...
Bridgman asked 18/11, 2015 at 15:25
3
Is it possible to specify which is the primary key on creating table as select statement? My aim is to include the declaration of primary key on the create table not modifying the table after the c...
Kennith asked 29/9, 2019 at 11:7
6
Solved
I have a database table on a development server that is now fully populated after I set it running with an import routine for a CSV file containing 1.4 million rows.
I ran the Database Publishing ...
Cylindroid asked 21/10, 2008 at 16:7
4
Solved
I'm having a hard time with a class I am taking. We need to write an Oracle script that will act just like the DESCRIBE command. The book we are using describes how to work with the Data Dictionary...
Pino asked 24/3, 2012 at 20:15
4
Solved
First of all I would like to say am new to h2 database. I need to execute a sql script file in h2 database. I have a script file test.sql and I want to execute this in h2 database. Is it possible?
...
Tartar asked 20/5, 2012 at 17:53
1
Solved
I'm creating a MySQL Script that runs on a record and pulls associated records from a series of other tables, which is super useful but in DBeaver the results come back as tabs that only have the n...
Reareace asked 2/11, 2017 at 17:59
4
Solved
I have a question about spooling the the results of my program. My sample sql script looks like this.
whenever sqlerror exit failure rollback
set heading off
set arraysize 1
set newpage 0
set...
Transplant asked 21/12, 2011 at 13:49
2
I have the following script:
use my_db;
if (2 < 3) then
select 1;
end if;
When I execute this with command:
mysql --user=myuser --password=mypassword < script.sql
I get the followi...
Amniocentesis asked 25/3, 2017 at 13:15
1
Solved
I am trying to initialize my database with a view and a rule following 75.3 Initialize a database using Spring JDBC.
75.3 Initialize a database using Spring JDBC
Spring JDBC has a DataSource ...
Sadie asked 21/9, 2016 at 12:40
7
Solved
In the freeware version of Toad for MySQL (latest version), I can generate a script of all tables in my database in one file. However, for stored procedures and functions, Toad generates a separate...
Schaub asked 21/11, 2010 at 20:27
2
I want to script all the stored procedures from SQL Server 2012 to Visual Studio 2012 as .sql files (in a different project). How do I do that? I want one .sql file for each stored procedure?
I ge...
Ciro asked 1/3, 2016 at 9:46
4
Solved
I've created a database model with model-first method using Entity Framework 4.0. I then created an sql script using the Generate Database from Model... I've also created an SQL Server Database fil...
Terrenceterrene asked 20/11, 2010 at 18:21
3
Solved
I want to create a script for my oracle DB, which drops tables. If the table does not exist, the script won't exit as fail, just print a text: "does not exists".
The script is the following:
BEGI...
Flaxseed asked 18/11, 2015 at 9:58
3
Solved
I have C# code that cycles through .sql files and executes what's inside them to set up a database.
One .sql file is basically as follows:
DROP PROCEDURE IF EXISTS myProc;
DELIMITER $$
CREATE P...
Toitoiboid asked 24/8, 2009 at 20:49
1 Next >
© 2022 - 2025 — McMap. All rights reserved.