Click here to Skip to main content
15,867,686 members
Home / Discussions / Database
   

Database

 
AnswerRe: how to updat a column from start point Pin
thatraja20-May-14 8:06
professionalthatraja20-May-14 8:06 
GeneralRe: how to updat a column from start point Pin
mhd.sbt20-May-14 8:26
mhd.sbt20-May-14 8:26 
AnswerRe: how to updat a column from start point Pin
thatraja20-May-14 8:37
professionalthatraja20-May-14 8:37 
GeneralRe: how to updat a column from start point Pin
NitinDhapte16-Jun-14 3:01
NitinDhapte16-Jun-14 3:01 
AnswerRe: how to updat a column from start point Pin
PIEBALDconsult20-May-14 3:36
mvePIEBALDconsult20-May-14 3:36 
GeneralRe: how to updat a column from start point Pin
mhd.sbt20-May-14 17:47
mhd.sbt20-May-14 17:47 
GeneralRe: how to updat a column from start point Pin
Mycroft Holmes20-May-14 19:54
professionalMycroft Holmes20-May-14 19:54 
AnswerRe: how to updat a column from start point Pin
NitinDhapte16-Jun-14 3:08
NitinDhapte16-Jun-14 3:08 
Hi,
Try this :

ColumnA is the primary key of table : tableName


SQL
UPDATE tableName SET columnB = 9 + t2.RowNum  FROM tableName t1 INNER JOIN (
SELECT ROW_NUMBER() OVER (ORDER BY columnA) RowNum,columnA FROM tableName) t2 ON t1.columnA = t2.columnA

QuestionUpdate DB Table based on another temp Table data Pin
Sachin k Rajput 19-May-14 4:11
Sachin k Rajput 19-May-14 4:11 
AnswerRe: Update DB Table based on another temp Table data Pin
PIEBALDconsult19-May-14 12:22
mvePIEBALDconsult19-May-14 12:22 
Questionweird scenario after executing prepared statement mysql Pin
Gilbert Consellado15-May-14 23:15
professionalGilbert Consellado15-May-14 23:15 
AnswerRe: weird scenario after executing prepared statement mysql Pin
Kornfeld Eliyahu Peter17-May-14 8:21
professionalKornfeld Eliyahu Peter17-May-14 8:21 
GeneralRe: weird scenario after executing prepared statement mysql Pin
Gilbert Consellado21-May-14 23:53
professionalGilbert Consellado21-May-14 23:53 
QuestionJoin Query returning duplicated rows Pin
devenv.exe15-May-14 23:13
professionaldevenv.exe15-May-14 23:13 
AnswerRe: Join Query returning duplicated rows Pin
Mycroft Holmes16-May-14 13:20
professionalMycroft Holmes16-May-14 13:20 
AnswerRe: Join Query returning duplicated rows Pin
NitinDhapte6-Jun-14 23:07
NitinDhapte6-Jun-14 23:07 
QuestionTranspose multiple rows into multiple columns in SQL Server Pin
Davidemazzuuu13-May-14 4:52
Davidemazzuuu13-May-14 4:52 
AnswerRe: Transpose multiple rows into multiple columns in SQL Server Pin
Corporal Agarn13-May-14 5:46
professionalCorporal Agarn13-May-14 5:46 
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Davidemazzuuu13-May-14 21:11
Davidemazzuuu13-May-14 21:11 
AnswerRe: Transpose multiple rows into multiple columns in SQL Server Pin
Mycroft Holmes13-May-14 12:53
professionalMycroft Holmes13-May-14 12:53 
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Davidemazzuuu13-May-14 21:04
Davidemazzuuu13-May-14 21:04 
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Mycroft Holmes13-May-14 21:30
professionalMycroft Holmes13-May-14 21:30 
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Davidemazzuuu13-May-14 22:27
Davidemazzuuu13-May-14 22:27 
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Member 1026233013-May-14 21:34
Member 1026233013-May-14 21:34 
QuestionSQL Server 2012 Cube Build failing. Pin
rnbergren12-May-14 9:52
rnbergren12-May-14 9:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.