How do I create Stored Procedure in MSSQL without Management Studio?
I have a customer who is not interested in installing MSSQL Management Studio. And I need to add one Stored procedure in the Database for my application to communicate.
Is it possible to create the stored procedure in MSSQL Server without Management Studio?
FYI, I can export the .sql file for Stored procedure from my system.
Solved
Solutions based on the answers:
SQLCMD (installed with SQL Server)- Azure Data Studio
sql-server stored-procedures export ssms edited Jan 1 at 8:42
Cœur
18.3k9109148
asked Oct 3 '18 at 12:45
Naveen Kumar VNaveen Kumar V
578723
add a comment |
I have a customer who is not interested in installing MSSQL Management Studio. And I need to add one Stored procedure in the Database for my application to communicate.
Is it possible to create the stored procedure in MSSQL Server without Management Studio?
FYI, I can export the .sql file for Stored procedure from my system.
Solved
Solutions based on the answers:
SQLCMD (installed with SQL Server)- Azure Data Studio
sql-server stored-procedures export ssms edited Jan 1 at 8:42
Cœur
18.3k9109148
asked Oct 3 '18 at 12:45
Naveen Kumar VNaveen Kumar V
578723
2
Command line sqlcmd, tools ssdt
– Stanislav Kundii
Oct 3 '18 at 12:50
How did you set-up the database and how is the SQL Server instance managed? Use that software to run the script.
– Wolfgang Kais
Oct 3 '18 at 13:06
Or just connect to their database using the version installed on your laptop. What a strange situation. Sometimes clients can't be saved from themselves.
– Sean Lange
Oct 3 '18 at 13:19
add a comment |
I have a customer who is not interested in installing MSSQL Management Studio. And I need to add one Stored procedure in the Database for my application to communicate.
Is it possible to create the stored procedure in MSSQL Server without Management Studio?
FYI, I can export the .sql file for Stored procedure from my system.
Solved
Solutions based on the answers:
SQLCMD (installed with SQL Server)- Azure Data Studio
sql-server stored-procedures export ssms edited Jan 1 at 8:42
Cœur
18.3k9109148
asked Oct 3 '18 at 12:45
Naveen Kumar VNaveen Kumar V
578723
I have a customer who is not interested in installing MSSQL Management Studio. And I need to add one Stored procedure in the Database for my application to communicate.
Is it possible to create the stored procedure in MSSQL Server without Management Studio?
FYI, I can export the .sql file for Stored procedure from my system.
Solved
Solutions based on the answers:
SQLCMD (installed with SQL Server)- Azure Data Studio
sql-server stored-procedures export ssms sql-server stored-procedures export ssms edited Jan 1 at 8:42
Cœur
18.3k9109148
asked Oct 3 '18 at 12:45
Naveen Kumar VNaveen Kumar V
578723
edited Jan 1 at 8:42
Cœur
18.3k9109148
asked Oct 3 '18 at 12:45
Naveen Kumar VNaveen Kumar V
578723
edited Jan 1 at 8:42
Cœur
18.3k9109148
edited Jan 1 at 8:42
Cœur
18.3k9109148
edited Jan 1 at 8:42
Cœur
18.3k9109148
18.3k9109148
asked Oct 3 '18 at 12:45
Naveen Kumar VNaveen Kumar V
578723
asked Oct 3 '18 at 12:45
Naveen Kumar VNaveen Kumar V
578723
asked Oct 3 '18 at 12:45
Naveen Kumar VNaveen Kumar V
578723
578723
2
Command line sqlcmd, tools ssdt
– Stanislav Kundii
Oct 3 '18 at 12:50
How did you set-up the database and how is the SQL Server instance managed? Use that software to run the script.
– Wolfgang Kais
Oct 3 '18 at 13:06
Or just connect to their database using the version installed on your laptop. What a strange situation. Sometimes clients can't be saved from themselves.
– Sean Lange
Oct 3 '18 at 13:19
add a comment |
2
Command line sqlcmd, tools ssdt
– Stanislav Kundii
Oct 3 '18 at 12:50
How did you set-up the database and how is the SQL Server instance managed? Use that software to run the script.
– Wolfgang Kais
Oct 3 '18 at 13:06
Or just connect to their database using the version installed on your laptop. What a strange situation. Sometimes clients can't be saved from themselves.
– Sean Lange
Oct 3 '18 at 13:19
2
2
Command line sqlcmd, tools ssdt
– Stanislav Kundii
Oct 3 '18 at 12:50
Command line sqlcmd, tools ssdt
– Stanislav Kundii
Oct 3 '18 at 12:50
How did you set-up the database and how is the SQL Server instance managed? Use that software to run the script.
– Wolfgang Kais
Oct 3 '18 at 13:06
How did you set-up the database and how is the SQL Server instance managed? Use that software to run the script.
– Wolfgang Kais
Oct 3 '18 at 13:06
Or just connect to their database using the version installed on your laptop. What a strange situation. Sometimes clients can't be saved from themselves.
– Sean Lange
Oct 3 '18 at 13:19
Or just connect to their database using the version installed on your laptop. What a strange situation. Sometimes clients can't be saved from themselves.
– Sean Lange
Oct 3 '18 at 13:19
add a comment |
2 Answers
2
active
oldest
votes
You can use...
- SSDT (SQL Server Data Tools)
- SQLCMD
- PowerShell
answered Oct 3 '18 at 13:32
ApepApep
713
SQLCMD is installed by default. That should work for me. Thanks. :)
– Naveen Kumar V
Oct 9 '18 at 10:58
add a comment |
You could see if your client would be willing to install Azure Data Studio (formerly SQL Operations Studio). It's a quicker install than SSMS.
answered Oct 3 '18 at 16:43
Jeremy J.Jeremy J.
4818
Thanks for mentioning the tool.
– Naveen Kumar V
Oct 9 '18 at 10:57
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f52627356%2fhow-do-i-create-stored-procedure-in-mssql-without-management-studio%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can use...
- SSDT (SQL Server Data Tools)
- SQLCMD
- PowerShell
answered Oct 3 '18 at 13:32
ApepApep
713
SQLCMD is installed by default. That should work for me. Thanks. :)
– Naveen Kumar V
Oct 9 '18 at 10:58
add a comment |
You can use...
- SSDT (SQL Server Data Tools)
- SQLCMD
- PowerShell
answered Oct 3 '18 at 13:32
ApepApep
713
SQLCMD is installed by default. That should work for me. Thanks. :)
– Naveen Kumar V
Oct 9 '18 at 10:58
add a comment |
You can use...
- SSDT (SQL Server Data Tools)
- SQLCMD
- PowerShell
answered Oct 3 '18 at 13:32
ApepApep
713
You can use...
- SSDT (SQL Server Data Tools)
- SQLCMD
- PowerShell
answered Oct 3 '18 at 13:32
ApepApep
713
edited Oct 3 '18 at 13:38
answered Oct 3 '18 at 13:32
ApepApep
713
answered Oct 3 '18 at 13:32
ApepApep
713
answered Oct 3 '18 at 13:32
ApepApep
713
713
SQLCMD is installed by default. That should work for me. Thanks. :)
– Naveen Kumar V
Oct 9 '18 at 10:58
add a comment |
SQLCMD is installed by default. That should work for me. Thanks. :)
– Naveen Kumar V
Oct 9 '18 at 10:58
SQLCMD is installed by default. That should work for me. Thanks. :)
– Naveen Kumar V
Oct 9 '18 at 10:58
SQLCMD is installed by default. That should work for me. Thanks. :)
– Naveen Kumar V
Oct 9 '18 at 10:58
add a comment |
You could see if your client would be willing to install Azure Data Studio (formerly SQL Operations Studio). It's a quicker install than SSMS.
answered Oct 3 '18 at 16:43
Jeremy J.Jeremy J.
4818
Thanks for mentioning the tool.
– Naveen Kumar V
Oct 9 '18 at 10:57
add a comment |
You could see if your client would be willing to install Azure Data Studio (formerly SQL Operations Studio). It's a quicker install than SSMS.
answered Oct 3 '18 at 16:43
Jeremy J.Jeremy J.
4818
Thanks for mentioning the tool.
– Naveen Kumar V
Oct 9 '18 at 10:57
add a comment |
You could see if your client would be willing to install Azure Data Studio (formerly SQL Operations Studio). It's a quicker install than SSMS.
answered Oct 3 '18 at 16:43
Jeremy J.Jeremy J.
4818
You could see if your client would be willing to install Azure Data Studio (formerly SQL Operations Studio). It's a quicker install than SSMS.
answered Oct 3 '18 at 16:43
Jeremy J.Jeremy J.
4818
answered Oct 3 '18 at 16:43
Jeremy J.Jeremy J.
4818
answered Oct 3 '18 at 16:43
Jeremy J.Jeremy J.
4818
answered Oct 3 '18 at 16:43
Jeremy J.Jeremy J.
4818
4818
Thanks for mentioning the tool.
– Naveen Kumar V
Oct 9 '18 at 10:57
add a comment |
Thanks for mentioning the tool.
– Naveen Kumar V
Oct 9 '18 at 10:57
Thanks for mentioning the tool.
– Naveen Kumar V
Oct 9 '18 at 10:57
Thanks for mentioning the tool.
– Naveen Kumar V
Oct 9 '18 at 10:57
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f52627356%2fhow-do-i-create-stored-procedure-in-mssql-without-management-studio%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Command line sqlcmd, tools ssdt
– Stanislav Kundii
Oct 3 '18 at 12:50
How did you set-up the database and how is the SQL Server instance managed? Use that software to run the script.
– Wolfgang Kais
Oct 3 '18 at 13:06
Or just connect to their database using the version installed on your laptop. What a strange situation. Sometimes clients can't be saved from themselves.
– Sean Lange
Oct 3 '18 at 13:19