Check if a string contains a substring in SQL Server 2005, using a stored procedure
I’ve a string, @mainString = ‘CATCH ME IF YOU CAN’. I want to check whether the word ME is inside @mainString. How do … Read more
stored-procedures
What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Closed 8 years ago. Locked. This question and its answers are locked … Read more
How to call Stored Procedure in Entity Framework 6 (Code-First)?
I am very new to Entity Framework 6 and I want to implement stored procedures in my project. I have a stored procedure … Read more
How to execute a stored procedure within C# program
I want to execute this stored procedure from a C# program. I have written the following stored procedure in a SqlServer query window … Read more
SQL Server: Query fast, but slow from procedure
A query runs fast: DECLARE @SessionGUID uniqueidentifier SET @SessionGUID = ‘BCBA333C-B6A1-4155-9833-C495F22EA908’ SELECT * FROM Report_Opener WHERE SessionGUID = @SessionGUID ORDER BY CurrencyTypeOrder, Rank … Read more
What is a stored procedure?
What is a “stored procedure” and how do they work? What is the make-up of a stored procedure (things each must have to … Read more
How to check if a stored procedure exists before creating it
I have a SQL script that has to be run every time a client executes the “database management” functionality. The script includes creating … Read more
SQL Server Insert if not exists
I want to insert data into my table, but insert only data that doesn’t already exist in my database. Here is my code: … Read more
How to pass an array into a SQL Server stored procedure
How to pass an array into a SQL Server stored procedure? For example, I have a list of employees. I want to use … Read more
How do I find a stored procedure containing ?
I need to search a SQL server 2008 for stored procedures containing where maybe the name of a database field or variable name. … Read more