SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.
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:In a many to many relationship, get records of table A associated with more than N number records of table B?
Description:I have Table A(assumed as Student) and Table B(assumed as Course) with their junction Table AB (StudentCourse),For example considering the following tables I need to get all the students with their Id and name who have enrolled in more than three(N) courses |Student| |Id | |Name | |Course| |Id | |Name | |StudentCourse| |Id | |SId | |CId |
Posted by: Samantha Jones | Posted on: Apr 17, 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:Combine the summation of row counts from multiple tables and returned as one value in MSSQL
Description:I want to return one value which will be the sum of multiple row counts from different tables.
Posted by: Junaid Aziz | Posted on: Sep 13, 2018
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
Question:What is the use of ExecuteScalar,ExecuteReader and ExecuteNonQuery methods?
Description:What is the difference between ExecuteScalar,ExecuteReader and ExecuteNonQuery methods and In what conditions which one to use
Posted by: Jhon Anthony | Posted on: Jul 11, 2018
Question:how to track down the recent updates that are made in my database ?
Description:I am using a cms and some recent updates are made in my mssql database , I have no clue about in which table record is inserted or updated !!! any sql query which can help me in this regard
Posted by: Junaid Aziz | Posted on: May 28, 2018
Question:What is the purpose of each Sitecore's core, master, and web databases?
Description:What is the purpose of Sitecore's core, master, and web databases or the differences between them?
Posted by: Khalid Abbas | Posted on: Nov 16, 2017
Question:how to resolve "Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the option prevent saving changes that require
Description:I am getting the following error whenever i try to edit the table design, i.e changing the column's data type Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the option prevent saving changes that require the table to be re-created.
Posted by: Khalid Abbas | Posted on: Sep 27, 2017