A stored procedure is a set of Structured Query Language (SQL) statements with an assigned name, which are stored in a relational database management system as a group, so it can be reused and shared by multiple programs.
Question:update or alter a stored procedure programmatically through C# code
Description:I have to update a store procedure on live site and we don't have the access of the database at our development environment so we need to do this through code in C#. I have search a lot but unable to find a proper solution For example , I have a following stored procedure, ALTER PROCEDURE [dbo].[SelectCustomers] AS BEGIN SELECT * from Customer order by Customer.DateCreated DESC END And I want to update it to the following one ALTER PROCEDURE [dbo].[SelectCustomers] AS BEGIN SELECT * from Customer where Customer.Status=1 order by Customer.DateCreated DESC END
Posted by: Junaid Aziz | Posted on: May 09, 2019
Question:what is the difference between view and Stored Procedure (view vs stored procedure) in sql?
Description:Need to know the difference between the two in terms of which should be used in what conditions, according to my current research similar operation can be achieved using any of them
Posted by: Junaid Aziz | Posted on: Jan 25, 2019
Question:What is the difference between/ purpose of the @@IDENTITY, SCOPE_IDENTITY(), IDENT_CURRENT ?
Description:I want to know the differences between or purposes of each one of the @@IDENTITY, SCOPE_IDENTITY(), IDENT_CURRENT() .
Posted by: Jhon Anthony | Posted on: Jul 12, 2018