All Questions
Tagged with stored-procedures sql-server
14,452 questions
0
votes
0
answers
48
views
The module being executed is not trusted - for procedure "with execute as" clause
I have a stored procedure in a database OmegaCoreAudit that queries the master.sys.fn_get_audit_file records and stores them to a table in the same database.
The owner of this database is login ...
- 369
-1
votes
0
answers
47
views
Why am I receiving this empty xmlns? [duplicate]
I'm switching over a BizTalk port from adapter 'SQL' to 'WCF-SQL' due to the former being removed from the next version of BizTalk, I can receive the message from the stored procedure fine, except for ...
- 15
0
votes
1
answer
76
views
Call stored procedure in separate session in SQL Server
I tried calling a SQL Server stored procedure in another session.
This is my code:
CREATE PROCEDURE [dbo].[CI_AdHoc_PrepareJob]
(
@JobName NVARCHAR(50),
@StepName NVARCHAR(50),
@Value ...
- 1,416
-2
votes
1
answer
59
views
I have a stored procedure that compares separated values to the values in the columns from a table but how do you return the entity [duplicate]
I have a stored procedure that compares text values in a table:
ALTER PROCEDURE [dbo].[getThreadsBySearchTerm]
@searchTerm nvarchar(80)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @pos INT
...
- 2,353
0
votes
3
answers
115
views
Getting duplicate rows when using temp table and inner joins
I have a temp table and inserts the search term inside the temp table that has a search term of split spaces, but when I query the SQL the rows are duplicated because of how many rows are in the temp ...
- 2,353
-3
votes
0
answers
30
views
How can you return the number of rows from a temp table [duplicate]
I have a temp table which inserts values from a split of white spaces, what i need is a way to say if temp table has more than 1 row, then execute the code else execute different part of code:
ALTER ...
- 2,353
1
vote
1
answer
85
views
Comparing a search term that contains more than one word and searches different variations for the search term and pulls out records
If I have a search term that equals "Hello Connor Mcgregor", then how would I use this search term so that the search term loops each search word in the list for example:
searchTerm[0] = &...
- 2,353
1
vote
0
answers
21
views
SQLCMD executing sp_help_jobhistory via XP_CMDSHELL and trying to write results to table
When I run the command, I get Column name or number of supplied values does not match table definition.
The output from sp_help_jobhistory returns 11 columns which I have defined in my table.
Here is ...
- 11
-1
votes
1
answer
40
views
Pull out Descriptions as Variables
I have a table that has fields for table name, field name, and descriptions of those fields.
I want to assign the descriptions for fields of a specific table to variables for use in a stored procedure....
0
votes
0
answers
32
views
Call SQL stored procedure using python -> Previous SQL was not a query [duplicate]
I'm trying to call the stored procedure using the python.
Background: I retrieve the doc_id which I need to pass to stored procedure which is varbinary value. I had the issue where my string doc_id ...
0
votes
1
answer
102
views
Stored procedure returns null instead all column names with one empty record in json_string output using JSON AUTO
I have a stored procedure where I get some column names from the table and take remaining column names dynamically. I get column names with no records if I don't convert it to JSON string but if I ...
- 69
0
votes
1
answer
52
views
Handle nullable parameters and dynamic WHERE clause in stored procedure [duplicate]
I have a SQL Server stored procedure with several parameters that I'm using to build a dynamic WHERE clause. This stored procedure works fine, but the performance is terrible when certain parameters ...
- 443
0
votes
0
answers
56
views
Transport-level error when sending the request to the server(provider: Session Provider, error: 19 - Physical connection is not usable)in ASP.NET MVC5
I am encountering an intermittent issue in my ASP.NET MVC 5 application, where the following error occurs only in production, but not in my development environment (localhost):
A transport-level ...
0
votes
1
answer
72
views
Need to parse JSON returned from stored procedure for Logic App
I am trying to return a single order from a SQL Server table as JSON from a stored procedure to create input for an action in a Logic App. The procedure always wraps the result in something more than ...
0
votes
2
answers
121
views
Calling a SQL Server stored procedure with parameters in VB.NET
I have a SQL server stored procedure with an input parameter @ClientID which I am trying to call from a VB.NET application. The following code always fails on the line which sets the parameter with an ...
- 307
