Database

josephong wrote:

select temp,result_time from mts300_results where nodeid=5 order by result_time like '%:00:%' desc limit 10;

select top 10 temp,result_time 
from mts300_results 
where nodeid=5 
and result_time like '%:00:%' 
order by result_time desc

case when  
(TABLE_A.Field_1 + TABLE_A.Field_2) = (TABLE_B.Field_1 + TABLE_B.Field_2) 
      then 'Match'
 else 'Unmatch' end

Select
C1,
C2,
C3,
C4,
case when  (C1 + C2) = (C3 + C4) then 'Match'
 else 'Unmatch' end as Result
From 
(

	Select 
	Row,
	Max(C1) as C1,
	Max(C2) as C2,
	Max(C3) as C3 ,
	Max(C4) as C4
	From 
	(
				Select 
				ROW_NUMBER() 
						OVER (ORDER BY TABLE_A.Field_1) AS Row,
				TABLE_A.Field_1  as C1
				,TABLE_A.Field_2  as C2
				,'0' as C3
				,'0' as C4
				From 
				TABLE_A

				Union ALL

				Select 
				ROW_NUMBER() 
						OVER (ORDER BY TABLE_B.Field_1) AS Row,
				'0'  as C1
				,'0' as C2
				,TABLE_B.Field_1  as C3
				,TABLE_B.Field_2  as C4
				From 
				TABLE_B
	  )
	  as OuterTable
	  group by Row
	  
) as FinalTable

select t1.field1,t1.field2,
	t2.field1,t2.field2,
	CASE
		WHEN t2.field1 IS NOT NULL THEN 'Match' 
		ELSE 'Unmatch' 
	END
FROM Table1 t1
LEFT JOIN table2 t2		
ON t1.field1=t2.field1 AND t1.field2=t2.field2

select t1.field1,t1.field2,
	t2.field1,t2.field2,
	CASE
		WHEN t1.field1=t2.field1 AND t1.field2=t2.field2 THEN 'Match' 
                ELSE 'Unmatch' 
        END
FROM Table1 t1
CROSS JOIN table2 t2	

protected void Button1_Click(object sender, EventArgs e)
    {
            SqlConnection con = new SqlConnection();
            con.ConnectionString =  ConfigurationManager.ConnectionStrings["AdNetConnectionString"].ToString();

            Session["CampaignName"]= TexBox1.Text.ToString();
            string sql;
            sql = "insert into AdCampaign (CampaignName)values( ' " + Session["CampaignName"] + " ');
            SqlCommand cmd = new SqlCommand(sql, con);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
    }

sql = "insert into AdCampaign (CampaignName) values(@myParameter)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("myParameter", Session["CampaignName"]);

sql_Store_Sessions = "insert into AdCampaign (AccountID,AdType,SiteCategory,Language,Gender,Age,Keyword,MaxBudget,DailyBudget,CampaignName,AdHeadline,AdText,DisplayUrl,TargetUrl,BannerImg,ImgName,Date,Status)values(" + Session["SelectIdFromTableAccount"] + ",'" + Session["adType"] + "','" + Session["Category"] + "','" + Session["Language"] + "','" + Session["Gender"] + "','" + Session["Age"] + "',@AdvKeyword," + Session["MaxBudget"] + "," + Session["Daily_Budget"] + ",@CampaignName,@AdHeadLine,@AdText,@DisplayUrl,@DestinationUrl,@Banner_Img,@Img_Name,'" + DateTime.Now + "','Paused')";
           SqlCommand cmd_Store_Sessions = new SqlCommand(sql_Store_Sessions, con);
           cmd_Store_Sessions.Parameters.AddWithValue("CampaignName", Session["CampaignName"]);
           cmd_Store_Sessions.Parameters.AddWithValue("AdHeadLine", Session["AdHeadLine"]);
           cmd_Store_Sessions.Parameters.AddWithValue("AdText", Session["AdText"]);
           cmd_Store_Sessions.Parameters.AddWithValue("DisplayUrl", Session["DisplayUrl"]);
           cmd_Store_Sessions.Parameters.AddWithValue("DestinationUrl", Session["DestinationUrl"]);
           cmd_Store_Sessions.Parameters.AddWithValue("Banner_Img", Session["Banner_Img"]);
           cmd_Store_Sessions.Parameters.AddWithValue("Img_Name", Session["Img_Name"]);

           con.Open();
           cmd_Store_Sessions.ExecuteNonQuery();
           con.Close();