Automatically generating Guids in Sybase

Posted by Daniel Dyson on Stack Overflow See other posts from Stack Overflow or by Daniel Dyson
Published on 2010-04-15T13:38:41Z Indexed on 2010/04/24 11:13 UTC
Read the original article Hit count: 172

Filed under:

sybase

I have a table with 42 million records. 32 million have a null value and I would like to generate a new guid for each one. Should I do this in batches?

Also, going forward, I would like a new guid added to the field on the insert of a new record. What is the best way to do this?

The field is not the primary key, which is an auto-incrementing integer.

Related posts about sybase

"Oracle", "Sybase", "SQL Server" vs just "SQL/JDBC" in the CV

as seen on Programmers - Search for 'Programmers'
How would you define a testable measure of the expertise that, if you're honest with yourself, lets you write in your CV words "Oracle", "Sybase", or "SQL Server" and not just "Relational Databases, SQL, JDBC" in your software developer's CV? What every XXX-developer (XXX - a vendor name) should know… >>> More
Limiting Sybase ASE 15 CPU usage on VM

as seen on Server Fault - Search for 'Server Fault'
I've set up a single CPU Sybase ASE 15.7 test/hobby/experimentation system on a Debian Squeeze x64 KVM VM. I notice the CPU load goes to 100% and stays there. Definitely not a Sybase guru, only interested to see if some programs I'm running work on the database. Looking at Sybase docs it seems ASE… >>> More
Php pdo_dblib - cannot find/unable to load freetds

as seen on Server Fault - Search for 'Server Fault'
Self-hosted box, RHEL 6 PHP 5.3.3 PDO installed freetds installed pdo_dblib - so far no luck installing My goal is to use PDO with sybase. Attempting to install pdo_dblib from the appropriate version php source code. I have tried a variety of methods and searched quite a bit for help on this topic… >>> More
Any alternative to Sybase Sql Advantage?

as seen on Stack Overflow - Search for 'Stack Overflow'
Sybase Sql Advantage is the default editor for the Sybase database. But it has lots of shortcomings, because it basically is what Notepad is for Windows users: Can't do multiple undo's Monochrome, text is black and background is white Can't see what character did you exactly paste from clipboard… >>> More
Constructing dynamic columns from parameters in Sybase

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to write a stored proc (SP) in Sybase. The SP takes 5 varchar parameters. Based on the parameters passed, I want to construct the column names to be selected from a particular table. The below works: DECLARE @TEST VARCHAR(50) SELECT @TEST = "country" … >>> More

Developer IT

Automatically generating Guids in Sybase - Developer IT

Automatically generating Guids in Sybase

sybase

Related posts about sybase

"Oracle", "Sybase", "SQL Server" vs just "SQL/JDBC" in the CV

Limiting Sybase ASE 15 CPU usage on VM

Php pdo_dblib - cannot find/unable to load freetds

Any alternative to Sybase Sql Advantage?

Constructing dynamic columns from parameters in Sybase

Categories cloud