MS-SQL Server - कोपले & Computed Column

कोपले

Well कोपले in regards to SQL Server is nothing but new and soft leaf which is new small features that are getting enhanced day by day as per business requirements.

Some of these are

- Column Store Indexes

- Online nonclustered columnstore index rebuild 

- Data Compression

Additionally,

Example :- Delhi se Maan lo poore India mein Kesar jata hai.

Assume we have a condition where we have to create a computed column and on top of which we are also required to calculate something in SELECT statement so here is the case....

In one Crate we have 13 dozens of product packets are stored and as you know in one dozen its 12 packets. 

CREATE TABLE MyGeneralStore
  (
     productid    INT IDENTITY(1, 1) PRIMARY KEY NOT NULL,
     product_name VARCHAR(50) NOT NULL,
     price        TINYINT NOT NULL,
     crate_qty    TINYINT NOT NULL,
     total_dozen AS crate_qty * 13
  );

INSERT INTO MyGeneralStore
            (product_name,
             price,
             crate_qty)
VALUES      ('Kesar',
             '28',
             '23');

INSERT INTO mygeneralstore
            (product_name,
             price,
             crate_qty)
VALUES      ('Laung',
             '28',
             '23');

INSERT INTO MyGeneralStore
            (product_name,
             price,
             crate_qty)
VALUES      ('Elaichi',
             '28',
             '23'); 

हे भगवान अपनी कृपा हमपे बरसाना!

T. Amit Vaid S.