How to pass single quote text as parameter to stored procedure in sqlserver
16,175
Solution 1
You can call the stored proc like this
exec stored_proc_name @param_name='Ram''s'
Solution 2
You need to escape the quote by another quote
'Ram''s'
Related videos on Youtube
03 : 53
How to Escape Single Quotes in SQL
20 : 48
SQL Server Programming Part 2 - Stored Procedure Parameters
04 : 13
How To Pass More than one Parameter in Stored procedures in T SQL
08 : 00
How to use a SQL Server Stored Procedure in a Power BI Module
09 : 27
Send datatable as parameter to stored procedure
06 : 15
Advanced SQL Tutorial | Stored Procedures + Use Cases
12 : 34
SSRS Tutorial 36 - Use Stored Procedure with Single Value Parameter in SSRS Report
02 : 58
SQL Server - Pass multiple values to singe parameter in stored procedure pass integers
06 : 14
How to include a single quote in a SQL query
25 : 46
SSRS Report Builder Part 10.6 - Stored Procedure Parameters
12 : 49
89 How to read data from Stored Procedure and pass input parameter from a variable using SSIS
11 : 34
29 How to execute stored procedure with input parameter as variable in SSIS
Author by
Mahesh
BY DAY: Alt-Rock Ninja Cowgirl at Veridian Dynamics. BY NIGHT: I write code and code rights for penalcoders.example.org, an awesome non-profit that will totally take your money at that link.
Updated on June 17, 2022Comments
-
Mahesh about 2 years
How to pass "Ram's" or "I'm xxx" type of single quote data as parameter to the stored procedure?