Skip to main content

Insert Data Into The Table SQL SERVER

 First we have to create table with the table name Student with the following fields in which we are going to insert records.

Column Name
Data Type
Length
Std_Name
Varchar
50
Address
Varchar
50
City
Varchar
50
Age
Numeric
8
DOB
DateTime
8
Class
Varchar
10

Insert Data Into The Table for execution of queries open the new query window from the Microsoft Sql Server Management Studio.



Select SQL Server from the drop down combo if you are using the client else in case of server enter (local) like above. Select window authentication or SQL Server authentication according to your system installation and click on OK. Query window will appear as you click on New Query marked as first red. Select your database from the combo displaying at the toolbar above on the screen. Now write down the following query in the displaying window.

·          The syntax for insertion is –
Insert into table name values (‘String value’, numeric value)

Use single quotes for passing the character value and numeric value will be passed with out quotes. Date time will be passed with single quotes using “MM/DD/YYYY” format.

·          For passing the data in all fields of the above table
Insert into student values (‘Ram’,’Saheed Nagar’, ‘AGRA’, 21, ‘12/25/1987’, ‘10’)

·          For passing the data in specified fields of the above table
Insert into student (std_name, Address, city, age) values (‘Ram’,’Saheed Nagar’, ‘AGRA’, 21)

·          For passing the complete table in another table with same data structure.
Insert into second Table Name select * from first Table Name

·          For passing the complete table in another table with different data structure.
Insert into second Table Name select field1, field2, field3 from first Table Name

·          INSERT with DEFAULT VALUES
INSERT student DEFAULT VALUES
                INSERT employee VALUES ('KLT91469F', 'Katrina', 'L', 'Thompson', DEFAULT, DEFAULT, DEFAULT, '01/14/95')



When inserting rows, these rules apply:
 
·          Inserting an empty string (' ') into a varchar or text column inserts a single space. All char columns are right-padded to the    defined length. All trailing spaces are removed from data inserted into varchar columns, except in strings that contain only spaces. These strings are truncated to a single space.
·          If an INSERT statement violates a constraint, default, or rule, or if    it is the wrong datatype, the statement fails and SQL Server displays    an error message. Constraints are defined with either the CREATE TABLE    or ALTER TABLE statement. Defaults are created with the CREATE DEFAULT statement and rules are created with the CREATE RULE statement.
·          Inserting a null value into a text or image column does not create a    valid text pointer, nor does it pre-allocate a 2K text page. For details    on inserting text and image data, see the text and image Manipulation    topic.
·           An INSERT statement must follow the rules for a batch. For details, see the Batches topic.
 
 
When you specify values for only some of the columns in the column list, one of three things can happen to the columns that have no values:
 
·          A default value is entered if the column has a DEFAULT constraint, if a default is bound to the column, or a default is bound to the underlying user-defined datatype.
 
·          NULL is entered if the column allows NULLs and no default value exists for the column.
 
·          An error message is displayed and the row is rejected if the column    is defined as NOT NULL and no default exists.



Comments

Popular posts from this blog

Download SCERTUP BTC 2011 Application Form

Note : Professional Courses Student can also now apply for UP BTC 2011 and date extended. The SCERT of UP was established at Lucknow in 1981 as an apex government organization at the state level. The State Council of Educational  Research  &  Training , U.P., is providing academic support to the District Primary Education Program intended primarily to accelerate the processes of pedagogical renewal in the state.   The Utter Pradesh Education Board Basic Training Certificate or B.T.C Application Form 2011 is now available for download on the Uttar Pradesh State Council of Educational Research & Training (SCERT) official website. Pre-Service Training * Training of Special B.T.C. Trainees. Training Urdu Special B.T.C. in process * Training of Shiksha Mitras, EGS/ AIE Instructors & Literacy functionaries. * Pre-service Training for physical Education and nursery training also being conducted. The thrust areas include  (a) development of curriculum, r

UP TET 2011 Exam Application,UPTET 2011 Result | UPTET 2011 Revised Result

UPTET 2011 Result | UPTET 2011 Revised Result | UPTET 2011 Updated Result |Board of High School and Intermediate Education Uttar Pradesh, Allahabad UP TET Advertisement 2011 and Exam Detail/Admit Card/Call Letter Download UP TET 2011 FORM & DETAILS  GET LATEST DETAIL ABOUT 72825 Primary Teacher Merit List UP TET 2011 Application form submission last date is 18-Oct-2011.Forms will be distributed from PNB bank all over UP.According to latest news Appearing B.Ed student also eligible for TET exam 2011 so they can also submit their forms to concern District.There is no requirement for Rojgar Registration No and Bank receipt within the application form.UP TET 2011 exam results will be avail on http://www.uptet2011.com . Now you can easily get Application from from the P.N.B bank Branches. UPTET 2011 Result | UPTET 2011 Revised Result | UPTET 2011 Updated Result |  Board of High School and Intermediate Education Uttar Pradesh, Allahabad

remove index.php from wordpress on win2003 shared hosting

No need to install any  ISAPI filter to  remove  the  index . php  from  WordPress  permalinks. No need of  .htaccess  file. . Use these simple steps to WordPress Permalinks in IIS 6.0 using Custom 404 Redirect for Windows Shared hosting/manas hosting or any windows shared hosting. When you run wordpress on IIS server your permalinks have to include the prefix /index.php/ which looks ugly and is totally un necessary.If you have these  requirements as follow:  a .IIS for Windows Shared Hosting b .WordPress Site c .Access to change your 404 error page with your web hosting. This can be remove by following simple steps. 1 .  Once installed wordpress blog on your site you’ll want to log into the admin section and select options and then select permalinks. Set your permalinks as you wish. 2 . Then  You’ll create a new text file and name it "404-error.php". In this text file you’re going to include the text: <?php // This is the default file for the s