Sunday 30 August 2020

Alter Table SQL Server

 

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.

The ALTER TABLE statement is also used to add and drop various constraints on an existing table.


ALTER TABLE - ADD Column

To add a column in a table, use the following syntax:

ALTER TABLE table_name
ADD column_name datatype;

The following SQL adds an "Email" column to the "Customers" table:

Example

ALTER TABLE Customers
ADD Email varchar(255);

Tuesday 25 August 2020

Zoom Anything on mouse over CSS

 

This post will help you to learn zoom something one your webpage like Image, div, table, or any HTML component in a simple way.

img

{

      width: 100%;

      transition: all 1s;

 }

Wednesday 19 August 2020

Descritive Answer : IT TOOLS & BUSINESS SYSTEMS Jan-2018 | NIELIT O Level

 Q. 5 (A) : Write the comparison Between Dot Matrix Printers & Laser Printers with respect to Print Quality, Speed, Noise and cost parameters.

Answer

Print Quality

A typical laser printer has a resolution of 1,200 dots per inch, or dpi. It achieves this level of detail through the use of microscopic toner powder, high-performance electronics and precision optics. Many laser printers have color capability at the same high resolution. Some dot matrix printers achieve 240 dpi by making repeated passes over the same printed area, though documents produced this way take at least twice as long to print as those printed at normal quality. As a dot matrix printer's output color depends on the ribbon, virtually none offer choices beyond black and red.

Speed

A typical desktop laser printer turns out about four full-color pages per minute; for black-and-white text, this rises to 25 pages per minute. Dot matrix printers are typically rated at between 200 and 600 characters per second, or about 50 pages per minute in draft mode. Some high-output dot matrix printers achieve 1,100 characters per second, or 100 pages per minute, although the print quality is low-resolution text.

Monday 10 August 2020

Process N record from each group | SQL Server

 


ROW_NUMBER() function in SQL Server is very useful special in case when you want to process N records from a specific group. This function has been around since SQL Server 2005 and at its core, provides a way to provide sequential numbering for rows returned by a query.

As well as sequential numbering, ROW_NUMBER() provides a way to partition the results returned so this suited me just fine

Table Structure 


Sunday 2 August 2020

Descriptive Answer : NIELIT IT Tools and Business Systems (July 2018)

Q. 5 (A) :  Write a short note on storage devices of computer.
Answer : 

Examples of Storage Device