SQL Notes
how to List of Dates by given month and date
19/10/2012 18:04
--SELECT dbo.Fn_HowManyDays_Month('February','2012') AS [Days]
ALTER FUNCTION dbo.Fn_HowManyDays_Month
(
@Month VARCHAR(15),
@Year VARCHAR(10)
)
RETURNS INT
AS
BEGIN
DECLARE @Date VARCHAR(50),
@Days TINYINT
SELECT...
how to get count of given date name in that month
19/10/2012 18:02
--SELECT dbo.Fn_HowManyDays_Month('February','2012') AS [Days]
ALTER FUNCTION dbo.Fn_HowManyDays_Month
(
@Month VARCHAR(15),
@Year VARCHAR(10)
)
RETURNS INT
AS
BEGIN
DECLARE @Date...
How to find total no of days count in given month
19/10/2012 18:01
--SELECT dbo.Fn_HowManyDays_Month('February','2012') AS [Days]
ALTER FUNCTION dbo.Fn_HowManyDays_Month
(
@Month VARCHAR(15),
@Year VARCHAR(10)
)
RETURNS INT
AS
BEGIN
DECLARE @Date VARCHAR(50),
@Days TINYINT
SELECT...
Join Examples
12/04/2012 11:19
USE deva
GO
CREATE TABLE table1
(ID INT, Value VARCHAR(10))
INSERT INTO Table1 (ID, Value)
SELECT 1,'First'
UNION ALL
SELECT 2,'Second'
UNION ALL
SELECT 3,'Third'
UNION ALL
SELECT 4,'Fourth'
UNION ALL
SELECT 5,'Fifth'
GO
CREATE TABLE...
Joins in sql
11/04/2012 19:19
https://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/
Insert values into the table
16/06/2011 11:12
TABLE [dbo].[TRAINING] int IDENTITY(1,1) NOT NULL,varchar(50) NULL,text NULL,char(1) NULL,varchar(8) NULL CONSTRAINT [DF_TRAINING_DISPLAY_STATUS] DEFAULT ('ACTIVE'),CONSTRAINT [PK_TRAINING] PRIMARY KEY([TRAINING_ID]) TABLE [dbo].[PARENT_GUARDIAN] int IDENTITY(150,1) NOT NULL,nvarchar(25) NOT...
Trigger
24/05/2011 13:39
Create trigger T_EmpDetails on TblEmpDetails
--INSTEAD OF UPDATE,INSERT,DELETE
AFTER UPDATE,INSERT,DELETE
AS
BEGIN--[
insert dbo.TblEmpDetailsBak
...
Stored Procedure Calculation
24/05/2011 13:38
/*
Created By : Shankar Karuppanna Gounder
Created On : 16.06.2010
Mail Id : shakar_ct@yahoo.co.in
Contact ...
Transaction
24/05/2011 13:38
select *
from TblEmpDetails(nolock)
select *
from TblEmpDetails
delete from TblEmpDetails
where EmpName='mahesh'
update TblEmpDetails Set Address='Pondy' where empId='emp106'
BEGIN TRANSACTION...
Temporary Table
24/05/2011 13:37
Temporary Tables:-
-----------------
CREATE PROCEDURE TempTbl
AS
BEGIN
--drop table #EmpTemp
--drop table ##EmpTemp1
--Temporary Table
CREATE TABLE #EmpTemp
...