stored-procedures Archives - Page 2 of 3

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 ...

May 20, 2022
0 Comments

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 ...

May 19, 2022
0 Comments

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 ...

May 18, 2022
0 Comments

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 ...

May 17, 2022
0 Comments

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 ...

May 17, 2022
0 Comments

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 ...

May 15, 2022
0 Comments

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 ...

May 15, 2022
0 Comments

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: ...

May 13, 2022
0 Comments

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 ...

May 13, 2022
0 Comments

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. ...

May 10, 2022
0 Comments