// Creating table and inserting some records create table email_list ( name varchar(100), email varchar(50) ) go insert into email_list values ('himanshu', 'him@gmail.com'); insert into...

I have a task to get the second biggest number using sql query. I know that we can get the biggest number using SQL very easily:...

Advantages: 1. View the data without storing the data into the object. 2. Restrict the view of a table i.e. can hide some of columns...

SQL Server offers six categories of data types for your use: Exact Numeric Data Types: DATA TYPEFROMTO bigint-9,223,372,036,854,775,8089,223,372,036,854,775,807 int-2,147,483,6482,147,483,647 smallint-32,76832,767 tinyint0255 bit01 decimal-10^38 +110^38 -1...

Stored Procedures are pre-compile objects which are compiled for first time and its compiled format is saved which executes (compiled code) whenever it is called....

Function is a database object in Sql Server. Basically it is a set of sql statements that accepts only input parameters, perform actions and return...

Last Day of Previous MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) Last Day of Current MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)) Last Day of Next MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+2,0))