Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Change data type on all char(36) columns in db
Message
De
05/09/2013 00:09:57
 
 
À
04/09/2013 23:46:44
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01582234
Message ID:
01582252
Vues:
29
>Awesome.
>
>The reason I asked about the version of SQL Server....in 2012, MS added a new sequence object. It is essentially a "table-independent identity/int" value. It's like a little factory that generates a new unique int (or bigint) every time. So in many cases, where someone was using a uniqueidentifier for unique values across tables within the database, the new sequence object might be an alternative. It's also thread-safe

I'll have to look into that. Haven't used 2012 much yet.

Hey, you don't happen by any odd chance to know anything about the FAST/FIX protocol (used for big financial data - FIX the format and FAST the compression) Pretty esoteric but its what I'm trying to get up to speed on right now and looking for someone who speaks English who may have actually gone through this.


Charles Hankey

Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy

Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.

-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin

Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform