DDL / DML / DCL / TCL / DQL Commands in SQL Server
DML – Data Manipulation Language They are SQL statements which works with Data in a database. Using them you can insert, retrieve, store, delete, modify... Read more
.Net Professionals
DML – Data Manipulation Language They are SQL statements which works with Data in a database. Using them you can insert, retrieve, store, delete, modify... Read more
It is one of the most favorite question of the Interviewers. They often asked this type of question like How to find 2nd/nth Highest salary... Read more
CREATE PROCEDURE SP1 AS BEGIN SELECT GETDATE() AS DATE END CREATE PROCEDURE SP2 AS BEGIN EXEC SP1 END CREATE PROCEDURE SP3 AS BEGIN EXEC SP1... Read more
I Assume that you have a basic idea of Transactions. If not go through What are Transactions in SQL Server first. So we can do... Read more
Table of Content : here Goto Category SQL : here Q. You have the below SQL Code in your application. Example: DECLARE @TABLE TABLE(col INT)... Read more
User Defined Functions Stored Procedure Functions must return a value Stored Procedure may or may not return values It will allow only SELECT statements, DML... Read more
In this article we will see how can we call a Function inside a Stored Procedure. You can read about Functions and Stored Procedures. First... Read more
Hello Readers today we will going to learn how to Create STORED PROCEDURE with Default Parameters. I hope you all have gone through my previous... Read more
Stored Procedures are a set of SQL Commands / statements which are stored in a compiled form. Syntax: CREATE/ALTER Procedure <Procedure-name> ( Input parameters ,... Read more
What are Functions in SQL SERVER? Functions are the objects which performs an action based on input values (input parameters) and can return only single... Read more