In this article, we are going to learn how to use Trigger in SQL.
A Trigger is a piece of procedural code, like a stored procedure or stored program that executes automatically whenever an event such as Insert, Update and Delete occurs against a table.
This article will helpful as a beginner to know what is Mongo DB and What is the difference between SQL and Mongo DB. Mongo DB Till now we are using SQL database to store data in a two dimensional row and column. Mongo DB is a No SQL Database which store data in form of…
In this article, we will learn how to connect SQL Server Management Studio to Local default instance.
SQL is a declarative language. It only specifies what data is needed. PL/SQL is a procedural language. It specifies both that what data is needed and how it can be retrieved.
In this blog, I have described the difference between Stored Procedure and Function.
In this blog, you will learn how to find columns and text in Store procedure, Functions, and Views.
In this article we learn how to convert amount to words using sql server scaler function. we create 2 functions for easy to understand and manage. In 1st function we are return only general words like (One, Two, Eleven ,Twelve etc.) & in 2nd function we create a logic for convert amount to words. lets start it.
Delete Duplicate Records In SQL Using Common Table Expression
In this article, we will learn about how we can retrieve data from serverside Paging, Sorting, and Filtering Using the Kendo UI Grid and Entity Framework in MVC ASP .NET applications.
In this article, we will learn how to create an encrypt Stored Procedure in SQL.
When you encrypt a stored procedure, the procedure’s text is converted to an obfuscated format and its definition is not visible for any users. Therefore, the procedure’s definition can not be viewed by users.
