Saturday, July 26, 2014

Infosys opening an unit in Info Valley SEZ Falta West Bengal

"The king of IT/Software industry Infosys (Infy) is going to set up a new unit at the Special Economic Zone (SEZ) in Falta West Bengal, within Info-valley complex planned in about 500 acres of land and minimum of 1000 human resources"

More Details-
The IT behemoth, which is the anchor tenant for the Info-valley project, is authorized to have software development and consultancy/ information technology/ information technology enabled services (ITes) operations. The company has been allotted 20,961.94 square meters (50.919 acres) of land in the SEZ spread over 262.52 acres.

While giving its approval, Falta SEZ has set some conditions. The terms, among others, stipulates that the Infosys unit will export the goods manufactured/goods imported/procured for trading services, including items of trading, as per the provisions of the Special Economic Zones Act, 2005 and rules made there under for a period of five years from the date of commencement of production or service activities. For this, the company will execute a bond cum legal undertaking as prescribed under the Special Zone Rules, 2006.

The approval follows the letter of the state-run Odisha Industrial Infrastructure Development Corporation (Idco) to Falta SEZ requesting to issue the letter of permission (LoP) to Infosys to start operations at its Info-valley campus, the second development centre of the IT major in the city.

Idco said, the Bangalore-based company was allowed to act as a co-developer of the SEZ by the Union Commerce Ministry. After executing the lease deed for the land on August 29, 2013, Infosys had sought a consent letter from Idco to obtain LoP from the development commissioner, FALTA SEZ. Acting on the request, Idco had conveyed its consent to Infosys for operationalizaton of its unit in accordance with the Clause 18 sub-clause 2(ii) of SEZ rule, 2006, of Government of India.

Monday, July 21, 2014

How to insert value into identity column SQL Server 2008

Sometimes in SQL Server Database table, we need to insert a new record with explicit value in identity column. at that time we face an error  with error Message: An explicit value for the identity column in table 'TABLE NAME'  can only be specified when a column list is used and IDENTITY_INSERT is ON. Here I am explaining with example how to resolve this issue.

Example of Identity Insert
Suppose there is a table CodeImagine_TblEmployee having below schema.

CREATE TABLE [dbo].[CodeImagine_TblEmployee](
                      [EmpCode] [int] IDENTITY(1,1) NOT NULL,
                      [Name] [varchar](100) NOT NULL,
                      [Mobile] [varchar](10) NOT NULL,
                      [Address] [nvarchar](200) NULL,  
    CONSTRAINT [PK_CodeImagine_TblEmployee] PRIMARY KEY CLUSTERED  ( [EmpCode] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

I have inserted some records like-

INSERT INTO dbo.CodeImagine_TblEmployee
SELECT 'Ajit Singh','9012345678','Noida'
UNION 
SELECT 'Saurav Sarkar','9123456780','New Delhi'
UNION 
SELECT 'Virendra Maurya','9234567891','Kanpur'
UNION 
SELECT 'Alok Singh','9345678912','Faridabad'
...
...
...

Now I want to insert my own details with EmpCode=1000 and I tried with below DB script 

INSERT INTO dbo.CodeImagine_TblEmployee
SELECT  1000,'Pavan Bhardwaj','9911073055','New Delhi'

I am getting this error message

Msg 8101, Level 16, State 1, Line 2
An explicit value for the identity column in table 'dbo.CodeImagine_TblEmployee' can only be specified when a column list is used and IDENTITY_INSERT is ON.

but even after I ran
SET IDENTITY_INSERT dbo.CodeImagine_TblEmployee ON
INSERT INTO dbo.CodeImagine_TblEmployee
SELECT  1000,'Pavan Bhardwaj','9911073055','New Delhi'

I am still getting the same error message

Msg 8101, Level 16, State 1, Line 3
An explicit value for the identity column in table 'dbo.CodeImagine_TblEmployee' can only be specified when a column list is used and IDENTITY_INSERT is ON.

Solution: 
Have a look onto the best,simple & easiest way-

SET IDENTITY_INSERT dbo.TblEmployee ON

You have to make a column list for your INSERT statement:

SET IDENTITY_INSERT tableA ON

--You have to make a column list for your INSERT statement:
INSERT INTO dbo.CodeImagine_TblEmployee([EmpCode], [Name], [Mobile], [Address]) 
SELECT  1000,'Pavan Bhardwaj','9911073055','New Delhi'
SET IDENTITY_INSERT dbo.CodeImagine_TblEmployee OFF

--Now my record has been inseted with EmpCode 1000.

SELECT [EmpCode],[Name],[Mobile],[Address]

  FROM [aiccpo].[dbo].[CodeImagine_TblEmployee]

EmpCode Name                 Mobile             Address
1                Ajit Singh         9012345678     Noida
2                Alok Singh         9345678912     Faridabad
3                Saurav Sarkar 9123456780     New Delhi
4                Virendra Maurya 9234567891     Kanpur

1000        Pavan Bhardwaj 9911073055     New Delhi


Now let us check another example of Insert Identity ON
Ques: How to copy Data of One table to Other Table with Identity Column values
Solution:

SET IDENTITY_INSERT tableA ON
INSERT Into tableA ([id], [c2], [c3], [c4], [c5] ) 
SELECT [id], [c2], [c3], [c4], [c5] FROM tableB

--not like "INSERT Into tableA SELECT ........"
SET IDENTITY_INSERT tableA OFF

Author
I hope, you have enjoyed this article. I would like to have feedback from my blog readers. Your valuable feedback, question, or comments about this article are always welcome.

Sunday, July 20, 2014

Windows 8.1 Know some tips and make them tricks

I am user of windows 8.1 from last some months. Here I am sharing you some tips that creates fun & loving environment to use windows 8 with ease and discover new way to work and play with Windows 8.1.


Introduction

Windows 8.1 has been designed to power an exciting and affordable new generation of tablets and PCs. We'll be amazed by what a computer can do now.
If you still don't have windows 8.1 or using older version of Window, Please upgrade/download a new version as Windows 8.1 from here.


Have Tricks to play with Windows 8.1

    windows 8.1 tricks and tips
  • Move any tile by clicking and dragging the tile. While moving a tile, if you need a larger view of the Start screen move the tile towards the top or bottom of the screen to zoom out.
  • Use your mouse wheel to scroll left-to-right through your tiles.
  • Any Desktop shortcut or program can be pinned to the Start screen by right-clicking the icon and choosing Pin to Start.
  • In the bottom right-hand corner of the start screen is a magnifying glass with tiles, click this icon to get a zoomed out view of your Start screen. In this view, if you right-click on a group of tiles you'll be given the option to name group, which can be useful if you have a group of related tiles (e.g. games). In this view, you can also click and drag a group to organize your tile groups.
  • Create a new speed bump between tile groups by moving a tile to a speed bump.
  • Resize any User tile or Live tile by right-clicking the tile and choosing resize.
  • If there is a tile you want on your Taskbar, right-click the tile and choose Pin to taskbar.
  • Show admin applications on the Start screen by clicking Settings in Charms, click Settings, and change the Show administrative tools from No to Yes.
  • In Internet Explorer 10, you can also pin any of your favorite web pages to your Start Screen.
Download / Upgrade windows 8.1


Use a picture password to log into your computer

Windows 8 includes a new feature called Picture password, which allows you to authenticate with the computer using a series of gestures that include circles, straight lines, and taps. Enable this feature if you want a new way to access your computer or have a hard time with passwords. Please follow below steps-
  • Open the Windows Charms.
  • Click Settings and then More PC settings
  • In the PC settings window click Users and then select Create a picture password

Keyboard shortcut keys
  • Press the Windows key to open the Start screen or switch to the Desktop (if open).
  • Press the Windows key + D opens the Windows Desktop.
  • Press the Windows key + . to pin and unpin Windows apps on the side of the screen.
  • Press the Windows key + X to open the power user menu, which gives you access to many of the features most power users would want (e.g. Device Manager and Command Prompt).
  • Press the Windows key + C to open the Charms.
  • Press the Windows key + I to open the Settings, which is the same Settings found in Charms.
  • Press and hold the Windows key + Tab to show open apps.
  • Press the Windows key + Print screen to create a screen shot, which is automatically saved into your My Pictures folder.
Some new Features upgraded from Windows 7
  • A beautiful new Start screen that you can customize with your favorite apps, people, and sites
  • Great built-in apps like Mail, Calendar, and Photos, with many more available from the Windows Store
  • Optimized for the new generation of thin and light touch-enabled PCs
  • Built-in cloud storage with OneDrive for anytime, anywhere access to your photos, files, and settings
Author
If you like this article, kindly give your valuable comments here. 

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Powered by Code Imagine