Monday, March 5, 2012

Storing Excel file into SQL:


Storing Excel file into SQL:

Step 1: Create a Excel file and add Columns.
Step 2: Save as the Excel file in CSV format.
Step 3: Create a Table .Table fields are match with Excel Columns.

For ex:
Excel Having the following Columns
Sno
Name
City
Pincode
SQL Must Have the following fields
Sno,Name,City,Pincode
 
Step 4: Run this query in SQL.
Syntax:

BULK
INSERT table name
FROM 'csv file Path’
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

Example:

BULK
INSERT TestTableName
FROM ' C:\Users\bharathi\Desktop\TextExcelFile.CSV’
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

Tuesday, February 28, 2012

IEEE Standards


Guidelines IEEE Standards

Author(s) Name(s)
Author Affiliation(s)
E-mail

Abstract

            The abstract is to be in fully-justified italicized text, at the top of the left-hand column as it is here, below the author information. Use the word “Abstract” as the title, in 12-point Times, boldface type, centered relative to the column, initially capitalized. The abstract is to be in 10-point, single-spaced type, and may be up to 3 in. (7.62 cm) long. Leave two blank lines after the abstract, then begin the main text. All manuscripts must be in English.

1. Introduction

            These guidelines include complete descriptions of the fonts, spacing, and related information for producing your proceedings manuscripts.
A zip-file of this sample manuscript is also available (http://mecha.ee.boun.edu.tr/word2.zip), which you can use as a template to prepare your paper.
Please note that your paper should normally be limited to six pages. A maximum of two additional pages can be used subject to a charge of $100/page.

2. Formatting your paper

            All printed material, including text, illustrations, and charts, must be kept within a print area of 6-7/8 inches (17.5 cm) wide by 8-7/8 inches (22.54 cm) high. Do not write or print anything outside the print area. All text must be in a two-column format. Columns are to be 3-1/4 inches (8.25 cm) wide, with a 5/16 inch (0.8 cm) space between them. Text must be fully justified.

3. Main title

            The main title (on the first page) should begin 1-3/8 inches (3.49 cm) from the top edge of the page, centered, and in Times 14-point, boldface type. Capitalize the first letter of nouns, pronouns, verbs, adjectives, and adverbs; do not capitalize articles, coordinate conjunctions, or prepositions (unless the title begins with such a word). Leave two blank lines after the title.

4. Author name(s) and affiliation(s)

            Author names and affiliations are to be centered beneath the title and printed in Times 12-point, non-boldface type. Multiple authors may be shown in a two- or three-column format, with their affiliations below their respective names. Affiliations are centered below each author name, italicized, not bold. Include e-mail addresses if possible. Follow the author information by two blank lines before main text.



5. Second and following pages

            The second and following pages should begin 1.0 inch (2.54 cm) from the top edge. On all pages, the bottom margin should be 1-1/8 inches (2.86 cm) from the bottom edge of the page for 8.5 x 11-inch paper; for A4 paper, approximately 1-5/8 inches (4.13 cm) from the bottom edge of the page.

6. Type-style and fonts

            Wherever Times is specified, Times Roman, or New Times Roman may be used. If neither is available on your word processor, please use the font closest in appearance to Times that you have access to. Please avoid using bit-mapped fonts if possible. True-Type 1 fonts are preferred.

7. Main text

            Type your main text in 10-point Times, single-spaced. Do not use double-spacing. All paragraphs should be indented 1 pica (approximately 1/6- or 0.17-inch or 0.422 cm). Be sure your text is fully justified—that is, flush left and flush right. Please do not place any additional blank lines between paragraphs.
Figure and table captions should be 10-point Helvetica (or a similar sans-serif font), boldface. Callouts should be 9-point Helvetica, non-boldface. Initially capitalize only the first word of each figure caption and table title. Figures and tables must be numbered separately. For example: “Figure 1. Database contexts”, “Table 1. Input data”. Figure captions are to be below the figures. Table titles are to be centered above the tables.

8. First-order headings

            For example, “1. Introduction”, should be Times 12-point boldface, initially capitalized, flush left, with one blank line before, and one blank line after. Use a period (“.”) after the heading number, not a colon.

8.1. Second-order headings

            As in this heading, they should be Times 11-point boldface, initially capitalized, flush left, with one blank line before, and one after.

8.1.1. Third-order headings. Third-order headings, as in this paragraph, are discouraged. However, if you must use them, use 10-point Times, boldface, initially capitalized, flush left, preceded by one blank line, followed by a period and your text on the same line.

9. Printing your paper

            Print your properly-formatted text on high-quality, 8.5 x 11-inch white printer paper. A4 paper is also acceptable, but please leave the extra 0.5 inch (1.27 cm) at the BOTTOM of the page. If the last page of your paper is only partially filled, arrange the columns so that they are evenly balanced if possible, rather than having one long column.


10. Page numbering

            Number your pages lightly, in pencil, on the upper right-hand corners of the BACKS of the pages (for example, 1/6, 2/6; or 1 of 6, 2 of 6; and so forth). Please do NOT write on the fronts of the pages, nor on the lower halves of the backs of the pages. Do not automatically paginate your pages. Note that unnumbered pages that get out of order can be very difficult to put back in order!

11. Illustrations, graphs, and photographs

            All graphics should be centered. Your artwork must be in place in the article (preferably printed as part of the text rather than pasted up). If you are using photographs and are able to have halftones made at a print shop, use a 100- or 110-line screen. If you must use photos, they must be pasted onto your manuscript. Use rubber cement to affix the halftones or photos in place. Black and white, clear, glossy-finish photos are preferable to color. Supply the best quality photographs and illustrations possible. Penciled lines and very fine lines do not reproduce well. Remember, the quality of the book cannot be better than the originals provided. Do not use tape on your pages!

11.1. Color images in proceedings

            The use of color on interior pages (that is, pages other than the cover of the proceedings) is prohibitively expensive. Interior pages may be published in color only when it is specifically requested and budgeted for by the authors. DO NOT SUBMIT COLOR IMAGES IN YOUR PAPER UNLESS SPECIFICALLY INSTRUCTED TO DO SO.

11.2. Symbols

            If your word processor or typewriter cannot produce Greek letters, mathematical symbols, or other graphical elements, please use pressure-sensitive (self-adhesive) rub-on symbols or letters (available in most stationery stores, art stores, or graphics shops).

11.3. Footnotes

            Use footnotes sparingly (or not at all!) and place them at the bottom of the column on the page on which they are referenced. Use Times 8-point type, single-spaced. To help your readers, avoid using footnotes altogether and include necessary peripheral observations in the text (within parentheses, if you prefer, as in this sentence).

12. References

            List and number all bibliographical references in 9-point Times, single-spaced, at the end of your paper. When referenced in the text, enclose the citation number in square brackets, for example [1]. Where appropriate, include the name(s) of editors of referenced books.

[1] Bharathi Gurusheve.R, “IEEE Standards”, Journal, Publisher, Location, Date, pp. 1-10.
[2] BharathiDasan..K, Book Title, Publisher, Location, Date.


13. Copyright forms and reprint orders
            You must include your signed copyright release form that will be available in Author's Package when you submit your finished paper. We MUST have this form before your paper can be published in the proceedings.

Wednesday, November 30, 2011

Cloud Computing

Cloud Computing

Cloud computing is a general term for anything that involves delivering hosted services over the Internet. These services are broadly divided into three categories: Infrastructure-as-a-Service (IaaS), Platform-as-a-Service (PaaS) and Software-as-a-Service (Saas). The name cloud computing was inspired by the cloud symbol that's often used to represent the Internet in flowcharts and diagrams.

A cloud service has three distinct characteristics that differentiate it from traditional hosting. It is sold on demand, typically by the minute or the hour; it is elastic -- a user can have as much or as little of a service as they want at any given time; and the service is fully managed by the provider (the consumer needs nothing but a personal computer and Internet access). Significant innovations in virtualization and distributed computing, as well as improved access to high-speed Internet and a weak economy, have accelerated interest in cloud computing.

A cloud can be private or public. A public Cloud sells services to anyone on the Internet. (Currently, Amazon Web Services is the largest public cloud provider.) A private Cloud is a proprietary network or a data center that supplies hosted services to a limited number of people. When a service provider uses public cloud resources to create their private cloud, the result is called a virtual private cloud. Private or public, the goal of cloud computing is to provide easy, scalable access to computing resources and IT services.

Infrastructure-as-a-Service like Amazon Web Services provides virtual server instanceAPI) to start, stop, access and configure their virtual servers and storage. In the enterprise, cloud computing allows a company to pay for only as much capacity as is needed, and bring more online as soon as required. Because this pay-for-what-you-use model resembles the way electricity, fuel and water are consumed, it's sometimes referred to as utility computing.

Platform-as-a-service in the cloud is defined as a set of software and product development tools hosted on the provider's infrastructure. Developers create applications on the provider's platform over the Internet. PaaS providers may use APIs, website portals or gateway software installed on the customer's computer. Force.com, (an outgrowth of Salesforce.com) and GoogleApps are examples of PaaS. Developers need to know that currently, there are not standards for interoperability or data portability in the cloud. Some providers will not allow software created by their customers to be moved off the provider's platform.

In the software-as-a-service cloud model, the vendor supplies the hardware infrastructure, the software product and interacts with the user through a front-end portal. SaaS is a very broad market. Services can be anything from Web-based email to inventory control and database processing. Because the service provider hosts both the application and the data, the end user is free to use the service from anywhere.

Tuesday, March 1, 2011

Computer - Acronym

Computer

C-Commonly

O-Operated

M-Machine

P-Particularly

U-Used for

T-Trade or Technical

E-Education and

R-Research

Friday, February 25, 2011

Backup and restoring Database

This is the command used to take the database Backup from Disk:

BACKUP DATABASE DBNAME DISK='filepath\backupname.bak'


This is the command used to restore the database from backup:

RESTORE DATABASE DBNAME FROM DISK = 'filepath\backupname.bak'