Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to genrate automaticlly empid like gt001

Answer Posted / trainedforjob

create a identity column and create a computed column which will br 'gt' concatenate identity column

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of triggers are there?

1043


What is default constraint?

975


How to drop existing indexes in ms sql server?

1051


Explain what are the basic functions for master, msdb, model, tempdb databases?

950


What is PROJECTION Operation?

1003


What is a trigger and its types?

962


What is a filestream?

970


How optimize sql query with multiple joins in sql server?

872


Explain indexing and what are the advantages of it?

1002


Can you please explain the difference between function and stored procedure?

985


What is merge statement?

1064


Is INSTEAD OF trigger directly applicable to Table ?

997


What is the use of set nocount on/off statement?

1074


can an automatic recovery be initiated by a user? : Sql server administration

932


Difference between connected and disconnected database in .net with sql server?

1074