except keyword in sql server

CREATE TABLE EMP  (ID INTEGER NOT NULL,NAME VARCHAR(20) NOT NULL, CITY   VARCHAR(20) NULL)                    
                       

insert into EMP values(1,  'EMP1', 'DELHI')
insert into EMP values(2,  'EMP2', 'CHENNAI')
insert into EMP values(3,  'EMP3', 'PUNE')
insert into EMP values(4,  'EMP4', 'AGRA')
insert into EMP values(5,  'EMP5', 'CHENNAI')

CREATE TABLE CITY(ID INT IDENTITY, CITY_NAME VARCHAR(20))

insert into CITY values('CHENNAI')
SELECT CITY FROM EMP EXCEPT SELECT CITY_NAME FROM CITY

insert record in two table

create table Person

(

p_id int IDENTITY(1,1) not null primary key,

Fname varchar(50),

Lname varchar(50),

address varchar(50)

)

go



create table orders

(

o_id int IDENTITY(1,1) not null primary key,

oname varchar(50),

Qty int,

p_id int foreign key references Person(p_id),

prize Int

)

go



Create Proc Usp_Orders_Insert

(

@Param_Fname Varchar(50),

@Param_Lname Varchar(50),

@Param_Address Varchar(50),

@Param_oname Varchar(50),

@Param_Qty  Int,

@Param_prize Int

)

As

Begin

 Set Nocount On

 

 Declare @PersonID Int

 

 Begin Try

  Begin Tran 

   

  Insert Person(Fname, Lname, [address]) Values(@Param_Fname, @Param_Lname, @Param_Address)

  Select @PersonID = @@Identity 

 

  Insert orders(oname, Qty, p_id, prize) Values(@Param_oname, @Param_Qty, @PersonID, @Param_prize)

  

  Commit

   

 End Try

 Begin Catch

  Declare @Message Varchar(Max)

  Select @Message = 'Error : ' + ERROR_MESSAGE() + CHAR(10) + 'Line No: '+ Cast(ERROR_LINE() as Varchar(10))

  Raiserror(@Message,16,1)

  Rollback  

 End Catch

End

Go

Configuring Apache for ASP.NET

ASP.NET hosting with Apache

The mod_mono Apache module is used to run ASP.NET applications within the Apache web server.
The mod_mono module runs within an Apache process and passes all the requests to ASP.NET applications to an external Mono process that actually hosts your ASP.NET applications. The external ASP.NET host is called "mod-mono-server" and is part of the XSP module.
To use this, you must download and install the mod_mono and xsp components of Mono. mod_mono contains the actual Apache module, and xsp contains the actual ASP.NET hosting engine, both are available from our download page.
See the mod_mono page for details on installation and configuration.

convert image to base64

For this u need to download Html agility

protected void Page_Load(object sender, EventArgs e)
{
HtmlWeb htmlWeb = new HtmlWeb();
HtmlAgilityPack.HtmlDocument document = htmlWeb.Load("http://www.fortunehotels.in/");
foreach (HtmlNode someNode in document.DocumentNode.SelectNodes("//img[@src]"))
{
if (someNode.Attributes.Contains("src"))
{
if (someNode.Attributes["src"].Value.EndsWith(".jpg"))
{
if (someNode.Attributes["src"].Value != "admin/UploadImage/summer-packages2010717138.jpg")
{
if (someNode.Attributes["src"].Value != "admin/UploadImage/101X108201243356.jpg")
{
WebClient wc = new WebClient();
byte[] data = wc.DownloadData(someNode.Attributes["src"].Value);
string base64ImageString = ConvertBytesToBase64(data);
someNode.Attributes["src"].Value = "data:image/jpg;base64," + base64ImageString;
myImage.Src = "data:image/jpg;base64,"+base64ImageString;
}
document.Save("C:/Users/sandeep_2/Desktop/fortune.htm");
}
}
}
}
}
public string ConvertBytesToBase64(byte[] imageBytes)
{
return Convert.ToBase64String(imageBytes);
}

Calculate age in sql

DECLARE @date datetime, @tmpdate datetime, @years int, @months int, @days int SELECT @date = '09/03/1985'
--date in mm/dd/yy
SELECT @tmpdate = @date SELECT @years = DATEDIFF(yy, @tmpdate, GETDATE()) - CASE WHEN MONTH(@date) > MONTH(GETDATE()) THEN 1 ELSE 0 END SELECT @tmpdate = DATEADD(yy, @years, @tmpdate) SELECT @months = DATEDIFF(m, @tmpdate, GETDATE()) - CASE WHEN DAY(@date) > DAY(GETDATE()) THEN 1 ELSE 0 END SELECT @tmpdate = DATEADD(m, @months, @tmpdate) SELECT @days = DATEDIFF(d, @tmpdate, GETDATE()) SELECT @years AS Years, @months AS Months, @days as Days