Click here to Skip to main content
15,904,877 members
Home / Discussions / Database
   

Database

 
GeneralRe: retrieving column's data Pin
siang_wu_id23-Oct-10 0:35
siang_wu_id23-Oct-10 0:35 
AnswerRe: retrieving column's data Pin
thatraja23-Oct-10 0:46
professionalthatraja23-Oct-10 0:46 
GeneralRe: retrieving column's data Pin
siang_wu_id23-Oct-10 0:55
siang_wu_id23-Oct-10 0:55 
GeneralRe: retrieving column's data Pin
thatraja23-Oct-10 1:19
professionalthatraja23-Oct-10 1:19 
GeneralRe: retrieving column's data Pin
siang_wu_id23-Oct-10 1:37
siang_wu_id23-Oct-10 1:37 
GeneralRe: retrieving column's data Pin
thatraja23-Oct-10 1:47
professionalthatraja23-Oct-10 1:47 
AnswerRe: retrieving column's data Pin
RyanEK24-Oct-10 11:47
RyanEK24-Oct-10 11:47 
QuestionSQL Server 2008 - Number Manipulation Pin
ac01121-Oct-10 6:59
ac01121-Oct-10 6:59 
Hi All,

I'm very new to SQL Server 2008, and need a bit of help manipulating numbers.

I've got a int column holding numbers up to 11 digits. I need to do the following manipulation and use it in a SQL query. Basically, the first digit is transfered to the 3rd position on the right side.

12345678
23456178

or

1234
2134

The values are variable, there are even records with only a value of 1.

Thanks in advance.
AnswerRe: SQL Server 2008 - Number Manipulation Pin
Eddy Vluggen21-Oct-10 10:05
professionalEddy Vluggen21-Oct-10 10:05 
AnswerRe: SQL Server 2008 - Number Manipulation Pin
RyanEK21-Oct-10 14:39
RyanEK21-Oct-10 14:39 
GeneralRe: SQL Server 2008 - Number Manipulation Pin
ac01121-Oct-10 23:07
ac01121-Oct-10 23:07 
QuestionUpdate query does not affects matched Pin
Abdul-Rhman Alsri21-Oct-10 5:28
Abdul-Rhman Alsri21-Oct-10 5:28 
AnswerRe: Update query does not affects matched Pin
Eddy Vluggen21-Oct-10 10:02
professionalEddy Vluggen21-Oct-10 10:02 
QuestionStored Procedure Pin
Nath20-Oct-10 22:19
Nath20-Oct-10 22:19 
AnswerRe: Stored Procedure Pin
J4amieC20-Oct-10 23:38
J4amieC20-Oct-10 23:38 
GeneralRe: Stored Procedure Pin
Mycroft Holmes21-Oct-10 13:04
professionalMycroft Holmes21-Oct-10 13:04 
GeneralRe: Stored Procedure Pin
J4amieC21-Oct-10 21:48
J4amieC21-Oct-10 21:48 
GeneralRe: Stored Procedure Pin
Mycroft Holmes22-Oct-10 0:52
professionalMycroft Holmes22-Oct-10 0:52 
QuestionReturn name and identity for all tables Pin
yippiecoder20-Oct-10 10:55
yippiecoder20-Oct-10 10:55 
AnswerRe: Return name and identity for all tables Pin
Blue_Boy20-Oct-10 21:12
Blue_Boy20-Oct-10 21:12 
GeneralRe: Return name and identity for all tables Pin
David Skelly20-Oct-10 22:40
David Skelly20-Oct-10 22:40 
QuestionI want your help Pin
Lamis Radman19-Oct-10 9:31
Lamis Radman19-Oct-10 9:31 
AnswerRe: I want your help Pin
Pete O'Hanlon20-Oct-10 0:02
mvePete O'Hanlon20-Oct-10 0:02 
QuestionXml datatype vs cdc Pin
Ebube19-Oct-10 6:47
Ebube19-Oct-10 6:47 
AnswerRe: Xml datatype vs cdc Pin
Mycroft Holmes19-Oct-10 12:22
professionalMycroft Holmes19-Oct-10 12:22 

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.