StackOverflow Questions for Tag: sp-executesql

Iniyavan

Reputation: 115

SQL Server - EXECUTE permission

stored-proceduresrolesstored-functionssp-executesqlazure-managed-database

Score: 1

Answers: 1

High Plains Grifter

Reputation: 1571

Dynamically Executing Stored Proc with output variables

sqlsql-servert-sqlopenquerysp-executesql

Score: 2

Answers: 1

JJ.

Reputation: 9960

How do I truncate a table via linked server using a synonym for the table name?

sql-servert-sqllinked-serversynonymsp-executesql

Score: 5

Answers: 2

Jacob Quisenberry

Reputation: 1199

T-SQL Create Table with Dynamically Named Database with sp_executesql

sqlsql-servert-sqlcreate-tablesp-executesql

Score: 2

Answers: 2

Cameron Castillo

Reputation: 2832

Output parameter from TSQL sp_executesql seems to be null

t-sqlsp-executesql

Score: 0

Answers: 0

Jessica

Reputation: 2051

sp_executesql sets a column to null

sqlt-sqlstored-proceduresparameterssp-executesql

Score: 1

Answers: 1

MarJer

Reputation: 107

How can I concatenate stringvalues in a parameter definition for a sp_executesql statement?

t-sqlsp-executesql

Score: 0

Answers: 1

Caleb

Reputation: 11

Table name as variable in sql server

stored-proceduressql-server-2017sp-executesql

Score: 1

Answers: 0

Hakim Chandio

Reputation: 1

Hide Result set of sp_executesql

sql-servert-sqltemp-tablesdynamicquerysp-executesql

Score: 0

Answers: 1

shiga soumya

Reputation: 51

Does sp_executesql support multiple values in one parameter and return multiple records?

sqlsql-serversp-executesql

Score: 0

Answers: 3

Alison Niu

Reputation: 74

Why sometimes sp_executesql can be used in function sometimes not?

sql-serversp-executesql

Score: -1

Answers: 1

Rosko

Reputation: 1

Update a null column in sql with spexecutesql

c#sqlasp.netsql-serversp-executesql

Score: 0

Answers: 1

Ben Gribaudo

Reputation: 5147

Error Handling - Determine whether sp_executesql was the source

sql-servert-sqlerror-handlingsp-executesql

Score: 3

Answers: 3

Nick

Reputation: 3

T-SQL stored procedure output parameter

sql-servert-sqlstored-proceduresexecsp-executesql

Score: 0

Answers: 0

srh

Reputation: 1661

How to run query with parameters against a database whose name is in a variable using sp_ExecuteSql

sqlsql-serversp-executesql

Score: 0

Answers: 1

Viktor Pagels

Reputation: 305

How do I execute a dynamic SQL with over 8000 Characters?

mdxsql-server-2016openrowsetsp-executesql

Score: 0

Answers: 1

Vidhi Shah

Reputation: 23

sp_executesql with OUTPUT Parameter on SET statement

sql-injectionsp-executesqlsp-send-dbmail

Score: 0

Answers: 1

Satinder singh

Reputation: 10198

For dynamic StoredProcedure with custom user defined datatype error: Must declare the scalar variable "@myTableType2"

sql-serversql-server-2008user-defined-typessp-executesql

Score: 0

Answers: 3

dj.canuk

Reputation: 13

VB.net parameterized query uses sp_executesql but loses UTF8 characters

sql-servervb.netado.netsql-server-2019sp-executesql

Score: 0

Answers: 0

Samuel

Reputation: 7

SSIS Execute SQL Task contain Insert Into and Select

sqlssissp-executesql

Score: 0

Answers: 2

PreviousPage 2Next

StackOverflow Questions for Tag: sp-executesql

SQL Server - EXECUTE permission

Dynamically Executing Stored Proc with output variables

How do I truncate a table via linked server using a synonym for the table name?

T-SQL Create Table with Dynamically Named Database with sp_executesql

Output parameter from TSQL sp_executesql seems to be null

sp_executesql sets a column to null

How can I concatenate stringvalues in a parameter definition for a sp_executesql statement?

Table name as variable in sql server

Hide Result set of sp_executesql

Does sp_executesql support multiple values in one parameter and return multiple records?

Why sometimes sp_executesql can be used in function sometimes not?

Update a null column in sql with spexecutesql

Error Handling - Determine whether sp_executesql was the source

T-SQL stored procedure output parameter

How to run query with parameters against a database whose name is in a variable using sp_ExecuteSql

How do I execute a dynamic SQL with over 8000 Characters?

sp_executesql with OUTPUT Parameter on SET statement

For dynamic StoredProcedure with custom user defined datatype error: Must declare the scalar variable &quot;@myTableType2&quot;

VB.net parameterized query uses sp_executesql but loses UTF8 characters

SSIS Execute SQL Task contain Insert Into and Select

For dynamic StoredProcedure with custom user defined datatype error: Must declare the scalar variable "@myTableType2"