DotNet Solution

  • Home
  • Asp.net
    • Controls
    • DataControl
    • Ajax
  • Web Design
    • Html
    • Css
    • Java Script
  • Sql
    • Queries
    • Function
    • Stored Procedures
  • MVC
    • OverView
    • Create First Application
  • BootStrap
    • Collapse Function

Tuesday, 15 March 2016

  Unknown       22:24       Queries       No comments    

The INSERT INTO statement is used to insert new records in a table.
Syntax:-
  INSERT INTO table_name (column1,column2,column3,...)
  VALUES (value1,value2,value3,...);

 The DELETE statement is used to DELETE  records in a table.
Syntax:-
  DELETE FROM table_name
  WHERE some_column=some_value; 

The UPDATE  statement is used to UPDATE  records in a table.
Syntax:-
  UPDATE table_name
  SET column1=value1,column2=value2,...
  WHERE some_column=some_value;
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
Email This BlogThis! Share to X Share to Facebook
Newer Post Older Post Home

0 comments :

Post a Comment

Popular Posts

  • Auto Increment Id in Sql Server
    SQL server identity column values use in table Steps- Firstly Open-> Sql Server Create Table -> First Field Like ID Usually Autoi...
  • Alter Query
    To add a column in a table, use Alter Query the following syntax: ALTER TABLE table_name ADD column_name datatype. To delete a column ...
  • Javascript Regular Expression Email Validate
    Validate Email using Regular Expression In JavaScript- 1. Create Input type Text box and and onclick cal  checkemail function of Javascr...
  • (no title)
    SQL SELECT Query The SELECT statement is used to select data from a database. Query SELECT * FROM TABLE NAME. Use this query we get All...
  • MVC OverView
    I ntroduction The Model-View-Controller (MVC) architectural pattern separates an application into three main components: the model, the v...
  • Rank Given In Table
    Rank Given in Table in SQL Server If We Want to Give Indviual Rank And Same Rank to Same data Then Use Use Of  ROW_NUMBER() Function  ...
  • How To Timer Work in Asp.net
    Using a Timer Control Inside an UpdatePanel Control When the Timer control is included inside an UpdatePanel control, the Timer contro...
  • Values Enter With SplitFunction in Sql Server
    Basically We Use Split Function Thorugh Commma Sepertaed string value with  Comma  Means One Then more value through split function Enter...
  • Open First Application in MVC
    How To Create First Application in MVC.Follows Some Steps-    STEP 1 . Firstly Go Start menu in Computer And Click on Installed Visual s...
  • The Evolution of MVC
    Microsoft had introduced ASP.NET MVC in .Net 3.5,since then lots of new features have been added.The following table list brief history of ...

Blog Archive

  • ▼  2016 ( 36 )
    • ►  February ( 1 )
    • ▼  March ( 5 )
      • How To Timer Work in Asp.net
      • SQL SELECT Query The SELECT statement is used to ...
      • The INSERT INTO statement is used to insert new r...
      • CHECK WHETHER DUPLICATE EATERY IF((SELECT COUNT(...
      • Alter Query
    • ►  April ( 1 )
    • ►  June ( 10 )
    • ►  July ( 6 )
    • ►  November ( 8 )
    • ►  December ( 5 )
  • ►  2017 ( 1 )
    • ►  January ( 1 )
Powered by Blogger.

Categories

  • Ajax
  • AllFunction
  • Controls
  • CreateApplication
  • css
  • Function
  • javascript
  • Js
  • over view
  • OverView
  • Queries
  • StoredProcedures

Text Widget

Sample Text

Pages

  • Home

Copyright © DotNet Solution | Powered by Blogger
Design by Vibha Acharya