.Net MATERIAL

how to bind database into chart control

2013-03-25T03:29:00.000-07:00

<asp:Chart ID="Chart1" runat="server" DataSourceID="SqlDataSource1">
            <Series>
                <asp:Series Name="Series1" XValueMember="EmpName" YValueMembers="EmpID">
                </asp:Series>
            </Series>
            <ChartAreas>
                <asp:ChartArea Name="ChartArea1">
                </asp:ChartArea>
            </ChartAreas>

 </asp:Chart>


<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyConnectionString %>"
            SelectCommand="SELECT top 10 [EmpName], [EmpID] FROM [tblEmployeeMaster]">
</asp:SqlDataSource>

Sql server Procedure for if Record insert first time then insert else update the table.....

2013-03-08T04:15:00.004-08:00

I have table in which I am inserting rows for employee but next time when I want to insert row I don't want to insert again data for that employee just want to update with required columns if it exits there if not then create new row....

Syntax For Procedure:

CREATE PROCEDURE dbo.InsertOrUdpateEmployee
       @ID INT,
       
AS BEGIN

IF NOT EXISTS (SELECT * FROM Employee WHERE ID = @ID)

    INSERT INTO Employee(Col1, ..., ColN)
    VALUES(Val1, .., ValN)

ELSE

    UPDATE Employee
    SET Col1 = Val1, Col2 = Val2, ...., ColN = ValN
    WHERE ID = @ID

END

Common Class

2013-02-12T23:03:00.001-08:00

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data;

using System.IO;

using System.Web.UI.WebControls;

using System.Web.UI;

using System.Configuration;

using System.Net.Mail;

using System.Data.SqlClient;

using System.Collections;

/// <summary>

/// Summary description for CommonClass

/// </summary>

public class CommonClass

{

public const string SELECTED_CUSTOMERS_INDEX = "SelectedCustomersIndex";

string ConnectionString=string.Empty;

static SqlConnection con;

public CommonClass()

{

ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

con = new SqlConnection(ConnectionString);

}

public void SetConnection()

{

if (ConnectionString == string.Empty)

{

ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

}

con = new SqlConnection(ConnectionString);

}

public DataSet ExecuteProcudere(string procName, Hashtable parms)

{

DataSet ds = new DataSet();

SqlCommand cmd = new SqlCommand();

SqlDataAdapter da = new SqlDataAdapter();

cmd.CommandText = procName;

cmd.CommandType = CommandType.StoredProcedure;

if (con == null)

{

SetConnection();

}

cmd.Connection = con;

if (parms.Count > 0)

{

foreach (DictionaryEntry de in parms)

{

cmd.Parameters.AddWithValue(de.Key.ToString(), de.Value);

}

da.SelectCommand = cmd;

da.Fill(ds);

return ds;

}

public int ExecuteQuery(string procName, Hashtable parms)

{

SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = procName;

if (parms.Count > 0)

{

foreach (DictionaryEntry de in parms)

{

cmd.Parameters.AddWithValue(de.Key.ToString(), de.Value);

}

if (con == null)

{

SetConnection();

}

cmd.Connection = con;

if (con.State == ConnectionState.Closed)

con.Open();

int result=cmd.ExecuteNonQuery();

return result;

}

public int ExecuteQuerywithOutputparams(SqlCommand cmd)

{

if (con == null)

{

SetConnection();

}

cmd.Connection = con;

if (con.State == ConnectionState.Closed)

con.Open();

int result = cmd.ExecuteNonQuery();

return result;

}

public int ExecuteQueryWithOutParam(string procName, Hashtable parms)

{

SqlCommand cmd = new SqlCommand();

SqlParameter sqlparam = new SqlParameter();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = procName;

if (parms.Count > 0)

{

foreach (DictionaryEntry de in parms)

{

if (de.Key.ToString().Contains("_out"))

{

sqlparam = new SqlParameter(de.Key.ToString(),de.Value);

sqlparam.DbType = DbType.Int32;

sqlparam.Direction = ParameterDirection.Output;

cmd.Parameters.Add(sqlparam);

}

else

{

cmd.Parameters.AddWithValue(de.Key.ToString(), de.Value);

}

if (con == null)

{

SetConnection();

}

cmd.Connection = con;

if (con.State == ConnectionState.Closed)

con.Open();

int result = cmd.ExecuteNonQuery();

if (sqlparam != null)

result = Convert.ToInt32(sqlparam.SqlValue.ToString());

return result;

}

// mail sending

public void mailsend(string mailId, string subject, string body)

{

try

{

string smtpServer = ConfigurationManager.AppSettings["SmtpServer"].ToString();

int smtpserverport = Convert.ToInt32(ConfigurationManager.AppSettings["smtpserverport"]);

MailMessage mailMsg = new MailMessage();

mailMsg.From = new System.Net.Mail.MailAddress(ConfigurationManager.AppSettings["FromId"], "HIHL-1056", System.Text.Encoding.UTF8);

mailMsg.To.Add(mailId);

mailMsg.Subject = subject;

mailMsg.Body = body;

mailMsg.BodyEncoding = System.Text.Encoding.UTF8;

mailMsg.IsBodyHtml = true;

mailMsg.Priority = System.Net.Mail.MailPriority.High;

//The SMTP requires Authentication so the credentials has to be sent

System.Net.NetworkCredential mailAuthentication = new System.Net.NetworkCredential("harish.kumar@envilenz.com", "Hareesh28");

System.Net.Mail.SmtpClient client = new System.Net.Mail.SmtpClient();

client.Port = smtpserverport;

client.Host = smtpServer;

client.EnableSsl = true;

client.UseDefaultCredentials = false;

client.Credentials = mailAuthentication;

object userState = mailMsg;

client.Send(mailMsg);

}

catch (Exception ex)

{

}

public int ExecuteNonQuery(string p, Hashtable ht)

{

throw new NotImplementedException();

}

public DataSet ExecuteProcudere(char p, Hashtable ht)

{

throw new NotImplementedException();

}

Rownum in sql server 2008 || How to find the Middle rows in sql server table

2012-12-28T03:09:00.002-08:00

SELECT * FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY Your_ColumnName) NUM,
* FROM YourTable_Name
) A
WHERE NUM >1 AND NUM <5

How to give the Alias Name with space in sql Server 2008

2012-08-27T23:37:00.001-07:00

ALTER procedure [dbo].[Inventory_Alerts]

begin

select (select Itemname from TechInventory_ItemName where Id=a.Itemname)as ‘Item Name’ ,DateDiff(dd,getdate(),TentativeAlert)as ‘Remaining Days’ from TechInventory_Create as a where TentativeAlert is not null and DateDiff(dd,getdate(),TentativeAlert)=1

end

Error converting data type nvarchar to date in asp.net

2012-08-27T23:16:00.001-07:00

protected void btnDisplay_Click(object sender, EventArgs e)

{

Hashtable ht = new Hashtable();

ArrayList arrlst = new ArrayList();

string fromdt = txtFromDate.Text.Substring(txtFromDate.Text.Length - 4) + "/" + txtFromDate.Text.Substring(3, 2) + "/" + txtFromDate.Text.Substring(0, 2);

string todt = txtTodate.Text.Substring(txtTodate.Text.Length - 4) + "/" + txtTodate.Text.Substring(3, 2) + "/" + txtTodate.Text.Substring(0, 2);

arrlst.Add(fromdt);

arrlst.Add(todt);

DataSet ds = bal.Search_InventoryDetails(arrlst);

GrdInventory.DataSource = ds.Tables[0];

GrdInventory.DataBind();

}

How To Change The Default Browser In Visual Studio

2012-08-15T23:04:00.002-07:00

Right Click On the .aspx Page And Click the Browse With... option like below

Select the Which Browser u need as a Default for open Your Application..Below is sample

Click the set as Default Button...then it will change Your Browser...

JQuery Calender Control Code....

2012-08-15T22:48:00.002-07:00

Create Page.aspx :

                       <%@ Page Title="" Language="C#" MasterPageFile="~/Main.Master"                AutoEventWireup="true" CodeBehind="Asset_Create.aspx.cs" Inherits="TechDivaWeb.Assets.Asset_Create" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
<link href="../CSS/form_css.css" rel="stylesheet" type="text/css" />
<link href="../CSS/Site.css" rel="stylesheet" type="text/css" />
    <link type="text/css" rel="stylesheet" href="../CSS/jquery-ui-1.8.21.custom.css"/>
    <link href="../CSS/jquery-ui-1.8.12.custom.css" rel="stylesheet" type="text/css" />

    <script type="text/javascript" src="../JS/jquery-ui-1.8.21.custom.min.js"></script>
    <script src="../JS/jquery-1.5.1.min.js" type="text/javascript"></script>
    <script src="../JS/jquery-ui-1.8.12.custom.min.js" type="text/javascript"></script>

    <script language="javascript" type="text/javascript">

$(function () {
            $("#txtDate").datepicker({
                dateFormat: 'dd/mm/yy',
                changeMonth: true,
                changeYear: true
            });
        });

        $(function () {
            $("#txtfrom").datepicker({
                defaultDate: "+1w",
                dateFormat: 'dd/mm/yy',
                changeMonth: true,
                changeYear: true,
                onSelect: function (selectedDate) {
                    $("#txtTo").datepicker("option", "minDate", selectedDate);
                }
            });
            $("#txtTo").datepicker({
                defaultDate: "+1w",
                dateFormat: 'dd/mm/yy',
                changeMonth: true,
                changeYear: true,
                onSelect: function (selectedDate) {
                    $("#txtfrom").datepicker("option", "maxDate", selectedDate);
                }
            });
        });

    </script>

            <asp:TextBox ID="txtDate" runat="server" ClientIDMode='Static' CssClass="textbox"></asp:TextBox>

jquery-ui-1.8.21.custom.css:

/*!
* jQuery UI CSS Framework 1.8.21
*
* Copyright 2012, AUTHORS.txt (http://jqueryui.com/about)
* Dual licensed under the MIT or GPL Version 2 licenses.
* http://jquery.org/license
*
* http://docs.jquery.com/UI/Theming/API
*/

/* Layout helpers
----------------------------------*/
.ui-helper-hidden { display: none; }
.ui-helper-hidden-accessible { position: absolute !important; clip: rect(1px 1px 1px 1px); clip: rect(1px,1px,1px,1px); }
.ui-helper-reset { margin: 0; padding: 0; border: 0; outline: 0; line-height: 1.3; text-decoration: none; font-size: 100%; list-style: none; }
.ui-helper-clearfix:before, .ui-helper-clearfix:after { content: ""; display: table; }
.ui-helper-clearfix:after { clear: both; }
.ui-helper-clearfix { zoom: 1; }
.ui-helper-zfix { width: 100%; height: 100%; top: 0; left: 0; position: absolute; opacity: 0; filter:Alpha(Opacity=0); }

/* Interaction Cues
----------------------------------*/
.ui-state-disabled { cursor: default !important; }

/* Icons
----------------------------------*/

/* states and images */
.ui-icon { display: block; text-indent: -99999px; overflow: hidden; background-repeat: no-repeat; }

/* Misc visuals
----------------------------------*/

/* Overlays */
.ui-widget-overlay { position: absolute; top: 0; left: 0; width: 100%; height: 100%; }

/*!
* jQuery UI CSS Framework 1.8.21
*
* Copyright 2012, AUTHORS.txt (http://jqueryui.com/about)
* Dual licensed under the MIT or GPL Version 2 licenses.
* http://jquery.org/license
*
* http://docs.jquery.com/UI/Theming/API
*
* To view and modify this theme, visit http://jqueryui.com/themeroller/?ffDefault=Trebuchet%20MS,%20Tahoma,%20Verdana,%20Arial,%20sans-serif&fwDefault=bold&fsDefault=1.1em&cornerRadius=4px&bgColorHeader=f6a828&bgTextureHeader=12_gloss_wave.png&bgImgOpacityHeader=35&borderColorHeader=e78f08&fcHeader=ffffff&iconColorHeader=ffffff&bgColorContent=eeeeee&bgTextureContent=03_highlight_soft.png&bgImgOpacityContent=100&borderColorContent=dddddd&fcContent=333333&iconColorContent=222222&bgColorDefault=f6f6f6&bgTextureDefault=02_glass.png&bgImgOpacityDefault=100&borderColorDefault=cccccc&fcDefault=1c94c4&iconColorDefault=ef8c08&bgColorHover=fdf5ce&bgTextureHover=02_glass.png&bgImgOpacityHover=100&borderColorHover=fbcb09&fcHover=c77405&iconColorHover=ef8c08&bgColorActive=ffffff&bgTextureActive=02_glass.png&bgImgOpacityActive=65&borderColorActive=fbd850&fcActive=eb8f00&iconColorActive=ef8c08&bgColorHighlight=ffe45c&bgTextureHighlight=03_highlight_soft.png&bgImgOpacityHighlight=75&borderColorHighlight=fed22f&fcHighlight=363636&iconColorHighlight=228ef1&bgColorError=b81900&bgTextureError=08_diagonals_thick.png&bgImgOpacityError=18&borderColorError=cd0a0a&fcError=ffffff&iconColorError=ffd27a&bgColorOverlay=666666&bgTextureOverlay=08_diagonals_thick.png&bgImgOpacityOverlay=20&opacityOverlay=50&bgColorShadow=000000&bgTextureShadow=01_flat.png&bgImgOpacityShadow=10&opacityShadow=20&thicknessShadow=5px&offsetTopShadow=-5px&offsetLeftShadow=-5px&cornerRadiusShadow=5px
*/

/* Component containers
----------------------------------*/
.ui-widget { font-family: Trebuchet MS, Tahoma, Verdana, Arial, sans-serif; font-size: 1.1em; }
.ui-widget .ui-widget { font-size: 1em; }
.ui-widget input, .ui-widget select, .ui-widget textarea, .ui-widget button { font-family: Trebuchet MS, Tahoma, Verdana, Arial, sans-serif; font-size: 1em; }
.ui-widget-content { border: 1px solid #dddddd; background: #eeeeee url(images/ui-bg_highlight-soft_100_eeeeee_1x100.png) 50% top repeat-x; color: #333333; }
.ui-widget-content a { color: #333333; }
.ui-widget-header { border: 1px solid #e78f08; background: #f6a828 url(images/ui-bg_gloss-wave_35_f6a828_500x100.png) 50% 50% repeat-x; color: #ffffff; font-weight: bold; }
.ui-widget-header a { color: #ffffff; }

/* Interaction states
----------------------------------*/
.ui-state-default, .ui-widget-content .ui-state-default, .ui-widget-header .ui-state-default { border: 1px solid #cccccc; background: #f6f6f6 url(images/ui-bg_glass_100_f6f6f6_1x400.png) 50% 50% repeat-x; font-weight: bold; color: #1c94c4; }
.ui-state-default a, .ui-state-default a:link, .ui-state-default a:visited { color: #1c94c4; text-decoration: none; }
.ui-state-hover, .ui-widget-content .ui-state-hover, .ui-widget-header .ui-state-hover, .ui-state-focus, .ui-widget-content .ui-state-focus, .ui-widget-header .ui-state-focus { border: 1px solid #fbcb09; background: #fdf5ce url(images/ui-bg_glass_100_fdf5ce_1x400.png) 50% 50% repeat-x; font-weight: bold; color: #c77405; }
.ui-state-hover a, .ui-state-hover a:hover { color: #c77405; text-decoration: none; }
.ui-state-active, .ui-widget-content .ui-state-active, .ui-widget-header .ui-state-active { border: 1px solid #fbd850; background: #ffffff url(images/ui-bg_glass_65_ffffff_1x400.png) 50% 50% repeat-x; font-weight: bold; color: #eb8f00; }
.ui-state-active a, .ui-state-active a:link, .ui-state-active a:visited { color: #eb8f00; text-decoration: none; }
.ui-widget :active { outline: none; }

/* Interaction Cues
----------------------------------*/
.ui-state-highlight, .ui-widget-content .ui-state-highlight, .ui-widget-header .ui-state-highlight {border: 1px solid #fed22f; background: #ffe45c url(images/ui-bg_highlight-soft_75_ffe45c_1x100.png) 50% top repeat-x; color: #363636; }
.ui-state-highlight a, .ui-widget-content .ui-state-highlight a,.ui-widget-header .ui-state-highlight a { color: #363636; }
.ui-state-error, .ui-widget-content .ui-state-error, .ui-widget-header .ui-state-error {border: 1px solid #cd0a0a; background: #b81900 url(images/ui-bg_diagonals-thick_18_b81900_40x40.png) 50% 50% repeat; color: #ffffff; }
.ui-state-error a, .ui-widget-content .ui-state-error a, .ui-widget-header .ui-state-error a { color: #ffffff; }
.ui-state-error-text, .ui-widget-content .ui-state-error-text, .ui-widget-header .ui-state-error-text { color: #ffffff; }
.ui-priority-primary, .ui-widget-content .ui-priority-primary, .ui-widget-header .ui-priority-primary { font-weight: bold; }
.ui-priority-secondary, .ui-widget-content .ui-priority-secondary, .ui-widget-header .ui-priority-secondary { opacity: .7; filter:Alpha(Opacity=70); font-weight: normal; }
.ui-state-disabled, .ui-widget-content .ui-state-disabled, .ui-widget-header .ui-state-disabled { opacity: .35; filter:Alpha(Opacity=35); background-image: none; }

/* Icons
----------------------------------*/

/* states and images */
.ui-icon { width: 16px; height: 16px; background-image: url(images/ui-icons_222222_256x240.png); }
.ui-widget-content .ui-icon {background-image: url(images/ui-icons_222222_256x240.png); }
.ui-widget-header .ui-icon {background-image: url(images/ui-icons_ffffff_256x240.png); }
.ui-state-default .ui-icon { background-image: url(images/ui-icons_ef8c08_256x240.png); }
.ui-state-hover .ui-icon, .ui-state-focus .ui-icon {background-image: url(images/ui-icons_ef8c08_256x240.png); }
.ui-state-active .ui-icon {background-image: url(images/ui-icons_ef8c08_256x240.png); }
.ui-state-highlight .ui-icon {background-image: url(images/ui-icons_228ef1_256x240.png); }
.ui-state-error .ui-icon, .ui-state-error-text .ui-icon {background-image: url(images/ui-icons_ffd27a_256x240.png); }

/* positioning */
.ui-icon-carat-1-n { background-position: 0 0; }
.ui-icon-carat-1-ne { background-position: -16px 0; }
.ui-icon-carat-1-e { background-position: -32px 0; }
.ui-icon-carat-1-se { background-position: -48px 0; }
.ui-icon-carat-1-s { background-position: -64px 0; }
.ui-icon-carat-1-sw { background-position: -80px 0; }
.ui-icon-carat-1-w { background-position: -96px 0; }
.ui-icon-carat-1-nw { background-position: -112px 0; }
.ui-icon-carat-2-n-s { background-position: -128px 0; }
.ui-icon-carat-2-e-w { background-position: -144px 0; }
.ui-icon-triangle-1-n { background-position: 0 -16px; }
.ui-icon-triangle-1-ne { background-position: -16px -16px; }
.ui-icon-triangle-1-e { background-position: -32px -16px; }
.ui-icon-triangle-1-se { background-position: -48px -16px; }
.ui-icon-triangle-1-s { background-position: -64px -16px; }
.ui-icon-triangle-1-sw { background-position: -80px -16px; }
.ui-icon-triangle-1-w { background-position: -96px -16px; }
.ui-icon-triangle-1-nw { background-position: -112px -16px; }
.ui-icon-triangle-2-n-s { background-position: -128px -16px; }
.ui-icon-triangle-2-e-w { background-position: -144px -16px; }
.ui-icon-arrow-1-n { background-position: 0 -32px; }
.ui-icon-arrow-1-ne { background-position: -16px -32px; }
.ui-icon-arrow-1-e { background-position: -32px -32px; }
.ui-icon-arrow-1-se { background-position: -48px -32px; }
.ui-icon-arrow-1-s { background-position: -64px -32px; }
.ui-icon-arrow-1-sw { background-position: -80px -32px; }
.ui-icon-arrow-1-w { background-position: -96px -32px; }
.ui-icon-arrow-1-nw { background-position: -112px -32px; }
.ui-icon-arrow-2-n-s { background-position: -128px -32px; }
.ui-icon-arrow-2-ne-sw { background-position: -144px -32px; }
.ui-icon-arrow-2-e-w { background-position: -160px -32px; }
.ui-icon-arrow-2-se-nw { background-position: -176px -32px; }
.ui-icon-arrowstop-1-n { background-position: -192px -32px; }
.ui-icon-arrowstop-1-e { background-position: -208px -32px; }
.ui-icon-arrowstop-1-s { background-position: -224px -32px; }
.ui-icon-arrowstop-1-w { background-position: -240px -32px; }
.ui-icon-arrowthick-1-n { background-position: 0 -48px; }
.ui-icon-arrowthick-1-ne { background-position: -16px -48px; }
.ui-icon-arrowthick-1-e { background-position: -32px -48px; }
.ui-icon-arrowthick-1-se { background-position: -48px -48px; }
.ui-icon-arrowthick-1-s { background-position: -64px -48px; }
.ui-icon-arrowthick-1-sw { background-position: -80px -48px; }
.ui-icon-arrowthick-1-w { background-position: -96px -48px; }
.ui-icon-arrowthick-1-nw { background-position: -112px -48px; }
.ui-icon-arrowthick-2-n-s { background-position: -128px -48px; }
.ui-icon-arrowthick-2-ne-sw { background-position: -144px -48px; }
.ui-icon-arrowthick-2-e-w { background-position: -160px -48px; }
.ui-icon-arrowthick-2-se-nw { background-position: -176px -48px; }
.ui-icon-arrowthickstop-1-n { background-position: -192px -48px; }
.ui-icon-arrowthickstop-1-e { background-position: -208px -48px; }
.ui-icon-arrowthickstop-1-s { background-position: -224px -48px; }
.ui-icon-arrowthickstop-1-w { background-position: -240px -48px; }
.ui-icon-arrowreturnthick-1-w { background-position: 0 -64px; }
.ui-icon-arrowreturnthick-1-n { background-position: -16px -64px; }
.ui-icon-arrowreturnthick-1-e { background-position: -32px -64px; }
.ui-icon-arrowreturnthick-1-s { background-position: -48px -64px; }
.ui-icon-arrowreturn-1-w { background-position: -64px -64px; }
.ui-icon-arrowreturn-1-n { background-position: -80px -64px; }
.ui-icon-arrowreturn-1-e { background-position: -96px -64px; }
.ui-icon-arrowreturn-1-s { background-position: -112px -64px; }
.ui-icon-arrowrefresh-1-w { background-position: -128px -64px; }
.ui-icon-arrowrefresh-1-n { background-position: -144px -64px; }
.ui-icon-arrowrefresh-1-e { background-position: -160px -64px; }
.ui-icon-arrowrefresh-1-s { background-position: -176px -64px; }
.ui-icon-arrow-4 { background-position: 0 -80px; }
.ui-icon-arrow-4-diag { background-position: -16px -80px; }
.ui-icon-extlink { background-position: -32px -80px; }
.ui-icon-newwin { background-position: -48px -80px; }
.ui-icon-refresh { background-position: -64px -80px; }
.ui-icon-shuffle { background-position: -80px -80px; }
.ui-icon-transfer-e-w { background-position: -96px -80px; }
.ui-icon-transferthick-e-w { background-position: -112px -80px; }
.ui-icon-folder-collapsed { background-position: 0 -96px; }
.ui-icon-folder-open { background-position: -16px -96px; }
.ui-icon-document { background-position: -32px -96px; }
.ui-icon-document-b { background-position: -48px -96px; }
.ui-icon-note { background-position: -64px -96px; }
.ui-icon-mail-closed { background-position: -80px -96px; }
.ui-icon-mail-open { background-position: -96px -96px; }
.ui-icon-suitcase { background-position: -112px -96px; }
.ui-icon-comment { background-position: -128px -96px; }
.ui-icon-person { background-position: -144px -96px; }
.ui-icon-print { background-position: -160px -96px; }
.ui-icon-trash { background-position: -176px -96px; }
.ui-icon-locked { background-position: -192px -96px; }
.ui-icon-unlocked { background-position: -208px -96px; }
.ui-icon-bookmark { background-position: -224px -96px; }
.ui-icon-tag { background-position: -240px -96px; }
.ui-icon-home { background-position: 0 -112px; }
.ui-icon-flag { background-position: -16px -112px; }
.ui-icon-calendar { background-position: -32px -112px; }
.ui-icon-cart { background-position: -48px -112px; }
.ui-icon-pencil { background-position: -64px -112px; }
.ui-icon-clock { background-position: -80px -112px; }
.ui-icon-disk { background-position: -96px -112px; }
.ui-icon-calculator { background-position: -112px -112px; }
.ui-icon-zoomin { background-position: -128px -112px; }
.ui-icon-zoomout { background-position: -144px -112px; }
.ui-icon-search { background-position: -160px -112px; }
.ui-icon-wrench { background-position: -176px -112px; }
.ui-icon-gear { background-position: -192px -112px; }
.ui-icon-heart { background-position: -208px -112px; }
.ui-icon-star { background-position: -224px -112px; }
.ui-icon-link { background-position: -240px -112px; }
.ui-icon-cancel { background-position: 0 -128px; }
.ui-icon-plus { background-position: -16px -128px; }
.ui-icon-plusthick { background-position: -32px -128px; }
.ui-icon-minus { background-position: -48px -128px; }
.ui-icon-minusthick { background-position: -64px -128px; }
.ui-icon-close { background-position: -80px -128px; }
.ui-icon-closethick { background-position: -96px -128px; }
.ui-icon-key { background-position: -112px -128px; }
.ui-icon-lightbulb { background-position: -128px -128px; }
.ui-icon-scissors { background-position: -144px -128px; }
.ui-icon-clipboard { background-position: -160px -128px; }
.ui-icon-copy { background-position: -176px -128px; }
.ui-icon-contact { background-position: -192px -128px; }
.ui-icon-image { background-position: -208px -128px; }
.ui-icon-video { background-position: -224px -128px; }
.ui-icon-script { background-position: -240px -128px; }
.ui-icon-alert { background-position: 0 -144px; }
.ui-icon-info { background-position: -16px -144px; }
.ui-icon-notice { background-position: -32px -144px; }
.ui-icon-help { background-position: -48px -144px; }
.ui-icon-check { background-position: -64px -144px; }
.ui-icon-bullet { background-position: -80px -144px; }
.ui-icon-radio-off { background-position: -96px -144px; }
.ui-icon-radio-on { background-position: -112px -144px; }
.ui-icon-pin-w { background-position: -128px -144px; }
.ui-icon-pin-s { background-position: -144px -144px; }
.ui-icon-play { background-position: 0 -160px; }
.ui-icon-pause { background-position: -16px -160px; }
.ui-icon-seek-next { background-position: -32px -160px; }
.ui-icon-seek-prev { background-position: -48px -160px; }
.ui-icon-seek-end { background-position: -64px -160px; }
.ui-icon-seek-start { background-position: -80px -160px; }
/* ui-icon-seek-first is deprecated, use ui-icon-seek-start instead */
.ui-icon-seek-first { background-position: -80px -160px; }
.ui-icon-stop { background-position: -96px -160px; }
.ui-icon-eject { background-position: -112px -160px; }
.ui-icon-volume-off { background-position: -128px -160px; }
.ui-icon-volume-on { background-position: -144px -160px; }
.ui-icon-power { background-position: 0 -176px; }
.ui-icon-signal-diag { background-position: -16px -176px; }
.ui-icon-signal { background-position: -32px -176px; }
.ui-icon-battery-0 { background-position: -48px -176px; }
.ui-icon-battery-1 { background-position: -64px -176px; }
.ui-icon-battery-2 { background-position: -80px -176px; }
.ui-icon-battery-3 { background-position: -96px -176px; }
.ui-icon-circle-plus { background-position: 0 -192px; }
.ui-icon-circle-minus { background-position: -16px -192px; }
.ui-icon-circle-close { background-position: -32px -192px; }
.ui-icon-circle-triangle-e { background-position: -48px -192px; }
.ui-icon-circle-triangle-s { background-position: -64px -192px; }
.ui-icon-circle-triangle-w { background-position: -80px -192px; }
.ui-icon-circle-triangle-n { background-position: -96px -192px; }
.ui-icon-circle-arrow-e { background-position: -112px -192px; }
.ui-icon-circle-arrow-s { background-position: -128px -192px; }
.ui-icon-circle-arrow-w { background-position: -144px -192px; }
.ui-icon-circle-arrow-n { background-position: -160px -192px; }
.ui-icon-circle-zoomin { background-position: -176px -192px; }
.ui-icon-circle-zoomout { background-position: -192px -192px; }
.ui-icon-circle-check { background-position: -208px -192px; }
.ui-icon-circlesmall-plus { background-position: 0 -208px; }
.ui-icon-circlesmall-minus { background-position: -16px -208px; }
.ui-icon-circlesmall-close { background-position: -32px -208px; }
.ui-icon-squaresmall-plus { background-position: -48px -208px; }
.ui-icon-squaresmall-minus { background-position: -64px -208px; }
.ui-icon-squaresmall-close { background-position: -80px -208px; }
.ui-icon-grip-dotted-vertical { background-position: 0 -224px; }
.ui-icon-grip-dotted-horizontal { background-position: -16px -224px; }
.ui-icon-grip-solid-vertical { background-position: -32px -224px; }
.ui-icon-grip-solid-horizontal { background-position: -48px -224px; }
.ui-icon-gripsmall-diagonal-se { background-position: -64px -224px; }
.ui-icon-grip-diagonal-se { background-position: -80px -224px; }

/* Misc visuals
----------------------------------*/

/* Corner radius */
.ui-corner-all, .ui-corner-top, .ui-corner-left, .ui-corner-tl { -moz-border-radius-topleft: 4px; -webkit-border-top-left-radius: 4px; -khtml-border-top-left-radius: 4px; border-top-left-radius: 4px; }
.ui-corner-all, .ui-corner-top, .ui-corner-right, .ui-corner-tr { -moz-border-radius-topright: 4px; -webkit-border-top-right-radius: 4px; -khtml-border-top-right-radius: 4px; border-top-right-radius: 4px; }
.ui-corner-all, .ui-corner-bottom, .ui-corner-left, .ui-corner-bl { -moz-border-radius-bottomleft: 4px; -webkit-border-bottom-left-radius: 4px; -khtml-border-bottom-left-radius: 4px; border-bottom-left-radius: 4px; }
.ui-corner-all, .ui-corner-bottom, .ui-corner-right, .ui-corner-br { -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 4px; -khtml-border-bottom-right-radius: 4px; border-bottom-right-radius: 4px; }

/* Overlays */
.ui-widget-overlay { background: #666666 url(images/ui-bg_diagonals-thick_20_666666_40x40.png) 50% 50% repeat; opacity: .50;filter:Alpha(Opacity=50); }
.ui-widget-shadow { margin: -5px 0 0 -5px; padding: 5px; background: #000000 url(images/ui-bg_flat_10_000000_40x100.png) 50% 50% repeat-x; opacity: .20;filter:Alpha(Opacity=20); -moz-border-radius: 5px; -khtml-border-radius: 5px; -webkit-border-radius: 5px; border-radius: 5px; }/*!
* jQuery UI Resizable 1.8.21
*
* Copyright 2012, AUTHORS.txt (http://jqueryui.com/about)
* Dual licensed under the MIT or GPL Version 2 licenses.
* http://jquery.org/license
*
* http://docs.jquery.com/UI/Resizable#theming
*/
.ui-resizable { position: relative;}
.ui-resizable-handle { position: absolute;font-size: 0.1px; display: block; }
.ui-resizable-disabled .ui-resizable-handle, .ui-resizable-autohide .ui-resizable-handle { display: none; }
.ui-resizable-n { cursor: n-resize; height: 7px; width: 100%; top: -5px; left: 0; }
.ui-resizable-s { cursor: s-resize; height: 7px; width: 100%; bottom: -5px; left: 0; }
.ui-resizable-e { cursor: e-resize; width: 7px; right: -5px; top: 0; height: 100%; }
.ui-resizable-w { cursor: w-resize; width: 7px; left: -5px; top: 0; height: 100%; }
.ui-resizable-se { cursor: se-resize; width: 12px; height: 12px; right: 1px; bottom: 1px; }
.ui-resizable-sw { cursor: sw-resize; width: 9px; height: 9px; left: -5px; bottom: -5px; }
.ui-resizable-nw { cursor: nw-resize; width: 9px; height: 9px; left: -5px; top: -5px; }
.ui-resizable-ne { cursor: ne-resize; width: 9px; height: 9px; right: -5px; top: -5px;}/*!
* jQuery UI Selectable 1.8.21
*
* Copyright 2012, AUTHORS.txt (http://jqueryui.com/about)
* Dual licensed under the MIT or GPL Version 2 licenses.
* http://jquery.org/license
*
* http://docs.jquery.com/UI/Selectable#theming
*/
.ui-selectable-helper { position: absolute; z-index: 100; border:1px dotted black; }
/*!
* jQuery UI Accordion 1.8.21
*
* Copyright 2012, AUTHORS.txt (http://jqueryui.com/about)
* Dual licensed under the MIT or GPL Version 2 licenses.
* http://jquery.org/license
*
* http://docs.jquery.com/UI/Accordion#theming
*/
/* IE/Win - Fix animation bug - #4615 */
.ui-accordion { width: 100%; }
.ui-accordion .ui-accordion-header { cursor: pointer; position: relative; margin-top: 1px; zoom: 1; }
.ui-accordion .ui-accordion-li-fix { display: inline; }
.ui-accordion .ui-accordion-header-active { border-bottom: 0 !important; }
.ui-accordion .ui-accordion-header a { display: block; font-size: 1em; padding: .5em .5em .5em .7em; }
.ui-accordion-icons .ui-accordion-header a { padding-left: 2.2em; }
.ui-accordion .ui-accordion-header .ui-icon { position: absolute; left: .5em; top: 50%; margin-top: -8px; }
.ui-accordion .ui-accordion-content { padding: 1em 2.2em; border-top: 0; margin-top: -2px; position: relative; top: 1px; margin-bottom: 2px; overflow: auto; display: none; zoom: 1; }
.ui-accordion .ui-accordion-content-active { display: block; }
/*!
* jQuery UI Autocomplete 1.8.21
*
* Copyright 2012, AUTHORS.txt (http://jqueryui.com/about)
* Dual licensed under the MIT or GPL Version 2 licenses.
* http://jquery.org/license
*
* http://docs.jquery.com/UI/Autocomplete#theming
*/
.ui-autocomplete { position: absolute; cursor: default; }

/* workarounds */
* html .ui-autocomplete { width:1px; } /* without this, the menu expands to 100% in IE6 */

/*
* jQuery UI Menu 1.8.21
*
* Copyright 2010, AUTHORS.txt (http://jqueryui.com/about)
* Dual licensed under the MIT or GPL Version 2 licenses.
* http://jquery.org/license
*
* http://docs.jquery.com/UI/Menu#theming
*/
.ui-menu {
    list-style:none;
    padding: 2px;
    margin: 0;
    display:block;
    float: left;
}
.ui-menu .ui-menu {
    margin-top: -3px;
}
.ui-menu .ui-menu-item {
    margin:0;
    padding: 0;
    zoom: 1;
    float: left;
    clear: left;
    width: 100%;
}
.ui-menu .ui-menu-item a {
    text-decoration:none;
    display:block;
    padding:.2em .4em;
    line-height:1.5;
    zoom:1;
}
.ui-menu .ui-menu-item a.ui-state-hover,
.ui-menu .ui-menu-item a.ui-state-active {
    font-weight: normal;
    margin: -1px;
}
/*!
* jQuery UI Button 1.8.21
*
* Copyright 2012, AUTHORS.txt (http://jqueryui.com/about)
* Dual licensed under the MIT or GPL Version 2 licenses.
* http://jquery.org/license
*
* http://docs.jquery.com/UI/Button#theming
*/
.ui-button { display: inline-block; position: relative; padding: 0; margin-right: .1em; text-decoration: none !important; cursor: pointer; text-align: center; zoom: 1; overflow: visible; } /* the overflow property removes extra width in IE */
.ui-button-icon-only { width: 2.2em; } /* to make room for the icon, a width needs to be set here */
button.ui-button-icon-only { width: 2.4em; } /* button elements seem to need a little more width */
.ui-button-icons-only { width: 3.4em; }
button.ui-button-icons-only { width: 3.7em; }

/*button text element */
.ui-button .ui-button-text { display: block; line-height: 1.4; }
.ui-button-text-only .ui-button-text { padding: .4em 1em; }
.ui-button-icon-only .ui-button-text, .ui-button-icons-only .ui-button-text { padding: .4em; text-indent: -9999999px; }
.ui-button-text-icon-primary .ui-button-text, .ui-button-text-icons .ui-button-text { padding: .4em 1em .4em 2.1em; }
.ui-button-text-icon-secondary .ui-button-text, .ui-button-text-icons .ui-button-text { padding: .4em 2.1em .4em 1em; }
.ui-button-text-icons .ui-button-text { padding-left: 2.1em; padding-right: 2.1em; }
/* no icon support for input elements, provide padding by default */
input.ui-button { padding: .4em 1em; }

/*button icon element(s) */
.ui-button-icon-only .ui-icon, .ui-button-text-icon-primary .ui-icon, .ui-button-text-icon-secondary .ui-icon, .ui-button-text-icons .ui-icon, .ui-button-icons-only .ui-icon { position: absolute; top: 50%; margin-top: -8px; }
.ui-button-icon-only .ui-icon { left: 50%; margin-left: -8px; }
.ui-button-text-icon-primary .ui-button-icon-primary, .ui-button-text-icons .ui-button-icon-primary, .ui-button-icons-only .ui-button-icon-primary { left: .5em; }
.ui-button-text-icon-secondary .ui-button-icon-secondary, .ui-button-text-icons .ui-button-icon-secondary, .ui-button-icons-only .ui-button-icon-secondary { right: .5em; }
.ui-button-text-icons .ui-button-icon-secondary, .ui-button-icons-only .ui-button-icon-secondary { right: .5em; }

/*button sets*/
.ui-buttonset { margin-right: 7px; }
.ui-buttonset .ui-button { margin-left: 0; margin-right: -.3em; }

/* workarounds */
button.ui-button::-moz-focus-inner { border: 0; padding: 0; } /* reset extra padding in Firefox */
/*!
* jQuery UI Dialog 1.8.21
*
* Copyright 2012, AUTHORS.txt (http://jqueryui.com/about)
* Dual licensed under the MIT or GPL Version 2 licenses.
* http://jquery.org/license
*
* http://docs.jquery.com/UI/Dialog#theming
*/
.ui-dialog { position: absolute; padding: .2em; width: 300px; overflow: hidden; }
.ui-dialog .ui-dialog-titlebar { padding: .4em 1em; position: relative; }
.ui-dialog .ui-dialog-title { float: left; margin: .1em 16px .1em 0; }
.ui-dialog .ui-dialog-titlebar-close { position: absolute; right: .3em; top: 50%; width: 19px; margin: -10px 0 0 0; padding: 1px; height: 18px; }
.ui-dialog .ui-dialog-titlebar-close span { display: block; margin: 1px; }
.ui-dialog .ui-dialog-titlebar-close:hover, .ui-dialog .ui-dialog-titlebar-close:focus { padding: 0; }
.ui-dialog .ui-dialog-content { position: relative; border: 0; padding: .5em 1em; background: none; overflow: auto; zoom: 1; }
.ui-dialog .ui-dialog-buttonpane { text-align: left; border-width: 1px 0 0 0; background-image: none; margin: .5em 0 0 0; padding: .3em 1em .5em .4em; }
.ui-dialog .ui-dialog-buttonpane .ui-dialog-buttonset { float: right; }
.ui-dialog .ui-dialog-buttonpane button { margin: .5em .4em .5em 0; cursor: pointer; }
.ui-dialog .ui-resizable-se { width: 14px; height: 14px; right: 3px; bottom: 3px; }
.ui-draggable .ui-dialog-titlebar { cursor: move; }
/*!
* jQuery UI Slider 1.8.21
*
* Copyright 2012, AUTHORS.txt (http://jqueryui.com/about)
* Dual licensed under the MIT or GPL Version 2 licenses.
* http://jquery.org/license
*
* http://docs.jquery.com/UI/Slider#theming
*/
.ui-slider { position: relative; text-align: left; }
.ui-slider .ui-slider-handle { position: absolute; z-index: 2; width: 1.2em; height: 1.2em; cursor: default; }
.ui-slider .ui-slider-range { position: absolute; z-index: 1; font-size: .7em; display: block; border: 0; background-position: 0 0; }

.ui-slider-horizontal { height: .8em; }
.ui-slider-horizontal .ui-slider-handle { top: -.3em; margin-left: -.6em; }
.ui-slider-horizontal .ui-slider-range { top: 0; height: 100%; }
.ui-slider-horizontal .ui-slider-range-min { left: 0; }
.ui-slider-horizontal .ui-slider-range-max { right: 0; }

.ui-slider-vertical { width: .8em; height: 100px; }
.ui-slider-vertical .ui-slider-handle { left: -.3em; margin-left: 0; margin-bottom: -.6em; }
.ui-slider-vertical .ui-slider-range { left: 0; width: 100%; }
.ui-slider-vertical .ui-slider-range-min { bottom: 0; }
.ui-slider-vertical .ui-slider-range-max { top: 0; }/*!
* jQuery UI Tabs 1.8.21
*
* Copyright 2012, AUTHORS.txt (http://jqueryui.com/about)
* Dual licensed under the MIT or GPL Version 2 licenses.
* http://jquery.org/license
*
* http://docs.jquery.com/UI/Tabs#theming
*/
.ui-tabs { position: relative; padding: .2em; zoom: 1; } /* position: relative prevents IE scroll bug (element with position: relative inside container with overflow: auto appear as "fixed") */
.ui-tabs .ui-tabs-nav { margin: 0; padding: .2em .2em 0; }
.ui-tabs .ui-tabs-nav li { list-style: none; float: left; position: relative; top: 1px; margin: 0 .2em 1px 0; border-bottom: 0 !important; padding: 0; white-space: nowrap; }
.ui-tabs .ui-tabs-nav li a { float: left; padding: .5em 1em; text-decoration: none; }
.ui-tabs .ui-tabs-nav li.ui-tabs-selected { margin-bottom: 0; padding-bottom: 1px; }
.ui-tabs .ui-tabs-nav li.ui-tabs-selected a, .ui-tabs .ui-tabs-nav li.ui-state-disabled a, .ui-tabs .ui-tabs-nav li.ui-state-processing a { cursor: text; }
.ui-tabs .ui-tabs-nav li a, .ui-tabs.ui-tabs-collapsible .ui-tabs-nav li.ui-tabs-selected a { cursor: pointer; } /* first selector in group seems obsolete, but required to overcome bug in Opera applying cursor: text overall if defined elsewhere... */
.ui-tabs .ui-tabs-panel { display: block; border-width: 0; padding: 1em 1.4em; background: none; }
.ui-tabs .ui-tabs-hide { display: none !important; }
/*!
* jQuery UI Datepicker 1.8.21
*
* Copyright 2012, AUTHORS.txt (http://jqueryui.com/about)
* Dual licensed under the MIT or GPL Version 2 licenses.
* http://jquery.org/license
*
* http://docs.jquery.com/UI/Datepicker#theming
*/
.ui-datepicker { width:1px; }
.ui-datepicker .ui-datepicker-next-hover { right:1px; }
.ui-datepicker .ui-datepicker-prev span, .ui-datepicker .ui-datepicker-next span { display: block; position: absolute; left: 50%; margin-left: -8px; top: 50%; margin-top: -8px; }
.ui-datepicker .ui-datepicker-title { margin: 0 2.3em; line-height: 1.8em; text-align: center; }
.ui-datepicker .ui-datepicker-title select { font-size:1em; margin:1px 0; }
.ui-datepicker select.ui-datepicker-month-year {width: 100%;}
.ui-datepicker select.ui-datepicker-month,
.ui-datepicker select.ui-datepicker-year { width: 35%;}
.ui-datepicker table {width: 40%; font-size: .9em; border-collapse: collapse; margin:0 0 .4em; }
.ui-datepicker th { padding: .7em .3em; text-align: center; font-weight: bold; border: 0; }
.ui-datepicker td { border: 0; padding: 1px; }
.ui-datepicker td span, .ui-datepicker td a { display: block; padding: .2em; text-align: right; text-decoration: none; }
.ui-datepicker .ui-datepicker-buttonpane { background-image: none; margin: .7em 0 0 0; padding:0 .2em; border-left: 0; border-right: 0; border-bottom: 0; }
.ui-datepicker .ui-datepick%; font-size: .9em; border-collapse: collapse; margin:0 0 .4em; }
.ui-datepicker th { padding: .7em .3em; text-align: center; font-weight: bold; border: 0; }
.ui-datepicker td { border: 0; padding: 1px; }
.ui-datepicker td span, .ui-datepicker td a { display: block; padding: .2em; text-align: right; text-decoration: none; }
.ui-datepicker .ui-datepicker-buttonpane { background-image: none; margin: .7em 0 0 0; padding:0 .2em; border-left: 0; border-right: 0; border-bottom: 0; }
.ui-datepicker .ui-datepicker-buttonpane button { float: right; margin: .5em .2em .4em; cursor: pointer; padding: .2em .6em .3em .6em; width:auto; overflow:visible; }
.ui-datepicker .ui-datepicker-buttonpane button.ui-datepicker-current { float:left; }

/* with multiple calendars */
.ui-datepicker.ui-datepicker-multi { width:auto; }
.ui-datepicker-multi .ui-datepicker-group { float:left; }
.ui-datepicker-multi .ui-datepicker-group table { width:95%; margin:0 auto .4em; }
.ui-datepicker-multi-2 .ui-datepicker-group { width:50%; }
.ui-datepicker-multi-3 .ui-datepicker-group { width:33.3%; }
.ui-datepicker-multi-4 .ui-datepicker-group { width:25%; }
.ui-datepicker-multi .ui-datepicker-group-last .ui-datepicker-header { border-left-width:0; }
.ui-datepicker-multi .ui-datepicker-group-middle .ui-datepicker-header { border-left-width:0; }
.ui-datepicker-multi .ui-datepicker-buttonpane { clear:left; }
.ui-datepicker-row-break { clear:both; width:100%; font-size:0em; }

/* RTL support */
.ui-datepicker-rtl { direction: rtl; }
.ui-datepicker-rtl .ui-datepicker-prev { right: 2px; left: auto; }
.ui-datepicker-rtl .ui-datepicker-next { left: 2px; right: auto; }
.ui-datepicker-rtl .ui-datepicker-prev:hover { right: 1px; left: auto; }
.ui-datepicker-rtl .ui-datepicker-next:hover { left: 1px; right: auto; }
.ui-datepicker-rtl .ui-datepicker-buttonpane { clear:right; }
.ui-datepicker-rtl .ui-datepicker-buttonpane button { float: left; }
.ui-datepicker-rtl .ui-datepicker-buttonpane button.ui-datepicker-current { float:right; }
.ui-datepicker-rtl .ui-datepicker-group { float:right; }
.ui-datepicker-rtl .ui-datepicker-group-last .ui-datepicker-header { border-right-width:0; border-left-width:1px; }
.ui-datepicker-rtl .ui-datepicker-group-middle .ui-datepicker-header { border-right-width:0; border-left-width:1px; }

/* IE6 IFRAME FIX (taken from datepicker 1.5.3 */
.ui-datepicker-cover {
    display: none; /*sorry for IE5*/
    display/**/: block; /*sorry for IE5*/
    position: absolute; /*must have*/
    z-index: -1; /*must have*/
    filter: mask(); /*must have*/
    top: -4px; /*must have*/
    left: -4px; /*must have*/
    width: 200px; /*must have*/
    height: 200px; /*must have*/
}/*!
* jQuery UI Progressbar 1.8.21
*
* Copyright 2012, AUTHORS.txt (http://jqueryui.com/about)
* Dual licensed under the MIT or GPL Version 2 licenses.
* http://jquery.org/license
*
* http://docs.jquery.com/UI/Progressbar#theming
*/
.ui-progressbar { height:2em; text-align: left; overflow: hidden; }
.ui-progressbar .ui-progressbar-value {margin: -1px; height:100%; }

Out-Put :

How to insert multiple records in sql server 2008

2012-06-15T01:54:00.002-07:00

        By using Insert statement we can insert multiple records

at a time in a single query in sql server 2008.In the i am

creating a table with the name sample and insert the three records

in a single statement.

      Create TABLE sample

        (
          ID INT NOT NULL PRIMARY KEY,
          Name VARCHAR(100) NOT NULL

Inserting the Multiple Records bu using single statement :


      INSERT INTO sample (ID, Name)
        VALUES (2415, 'rajesh'),

        (1402, 'kumar'),

       (1432, 'happy')

Create stored procedure in sql server 2008

2012-06-07T23:16:00.004-07:00

Stored procedure :

A stored procedure is a precompile or already written sql statement that can be saved in database. By using this procedure we can use a single statement in more times (like code reusability in c++) just calling that procedure name where ever you want.

Stored procedures had created after Creating the table. Stored procedures are used for insert and update delete ,select the records from the table. The most advantage of writing these stored procedure is no need to write the sql query every time if we use one query five times in different places just call this procedure . by using this the length of the code will be reduced and the execution process will be increased.

Syntax for stored procedure:

Create procedure procedure_name

Begin

-------- SELECT or DELETE SQL STATEMENT-------

end

There are two types of stored procedures with and without parameter. The above syntax is without parameter and it is simple insert procedure.

How to execute procedure in sql server 2008:

By using ‘exec’ Command we can Execute the stored procedure.

Ex: Exec Procedure_Name

Stored procedure Example with parameters :

Create procedure ActivityInsert

(

@Type varchar(50),

@EmpId varchar(50),

@Category varchar(10),

@Outline Varchar(200),

@Narration Varchar(MAX),

@Remarks Varchar(200),

@Checked Varchar(50),

@Verified Varchar(50),

@Date date

)

begin

if(@Type='Insert')

begin

insert into ActivityReport(EmpId,Category,Outline,Narration,Remarks,Checked,Verified,Date,CreatedDate)

values(

@EmpId,

@Category,

@Outline,

@Narration,

@Remarks,

@Checked,

@Verified,

@Date,

GETDATE())

end

else

begin

update ActivityReport set Category=@Category,Outline=@Outline,Narration=@Narration,Remarks=@Remarks,Checked=@Checked,Verified=@Verified,Date=@Date,ModifiedDate=GETDATE() where EmpId=@EmpId

end

In the above procedure “ActivityInsert” is the Name of the procedure and "ActivityReport" is the table Name. In the Example is the Combination of INSERT and UPDATE procedure in single Procedure.

Start Date Greater Than End Date Validation in Jquery

2012-04-12T02:56:00.000-07:00

function ValidateDate(CtrlSDate,CtrlEDate)
    {
    var SDate = document.getElementById(CtrlSDate).value;     
    var EDate =  document.getElementById(CtrlEDate).value;
       
          
    var alertReason1 =  'End Date must be greater than or equal to  Start Date.' 
    var alertReason2 =  'End Date can not be less than Current Date.';
 
    var endDate = new Date(EDate);     
    var startDate= new Date(SDate);
     
       if(SDate != '' && EDate != '' && startDate > endDate)
    {
     alert(alertReason1);
     document.getElementById(CtrlEDate).value = "";
     return false;
    }
    else if(SDate == '') 
    {
        alert("Please enter Start Date");
        return false;
    }
else if(EDate == '') 
    {
        alert("Please enter End Date");
        return false;
    }     
}

How to Blinking the Text in Windows Form Applications

2012-04-12T02:02:00.001-07:00

1. Open the Visual Studio 2010-->File -->New-->Project-->Select Windows Form Application -->ClickOK

2. From the Tool Box Take one Label And one Timer Control.

3. Change the Timer and Label Names.

4. Then Write the Below Code in Form1.CS File

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

namespace WindowsFormsApplication4

{

public partial class Form1 : Form

{

private const int _blinkFrequency = 250;

private const int _maxNumberOfBlinks = 1000;

private int _blinkCount = 0;

public Form1()

{

InitializeComponent();

timer1.Interval = _blinkFrequency; //optional: set in design code

label1.Text = "Welcome";

timer1.Start();

}

private void timer1_Tick(object sender, EventArgs e)

{

this.label1.Visible = !this.label1.Visible;

_blinkCount++;

if (_blinkCount == _maxNumberOfBlinks * 2)

{

timer1.Stop();

label1.Visible = true;

}

5. After The Writing Code We Can Get output like This Below:

How to Use Marquee in WIndows Form Applications

2012-04-12T01:55:00.001-07:00

1. Open the Visual Studio 2010-->File -->New-->Project-->Select Windows Form Application -->ClickOK

2. From the Tool Box Take one Label And one Timer Control.

3. Change the Timer and Label Names

4. Then Write the Below Code in Form1.CS File.

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

namespace WindowsFormsApplication5

{

public partial class Form1 : Form

{

private int xPos = 0, YPos = 0;

public Form1()

{

InitializeComponent();

}

private void timer1_Tick(object sender, EventArgs e)

{

if (xPos == 0)

{

this.lblText.Location = new System.Drawing.Point(this.Width, YPos);

xPos = this.Width;

}

else

{

this.lblText.Location = new System.Drawing.Point(xPos, YPos);

xPos -= 2;

}

private void Form1_Load(object sender, EventArgs e)

{

lblText.Text = "Hello this is marquee text";

xPos = lblText.Location.X;

YPos = lblText.Location.Y;

timer1.Start();

}

5. After The Writing Code We Can Get output like This Below:

What is the Difference Between Aspx and Ascx page

2012-03-28T07:31:00.000-07:00

The .aspx is the actual page, what the user views in their browser, the .ascx is a custom user
control that is used in the .aspx page. You cannot display a .ascx file in a web browser, just
the .aspx page.

.Aspx:

1 .aspx extension is used for web forms.

2 ASP.NET Page uses the extension .aspx For eg: Default.aspx

3 ASP.NET Page begin with a Page Directive. For eg:
           <%@ Page Language="C#"
     AutoEventWireup="true"
            CodeFile="Default.aspx.cs"
            Inherits="_Default" %>

4 Usercontrol is code which can be used in webforms.

5 ASP.NET Page can be viewed directly in the Browser.

6 ASP.NET Page has a HTML, Body and Form Element

.Ascx:

1 .ascx extension is used for user control .

2 User Control uses the extension .ascx For eg: WebUserControl.ascx.

3 User Control begin with a Control Directive. For eg:
               <%@ Control Language="C#"
                AutoEventWireup="true"
               CodeFile="WebUserControl.ascx.cs"
                Inherits="WebUserControl" %>
4 You can not use webforms in usercontrol.

5 The main advantage of user control is reusability ,u can this control in any number of webforms.

6 User Control cannot be viewed directly in the browser. User Controls are added to WebPages and you view them by requesting a web page in your browser.

7 User Control does not have a HTML, Body or Form element. It is hosted inside an ASP.NET Page.

mouseover and mouseout by using javascript

2012-03-27T05:47:00.002-07:00

<html>
<head>
<script type="text/javascript">
function bigImg(x)
{
x.style.height="164";
x.style.width="164";
}

function normalImg(x)
{
x.style.height="32";
x.style.width="32";
}
</script>
</head>
<body>

<img onmousemove="bigImg(this)" onmouseout="normalImg(this)" border="0"

src="smiley.gif" alt="Smiley" width="100" height="80" />



</body>
</html>

How to count the start and stop by using JavaScript

2012-03-27T05:44:00.001-07:00

<html>
<head>
<script type="text/javascript">
var c=0;
var t;
var timer_is_on=0;

function timedCount()
{
document.getElementById('txt').value=c;
c=c+1;
t=setTimeout("timedCount()",1000);
}

function doTimer()
{
if (!timer_is_on)
{
timer_is_on=1;
timedCount();
}
}

function stopCount()
{
clearTimeout(t);
timer_is_on=0;
}
</script>
</head>

<body>
<form>
<input type="button" value="Start count!" onclick="doTimer()">
<input type="text" id="txt">
<input type="button" value="Stop count!" onclick="stopCount()">
</form>
</body>
</html>

How to Insert a particular Number of Records/ rows in a table

2012-03-20T05:09:00.000-07:00

create trigger LimitTable
on student
after insert
as
    declare @tableCount int
    select @tableCount = Count(*)
    from student
    if @tableCount >15
    begin
        rollback
    end
go

Here Student is the Table Name and LimitTable is the Trigger Name....

JQuery Basics For Begginers

2012-03-13T10:37:00.001-07:00

What is jQuery?

JQuery is great library for developing ajax based application and it is great library for the JavaScript programmers, which simplifies the development of web applications. You can use jQuery to develop cool web applications. jQuery helps the programmers to keep code simple and concise. The jQuery library is designed to keep the things very simple and reusable.

In order to work with jQuery you should be aware of basics of JavaScript, HTML and CSS.

JQuery is a great tool which provides a rich set of AJAX methods to develope next generation web application.

It helps to

• Improve the performance of the application.

• Develop most browser compatible web page

• Implement UI related critical functionality without writing hundreds of lines of Code.

• No need to learn fresh new syntaxes to use jQuery, knowing simple JavaScript syntax is enough.

• Simple and Cleaner code, no need to write several lines of codes to achieve complex functionality.

Here are the features of jQuery :

DOM element selections functions
DOM traversal and modification
Events
CSS manipulation
Effects and animations
Ajax
Extensibility
Utilities - such as browser version and the each function.
JavaScript Plugins.

jQuery Syntax:

With jQuery you select (query) HTML elements and perform "actions" on them.

Basic syntax is: $(selector).action()

A dollar sign to define jQuery
A (selector) to "query (or find)" HTML elements
A jQuery action() to be performed on the element(s)

Examples:

$(this).hide() - hides current element

$("p").hide() - hides all paragraphs

$("p.test").hide() - hides all paragraphs with class="test"

$("#test").hide() - hides the element with id="test"

jQuery Selectors :

It is a key point to learn how jQuery selects exactly the elements you want to apply an effect to.

jQuery selectors allow you to select HTML elements (or groups of elements) by element name, attribute name or by content.

jQuery Element Selectors:

jQuery uses CSS selectors to select HTML elements.

$("p") selects all <p> elements.

$("p.intro") selects all <p> elements with class="intro".

$("p#demo") selects all <p> elements with id="demo".

jQuery Attribute Selectors:

jQuery uses XPath expressions to select elements with given attributes.

$("[href]") select all elements with an href attribute.

$("[href='#']") select all elements with an href value equal to "#".

$("[href!='#']") select all elements with an href attribute NOT equal to "#".

$("[href$='.jpg']") select all elements with an href attribute that ends with ".jpg".

jQuery CSS Selectors:

jQuery CSS selectors can be used to change CSS properties for HTML elements.

The following example changes the background-color of all p elements to yellow:

Example :

$("p").css("background-color","yellow");

jQuery - Events Handling:

We have the ability to create dynamic web pages by using events. Events are actions that can be detected by your Web Application.

Following are the examples events:

A mouse click
A web page loading
Taking mouse over an element
Submitting an HTML form
A keystroke on your keyboard

When these events are triggered you can then use a custom function to do pretty much whatever you want with the event. These custom functions call Event Handlers.

Binding event handlers:

Using the jQuery Event Model, we can establish event handlers on DOM elements with the bind()method as follows:

$('div').bind('click', function( event ){

alert('Hi there!');

});

The full syntax of the bind() command is as follows:

selector.bind( eventType[, eventData], handler)

The description of the parameters is :

· eventType: A string containing a JavaScript event type, such as click or submit. Refer to the next section for a complete list of event types.

· eventData: This is optional parameter is a map of data that will be passed to the event handler.

· handler: A function to execute each time the event is triggered.

Removing event handlers:

Typically, once an event handler is established, it remains in effect for the remainder of the life of the page. There may be a need when you would like to remove event handler.

jQuery provides the unbind() command to remove an exiting event handler.

The syntax of unbind() is as follows:

selector.unbind(eventType, handler)     ( or)

selector.unbind(eventType)

the description of the parameters:

· eventType: A string containing a JavaScript event type, such as click or submit. Refer to the next section for a complete list of event types.

· handler: If provided, identifies the specific listener that.s to be removed.

Event Types:

The following are cross platform and recommended event types which you can bind using JQuery:

Here is a complete list of all the support methods provided by jQuery:

Method	Description
blur( )	Triggers the blur event of each matched element.
blur( fn )	Bind a function to the blur event of each matched element.
change( )	Triggers the change event of each matched element.
change( fn )	Binds a function to the change event of each matched element.
click( )	Triggers the click event of each matched element.
click( fn )	Binds a function to the click event of each matched element.
dblclick( )	Triggers the dblclick event of each matched element.
dblclick( fn )	Binds a function to the dblclick event of each matched element.
error( )	Triggers the error event of each matched element.
error( fn )	Binds a function to the error event of each matched element.
focus( )	Triggers the focus event of each matched element.
focus( fn )	Binds a function to the focus event of each matched element.
keydown( )	Triggers the keydown event of each matched element.
keydown( fn )	Bind a function to the keydown event of each matched element.

keypress( )	Triggers the keypress event of each matched element.
keypress( fn )	Binds a function to the keypress event of each matched element.
keyup( )	Triggers the keyup event of each matched element.
keyup( fn )	Bind a function to the keyup event of each matched element.
load( fn )	Binds a function to the load event of each matched element.
mousedown( fn )	Binds a function to the mousedown event of each matched element.
mouseenter( fn )	Bind a function to the mouseenter event of each matched element.
mouseleave( fn )	Bind a function to the mouseleave event of each matched element.
mousemove( fn )	Bind a function to the mousemove event of each matched element.
mouseout( fn )	Bind a function to the mouseout event of each matched element.
mouseover( fn )	Bind a function to the mouseover event of each matched element.
mouseup( fn )	Bind a function to the mouseup event of each matched element.
resize( fn )	Bind a function to the resize event of each matched element.
scroll( fn )	Bind a function to the scroll event of each matched element.
select( )	Trigger the select event of each matched element.
select( fn )	Bind a function to the select event of each matched element.
submit( )	Trigger the submit event of each matched element.
submit( fn )	Bind a function to the submit event of each matched element.
unload( fn )	Binds a function to the unload event of each matched element.

Loading simple data:

This is very easy to load any static or dynamic data using JQuery AJAX. JQuery provides load()method to do the job:

Syntax:

Here is the simple syntax for load() method:

[selector].load( URL, [data], [callback] );

the description of all the parameters:

· URL: The URL of the server-side resource to which the request is sent. It could be a CGI, ASP, JSP, or PHP script which generates data dynamically or out of a database.

· data: This optional parameter represents an object whose properties are serialized into properly encoded parameters to be passed to the request. If specified, the request is made using the POST method. If omitted, the GET method is used.

· callback: A callback function invoked after the response data has been loaded into the elements of the matched set. The first parameter passed to this function is the response text recieved from the server and second parameter is the status code.

Getting JSON data:

There would be a situation when server would return JSON string against your request. JQuery utility function getJSON() parses the returned JSON string and makes the resulting string available to the callback function as first parameter to take further action.

Syntax:

Here is the simple syntax for getJSON() method:

[selector].getJSON( URL, [data], [callback] );

the description of all the parameters:

· URL: The URL of the server-side resource contacted via the GET method.

· data: An object whose properties serve as the name/value pairs used to construct a query string to be appended to the URL, or a preformatted and encoded query string.

· callback: A function invoked when the request completes. The data value resulting from digesting the response body as a JSON string is passed as the first parameter to this callback, and the status as the second.

What is JSON:

JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate. It is based on a subset of the JavaScript Programming Language.

JSON is a text format that is completely language independent but uses conventions that are familiar to programmers of the C-family of languages, including C, C++, C#, Java, JavaScript, Perl, Python, and many others. These properties make JSON an ideal data-interchange language.

JSON is limited to text and numeric values. Binary values are not supported.

JSON is a subset of the JavaScript Specification (ECME-Script) and is therefore directly in JavaScript.

An example JSON might look like the following.

 firstName:'Lars',

 lastName:'Vogel',

 address:

        street:'Examplestr.',

        number: '31'

How To Create Primary key In Sql Server 2008

2012-03-13T05:13:00.003-07:00

Primary Key:

      Primary Key Means Unique And Not Null.

      A primary key is a special case of unique key. Primary keys may consist of a single attribute
or multiple attributes in combination. And it’s unique, what the difference from the unique key is
the primary key cannot be NULL, and primary keys must be defined by using another syntax.

Syntax:

CREATE TABLE student
(
      Student_Id int NOT NULL PRIMARY KEY,
      LastName varchar(255) NOT NULL,
      FirstName varchar(255),
      Address varchar(255),
      City varchar(255)
    )

How to Add Primary Key For Existing table:

             ALTER TABLE Persons
             ADD PRIMARY KEY (Person_Id)

     Here Persons is the Table Name And Person_Id is the Column name.

How to DROP a PRIMARY KEY Constraint:

          ALTER TABLE Persons
          DROP CONSTRAINT pk_Person_Id

What is MVC3 in Asp .Net And How To Create MVC3 Application

2012-03-02T03:55:00.000-08:00

What is MVC?

The MVC is a web application framework that implements the model-view-controller (MVC) pattern.

Use of the Model/View/Controller (MVC) pattern results in applications that separate the
different aspects of the application (input logic, business logic, and UI logic), while providing
a loose coupling between these elements.

MODEL:
                 The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state
(usually from the controller). In event-driven systems, the model notifies observers (usually views)
when the information changes so that they can react.

VIEW:

         The view renders the model into a form suitable for interaction, typically a user interface element. Multiple views can exist for a single model for different purposes. A view port typically has a
one to one correspondence with a display surface and knows how to render to it.

CONTROLLER:

     The controller receives user input and initiates a response by making calls on model objects. A
controller accepts input from the user and instructs the model and a view port to perform actions
based on that input.

ADVANTAGES :

      1. One of the benefits of using a MVC methodology is that it helps enforce a clean separation of concerns between the models, views and controllers within an application. Maintaining a clean     separation of concerns makes the testing of applications much easier, since the contract    between different application components are more clearly defined and articulated.

      2. MVC permitting independent development, testing and maintenance of each.

      3. Better Separation of Concerns

      4. Testability

      5. Model Binder is excellent !

      6. No Viewstate anymore

      7. SEO friendly url’s (automatic)

      8. Complete control over Html output and HTML based

      9. Easier integration with Javascript / Jquery

      10. Building an Internet site where HTML,performance, and scalability are paramount ASP.NET MVC3 may be better suited

HOW TO Install MVC3 :

While you start MVC3 Application you Must Install   " VS 2010 With Sp1 " by using this Following link You can Directly install the MVC3.

            http://www.asp.net/mvc It consisting of MVC3 And MVC3 Tools Updated

How To Create Controller in MVC3 Application :

1. Open Visual Studio 2010--->File--> New --> Project--->select MVC3 APPLICATION Like Below :

2. You will Get like these Folders: Empty Controller Folder And View And Model Folders.

3.creating The Controller :

Right Click On the Controller Folder ---> select Add Controller option

4. In this Home Controller Page Write the Code and What Ever Return types we want :

2012-02-27T06:07:00.002-08:00

How To Create SSRS Reports In Sql Server 2008 Step By Step Process

2012-02-27T05:55:00.001-08:00

To Create the SSRS Reports in Sql Server 2008 Follow these Steps :

1.Click Start --->Select The Sql Server Bussiness Intelligence Development Studio

2. Click--> File -->Select New Project

3.In the Projects Types Click Business Intelligence project ----> select Report Server Project---> ok


4. In the Solution Explorer Select Report---> Right Click --->Add---->New Item--->Ok


5. In this Select Report



6. Click New--->DataSet--->Double click on that You Will Get Like Below :



7.             In the Data source Click New ---> Give The Credentials Of Your Data Base And Server Name:



8.


9.For Writing Any Query Click Query Designer like Below: You Can Write Your Own Queries Here And Write Where Condition Also It will Act As Parameter



10. In this Query Designer Select Add table option.

11. In this Select Table or procedure ,View What Ever You want For Report Out put :

12. From the Toolbox Select Table Option And Drag it in the Design Page :



13.In that Select All the Fields What Ever We want for Report :



14. If we Want Insert Image , Select Image property From the Toolbox then Give the Proper Path From system Or Data Base :

15. Click the Preview Page To View The Output Report :

How to Use Updateprogress control in asp.net for Image Loading

2012-02-17T05:51:00.001-08:00

Labels: Asp.net, CSS, Methods in .net

The following is the CSS for Image Loading using Updateprogress control

#overlay {

position: fixed;

z-index: 99;

top: 0px;

left: 0px;

background-color: #f8f8f8;

width: 100%;

height: 100%;

filter: Alpha(Opacity=90);

opacity: 0.9;

-moz-opacity: 0.9;

}

#theprogress {

background-color: #fff;

border:1px solid #ccc;

padding:10px;

width: 300px;

height: 55px;

line-height:30px;

text-align: center;

filter: Alpha(Opacity=100);

opacity: 1;

-moz-opacity: 1;

}

#modalprogress {

position: absolute;

top: 40%;

left: 50%;

margin: -11px 0 0 -150px;

color: #990000;

font-weight:bold;

font-size:14px;

}

Image for Loading:

The following is the code for updateprogress control in asp.net

<asp:UpdateProgress ID="prgLoadingStatus" runat="server" DynamicLayout="true" DisplayAfter="1" AssociatedUpdatePanelID="Updatepanel1">

<asp:Image ID="imgWaitIcon" runat="server" ImageAlign="AbsMiddle" ImageUrl="~/Images/loading.gif" />

Please wait...

</div>

</ProgressTemplate>

</asp:UpdateProgress>

How to Create User and Give Roles in sql server 2008

2012-02-17T05:43:00.000-08:00

How to Create User and Give Roles in sql server 2008 :

In this article we will discuss on how to create Logins and give database level roles in SQL Server and how to assign these roles to the specific users.

So in this scenario we will create two logins one with admin role and one with readonly tester role.
So let’s start with starting the SQL Server Management Studio.

Step 1 - Start the SQL Server Management Studio and login into it using the admin credentials.

Step 2 -Expand the Security->Logins Section

Step 3 -Right Click on the Logins folder and select New Login option. Enter the login details and then click ok.

Step 4 - Similarly create another login named Tester.

Step 5 -Next expand the Database at which you want to create roles.

Step 6 - Next right click on Database roles and select new database role, give the role name, go to securables tab click on search, in the popup window select the All objects of the types option click ok, Select database as the object type and click ok. Now set the permissions to the role at the database level as shown below and then click ok

Step 7 -Now go back to the server logins double click on the created Tester login and goto user mapping tab select the db for which we have set up roles [SampleDB] then map the login to the tester role and click ok.

Step 8 - So we are done with the tester role and mapping the tester user to tester role.

Now similarly double click on the Admin login and goto user mapping tab , select the sample db, and select the inbuilt db_accessadmin and db_owner role and click ok.

Now just refresh the server. Login using the tester user and try to perform all the Select, create, insert and other operations and you will see that you will have only the select [readonly] permission on the sampleDB.

Same way login using the Admin user login and perform you will see that you can perform all the activities.
Thats it..
Hope this article will help you all ..

How to Create Views in sql Server 2008

2012-02-16T04:51:00.000-08:00

View:
_____

       A view is a virtual table that consists of columns from one or more tables.
Though it is similar to a table, it is stored in the database.
It is a query stored as an object. Hence, a view is an object that derives its data
from one or more tables. These tables are referred to as base or underlying tables.

Views ensure the security of data by restricting access to the following data:
______________________________________________________________________________

    Specific rows of the tables.
    Specific columns of the tables.
    Specific rows and columns of the tables.
    Rows fetched by using joins.
    Statistical summary of data in a given tables.
    Subsets of another view or a subset of views and tables.

Some common examples of views are:
____________________________________

    A subset of rows or columns of a base table.
    A union of two or more tables.
    A join of two or more tables.
    A statistical summary of base tables.
    A subset of another view, or some combination of views and base table.

Creating Views:
___________________________

A view can be created by using the CREATE VIEW statement.

Syntax:
_______

CREATE VIEW view_name
[(column_name[,column_name]….)]
[WITH ENCRYPTION]
AS select_statement [WITH CHECK OPTION]

Where:

      view_name specifies the name of the view and must follow the rules for identifiers.

      column_name specifies the name of the column to be used in view. If the column_name option is not specified, then the view is created with the same columns as specified in the select_statement.

      WITH ENCRYPTION encrypts the text for the view in the syscomments table.

      AS specifies the actions that will be performed by the view.

      select_statement specifies the SELECT Statement that defines a view. The view may use the data contained in other views and tables.

      WITH CHECK OPTION forces the data modification statements to fulfill the criteria given in the SELECT statement defining the view. It also ensures that the data is visible after the modifications are made permanent.

Example:
--------------

    CREATE VIEW vwCustomer
    AS
    SELECT CustomerId, Company Name, Phone
    FROM Customers

Altering Views:
---------------------

You can modify a view without dropping it. This ensures that the permission on the view is also not lost. You can modify a view without affecting its dependent objects, such as triggers and stored procedures.

You modify a view using the ALTER VIEW statement.

Syntax:
_______

       ALTER VIEW view _name [column_ name)]
       [WITH ENCRYPTION]
       AS select_statement
       [WITH CHECK OPTION]

Dropping Views:
________________

You can drop a view from a database by using the DROP VIEW statement. When a view is dropped, it has no effect on the underlying tables. Dropping a view removes its definition and all the permissions assigned to it. Furthermore, if you query any views that reference a dropped view, you receive an error message. However, dropping a table that references a view does not drop the view automatically. You must drop it explicitly.

Syntax:
-----------

DROP VIEW view_name

Renaming Views:
_______________

You can rename a view without having to drop it. This ensures that the permissions on the view are not lost.

The guidelines for renaming a view are as follows:

    The view must be in the current database.
    The new name for the view must be followed by the rules for identifiers.
    A view can be renamed only by its owner.
    A view can also be renamed by the owner of the database.
    A view can be renamed by using the sp_rename system stored procedure.

Syntax:
--------

Sp_rename_old_viewname, new_viewname

      Where:

           old_viewname is the view that needs to be renamed.

            new_viewname is the new name of the view.

Example:
_________

           Sp_rename vwCutomers vwCustomerDetails

           Renames vwCutomers to vwCustomerDetails.