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
Category: SQL
Second Highest Salary in SQL
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
How to check how many Stored Procedures had called a particular Procedure in SQL
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
SQL – Rollback a transactions to a savepoint
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
SQL – Interview Questions
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
Difference Between Functions and Stored Procedures in SQL
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
Calling a Function from Stored Procedure
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
How to create Stored Procedure with Default Values?
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 in SQL
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
Functions in SQL
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