Serial ID Auto Generation

By Larry Sumuri, 2010/02/22

Total article views: 1033 | Views in the last 30 days: 844

Rate this |

Join the discussion |

Briefcase

I was looking for ways to create the functionality to autogenerate customized serial IDs so I came up with this. It can be customized even further depending on you ID generation requirements.

To use this:

1. Create the table and stored procedure

2. Execute the stored procedure to autogenerate your serial ID.

The autogenerated ID can be saved again depending on what you a developing etc. etc.

By Larry Sumuri, 2010/02/22

Total article views: 1033 | Views in the last 30 days: 844

Your response

Rate this |

Join the discussion |

Briefcase

Digg

Delicious

Technorati

SCRIPT

AUTOGENERATE Stored procedures example

This is related to my other autogenerate code. this is just an example of how to use it.

FORUM

AUTOGENERATE Stored procedures example

Comments posted to this topic are about the item [B]AUTOGENERATE Stored procedures example[/B]

FORUM

Autogenerate dates

I'm sure someone has done this before, but I can't seem to find a thread regarding it. I've got ...

FORUM

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS

Comments posted to this topic are about the item [B]AUTOGENERATE INSERT UPDATE SELECT STATEMENTS[/B...

SCRIPT

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS

use metadata to generate basic create procedure statements for insert update and select

Free registration required...

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Login (existing users)

Login

Email: Password: Remember me: Forgotten your password?

Register (new users)

Register

Email: Password:

Confirm:

Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

Steve Jones
Editor, SQLServerCentral.com