FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
website-sqlnotebook.com/create-script-stmt.html at main · brianluft/website-sqlnotebook.com · GitHub
Uh oh!
There was an error while loading.
Please reload this page
.
brianluft
/
website-sqlnotebook.com
Public
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Security and quality
Insights
Expand file tree
Breadcrumbs
website-sqlnotebook.com
/
create-script-stmt.html
Copy path
More file actions
More file actions
Latest commit
History
History
History
64 lines (62 loc) · 2.56 KB
Breadcrumbs
website-sqlnotebook.com
/
create-script-stmt.html
Copy path
File metadata and controls
64 lines (62 loc) · 2.56 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
<!DOCTYPE html
>
<
html
lang
="
en
"
>
<
head
>
<
meta
http-equiv
="
Content-Type
"
content
="
text/html; charset=UTF-8
"
>
<
meta
http-equiv
="
X-UA-Compatible
"
content
="
IE=edge
"
>
<
title
>
CREATE SCRIPT Statement - SQL Notebook
</
title
>
<
link
rel
="
stylesheet
"
href
="
sqlnotebook.css
"
>
</
head
>
<
body
>
<
header
>
<
table
class
="
nav
"
>
<
tr
>
<
td
>
<
a
href
="
index.html
"
>
<
img
src
="
art/SqlNotebookIcon.png
"
alt
="
SQL Notebook (logo)
"
style
="
width: 58px; height: 58px; float: left; margin-right: 20px;
"
>
</
a
>
</
td
>
<
td
>
<
a
href
="
index.html
"
id
="
title
"
>
SQL Notebook
</
a
>
<
br
>
<
nav
>
<
ul
class
="
nav
"
>
<
li
>
<
a
href
="
https://github.com/brianluft/sqlnotebook/releases
"
>
Download
</
a
>
</
li
>
<
li
>
<
a
href
="
doc.html
"
>
<
span
id
="
header-doc-long
"
>
Documentation
</
span
>
<
span
id
="
header-doc-short
"
>
Docs
</
span
>
</
a
>
</
li
>
<
li
>
<
a
href
="
https://github.com/brianluft/sqlnotebook
"
>
GitHub
</
a
>
</
li
>
</
ul
>
</
nav
>
</
td
>
</
tr
>
</
table
>
<
hr
style
="
margin-top: 15px; margin-bottom: 15px;
"
>
</
header
>
<
article
>
<
div
id
="
article
"
>
<
h1
>
<
code
>
CREATE SCRIPT
</
code
>
Statement
</
h1
>
Creates a script in the notebook.
<
h2
>
Syntax
</
h2
>
<
p
>
<
tt
>
CREATE SCRIPT
<
i
>
script-name
</
i
>
AS
<
i
>
sql-commands
</
i
>
;
</
tt
>
<
br
>
</
p
>
<
h2
>
Parameters
</
h2
>
<
ul
class
="
args
"
>
<
li
>
<
i
>
script-name
</
i
>
: text
<
br
>
The name of the script to create. This can be a string literal or an expression that evaluates to a string.
</
li
>
<
li
>
<
i
>
sql-commands
</
i
>
: text
<
br
>
The SQL commands that will comprise the script body. This can be a string literal or an expression that evaluates
to a string.
</
li
>
</
ul
>
<
h2
>
Remarks
</
h2
>
<
p
>
The CREATE SCRIPT statement creates a new script in the notebook with the specified name and content. Script names
are case-insensitive.
</
p
>
<
p
>
If a script with the specified name already exists, an error is thrown.
</
p
>
<
p
>
Once created, the script can be executed using the EXECUTE statement.
</
p
>
<
h2
>
Examples
</
h2
>
<
ul
class
="
examples
"
>
<
li
>
<
code
>
CREATE SCRIPT MyScript AS 'PRINT ''Hello World'';';
</
code
>
<
br
>
Creates a script named "MyScript" that prints "Hello World".
</
li
>
<
li
>
<
code
>
CREATE SCRIPT ReportScript AS 'SELECT * FROM users WHERE active = 1;';
</
code
>
<
br
>
Creates a script named "ReportScript" that queries active users.
</
li
>
<
li
>
<
code
>
CREATE SCRIPT ('Report' || '2024') AS 'PRINT ''Report for 2024'';';
</
code
>
<
br
>
Creates a script whose name is the result of concatenating "Report" and "2024", i.e., "Report2024".
</
li
>
</
ul
>
</
div
>
</
article
>
<
footer
>
<
div
id
="
footer
"
>
<
hr
>
© 2016-2025
<
a
href
="
https://github.com/electroly
"
>
Brian Luft
</
a
>
</
div
>
</
footer
>
</
body
>
</
html
>
Back
|
FazBrowse Home
|
New Git URL