Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating a rownumber?
Message
De
19/09/2013 09:35:17
Kevin Goff
Pennsylvanie, États-Unis
 
 
À
19/09/2013 09:33:30
Nicholas Mason
London, Royaume Uni
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Re: Updating a rownumber?
Versions des environnements
SQL Server:
SQL Server 6.5 and older
Application:
Web
Divers
Thread ID:
01583615
Message ID:
01583617
Vues:
50
I don't know if this will help...but T-SQL has a ROW_NUMBER function...
select ROW_NUMBER() over  (order by LastName, FirstName)  , FirstName, LastName from NamesTable order by LastName, FirstName
"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform