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. 

Saturday, July 19, 2014

5 features / advantage of JQuery

Before counting features of JQuery, I just want to define JQuery in brief.

"JQuery is fast, lightweight and feature-rich client side JavaScript Library which helps in to traverse HTML DOM, make animations, add Ajax interaction, manipulate the page content, change the style and provide cool UI effect "

Advantage of JQuery
  • Easy to use and learn.
  • Easily expandable.
  • Cross-browser support (IE 6.0+, FF 1.5+, Safari 2.0+, Opera 9.0+)
  • Easy to use for DOM manipulation and traversal.
  • Large pool of built in methods.
  • AJAX Capabilities.
  • Methods for changing or applying CSS, creating animations.
  • Event detection and handling.
  • Tons of plug-ins for all kind of needs.

Friday, July 18, 2014

How to bind/Attache jquery events to selectors or elements

Let us find out the solution of following queries.
Ques: How to attache JQuery events to selectors or elements.
Ques: Explain .bind() vs .live() vs .delegate() vs .on()

This is one of the frequently asked question related to event handling using JQuery.

All these 4 JQuery methods bind(), live(), delegate() & on() are used for attaching events to selectors or elements. But they all are different from each other.

.bind(): This is the easiest and quick method to bind events. But the issue with bind() is that it doesn't work for elements added dynamically that matches the same selector. bind() only attach events to the current elements not future element. Above that it also has performance issues when dealing with a large selection.

.live(): This method overcomes the disadvantage of bind(). It works for dynamically added elements or future elements. Because of its poor performance on large pages, this method is deprecated as of jQuery 1.7 and you should stop using it. Chaining is not properly supported using this method.

.delegate(): The .delegate() method behaves in a similar fashion to the .live() method, but instead of attaching the selector/event information to the document, you can choose where it is anchored and it also supports chaining.


.on(): Since live was deprecated with 1.7, so new method was introduced named ".on()". This method provides all the goodness of previous 3 methods and it brings uniformity for attaching event handlers.

Author: If you like this post or want some modification, kindly write your valuable comments here.

Sunday, July 13, 2014

SQL Server-find dependents objects (sps, Procs, Table & View)

Sometimes we forget Stored Procedures name that we have created for any specific action/process. At that case we can easily find out name of that procedure using below DB script.

It is also useful to find dependent objects when ever we want to drop any DB object as well find out all the objects having keyword you want to search for.

Following code will help you to find all the DB Objects i.e.Stored Procedures,Tables,Views which are related to one or more specific tables. sp_help and sp_depends does not always return accurate results.

SELECT DISTINCT so.name,so.*,sc.*
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%sapdb.dbo%'

Check your mind's ability- solve the puzzle

1   2   
3   4   5   
6   
7   
8   
9   
10   11   12   
13   14   15   
16   17   
18   19   
20   21   22   
23   
24   25   
26   
27   28   29   
30   
31   

Across:
1.Lunch comes __________ breakfast.
2.B is the letter ________ A and C.
3.We learn English _____ the Community College.
6.Synonym for although, in spite of.
7.A synonym for beside: ____________ to.
8.Ko is taller ______ Linda.
9.We used our windshield wipers as we drove ____________ the pouring rain
12."Romeo and Juliet" was written _____ Shakespeare.
13.It is raining ________. I need an umbrella!
15.Alyosha is going _____ the mall.
18.It’s a good idea to look both ways before you walk __________ the street.
19.Everyone stood __________ the fire to get warm.
20.I am at the front of the line. Everyone is standing __________ me.
21.The waiter pours the water _____ the cup.
23.The computer sits _____ the desk.
24.My family has owned this house _________ the year 1886.
25.Would you like a piece _____ cake?
27.I am swimming ___ the pool.
29.My dad knows a lot _________ hunting.
30.Everyone in the family was tall, ___________ Paul, who was short.
31.You shouldn't talk on your cell phone _________ the movie.

Down:
1.I disagree with you. I'm __________ this idea.
2.This is a synonym for "under."
4.Joe can't come to the party. I guess I should go _________ him.
5.Help wanted. Inquire ______.
10.27 comes __________ 28.
11.The hurricane is headed __________ our city. We have to leave.
12.The temperature in Antarctica can fall to 125 degrees __________ zero. That’s cold!
14.Water flows ________ a bridge.
16.I lived in France ____ a child.
17.The library doesn’t close ________ 8:30 pm.
18.There are stores all _________ Main Street.
20.The mouse is __________ the computer.
22.I'm ready to go to sleep. Turn the lights _____.
25.The milk is in the refrigerator. Can you take it ________ so we can drink some of it?
26.The sun shines ______ us.
28.A synonym for “close to”.

 
Powered by Code Imagine