tag:blogger.com,1999:blog-2904192386692843423.post4748920977561317674..comments2024-01-20T18:35:00.592+05:30Comments on IT Developer Zone: Auto Generate Employee Id in SQL ServerSandeep Mittalhttp://www.blogger.com/profile/02880471130771695348noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-2904192386692843423.post-18379004372994378372013-04-15T15:19:45.942+05:302013-04-15T15:19:45.942+05:30Also, refer this link to learn more about computed...Also, refer this link to learn more about computed columns<br />http://itdeveloperzone.blogspot.in/2013/04/computed-column-in-sql-server.htmlSandeep Mittalhttps://www.blogger.com/profile/02880471130771695348noreply@blogger.comtag:blogger.com,1999:blog-2904192386692843423.post-65347663721475603762013-04-15T13:03:23.535+05:302013-04-15T13:03:23.535+05:30Here, BookingId is basically a computed column. Co...Here, BookingId is basically a computed column. Computed columns can be persisted or non-persisted. Persisted columns are calculated at the time on inserting and updating the data and stored permanently while non-persisted are calculated on run-time each time when referred.Sandeep Mittalhttps://www.blogger.com/profile/02880471130771695348noreply@blogger.comtag:blogger.com,1999:blog-2904192386692843423.post-86120229084830151582013-04-15T12:59:14.106+05:302013-04-15T12:59:14.106+05:30PERSISTED PRIMARY KEY means
PERSISTED PRIMARY KEY means<br />Anonymoushttps://www.blogger.com/profile/15105368217288296886noreply@blogger.comtag:blogger.com,1999:blog-2904192386692843423.post-48460655334556324652013-04-15T12:28:26.536+05:302013-04-15T12:28:26.536+05:30Sample Table Script
===========================
CR...Sample Table Script<br />===========================<br />CREATE TABLE tblBooking(<br /> Id INT identity<br /> , BookingId AS ('boo' + CAST(1000 + Id AS VARCHAR)) PERSISTED PRIMARY KEY<br /> , BookingName VARCHAR(50) NOT NULL <br />)Sandeep Mittalhttps://www.blogger.com/profile/02880471130771695348noreply@blogger.comtag:blogger.com,1999:blog-2904192386692843423.post-16671344744772928672013-04-15T12:23:30.925+05:302013-04-15T12:23:30.925+05:30Hi Dilip,
This is a sample to auto-generate id'...Hi Dilip,<br />This is a sample to auto-generate id's. You need to modify the code as per your logic & requirement.Sandeep Mittalhttps://www.blogger.com/profile/02880471130771695348noreply@blogger.comtag:blogger.com,1999:blog-2904192386692843423.post-65466758003019562372013-04-15T11:49:30.413+05:302013-04-15T11:49:30.413+05:30sir i need query for auto generation like boo1001,...sir i need query for auto generation like boo1001,boo1002....so on<br /> Anonymoushttps://www.blogger.com/profile/15105368217288296886noreply@blogger.comtag:blogger.com,1999:blog-2904192386692843423.post-48236294700670019902013-04-15T11:45:21.612+05:302013-04-15T11:45:21.612+05:30dear sir,
this is good example for booking id ......dear sir,<br /><br />this is good example for booking id ...<br />but im not executing this query..<br />pls modify and post query...Anonymoushttps://www.blogger.com/profile/15105368217288296886noreply@blogger.com