SQL Scripts are lists of SQL sentences written in a single file, meant to be executed sequentially. Depending on the particular RDBMS system, SQL scripts can have procedural language characteristics, such as control-of-flow constructs.
Questions tagged [sql-scripts]
437 questions
3
votes
4 answers
please help me with Error 27506 Error executing SQL script
I'm trying to create a setup file using InstallShield 2010 for my project which uses SQL Server 2008
Everything is ok all necessary programs are being installed but when I try to install my project it will give this error
Error 27506. Error…
Scorpio
- 153
- 1
- 5
- 13
3
votes
1 answer
Should I explicitly "SET IDENTITY_INSERT [Table] OFF" after turning "ON"?
Does SET IDENTITY_INSERT [Table] ON persist beyond the scope of a SQL Script? I'm wondering if I need to explicitly set it to "OFF" or if SQL Server knows that it should only use that setting for the current script.
Thanks!
Mark Carpenter
- 17,445
- 22
- 96
- 149
2
votes
1 answer
Invalid column name 'XXXXXXXX'
I have a sql script say "abc.sql" which I am calling from a batch file using sqlcmd like
Calling batch script like
script.bat arg1 arg2
In batch
param1=%1
param2=%2
Then calling SQL script like
sqlcmd -S server -i abc.sql -v var1=%param1%…
Rahul
- 76,197
- 13
- 71
- 125
2
votes
2 answers
How can I su from root to db2inst1 and invoke a SQL script, in one line?
How can I su from root to db2inst1 and invoke a SQL script all in 1 line? I am thinking about something like this:
su db2inst1 | db2 CONNECT TO myDatabase USER db2inst1 USING mypw; db2 -c -i -w -td@ -f /tmp/deploy/sql/My.sql | exit;
Any ideas?
mordechai
- 127
- 2
- 10
2
votes
2 answers
SQL Server 2008 column in only one table
First a quick explanation: I am actually dealing with four tables and mining data from different places but my problem comes down to this seemingly simple concept and yes I am very new to this...
I have two tables (one and two) that both have ID…
2boolORNOT2bool
- 557
- 3
- 9
- 23
2
votes
2 answers
IBM i Access Client Solutions (ACS) Run SQL Scripts - print variable
is there an easy way to display/print a variable on the output of the IBM i ACS Run SQL Script screen?
For having a quick check when writing a script it would very helpful to be able to display the content of a variable. E.g. in below script, I want…
KoenS
- 39
- 3
2
votes
1 answer
Changing the default "Processed xx total records" for scripting SQL data
In SQL Server 2008, you can right-click on a database and select "Generate Scripts...". You can then choose a particular table and choose "Data only" under the "Types of data to script". When you do this, it automatically inserts a line in the…
Loki70
- 613
- 4
- 15
- 36
2
votes
1 answer
Would removing 'OPTIMIZE_FOR_SEQUENTIAL_KEY' solve the failure of my script.sql or is more involved (SQL Server Express DB -> SQL Server)?
I am trying to set up my SQL Server Express database on my hosting site (GoDaddy/Plesk) as a full-fledged SQL Server DB, but have run into a series of error messages running the script.sql file.
I am following the steps here to set up my DB, first…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
2
votes
4 answers
How to download all views stored in snowflake to local machine
I want to create a backup of all SQL scripts (views) that are saved on snowflake (not data). How can I do it? Obviously manual copy and pasting is not an answer.
Expected result: I have all views (sql scripts) that are in snowflake database on my…
askstackoverflow
- 301
- 3
- 11
2
votes
1 answer
Making git diff (NOT difftool) and git log -p work with *.sql files and Windows PowerShell
I know how to configure an external tool to view differences with a call to git difftool. However, if I want to see an 'dump' of all changes for entire history of a file to my console window, I wanted to use git log -p . The problem I'm…
Terry
- 2,148
- 2
- 32
- 53
2
votes
1 answer
How do I write the table structure in Oracle from an existing schema?
I have so far figured out that to describe a table I can use the below:
select dbms_metadata.get_ddl('TABLE','','') from dual;
I also found that I can get a list of tables from the current user using the below…
