Click here to Skip to main content
15,878,543 members
Home / Discussions / Database
   

Database

 
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 
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 
Hi,
How about...

<br />
declare @value varchar(11)<br />
set @value = cast(12345678 as varchar)<br />
select cast(substring(stuff(@value, len(@value)-1, 0, substring(@value,1,1)), 2, len(@value)) as int)<br />


Ryan
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 
GeneralRe: Xml datatype vs cdc Pin
Ebube21-Oct-10 5:37
Ebube21-Oct-10 5:37 
Questionhow to use % symbol in Like statement. Pin
shiva.kore18-Oct-10 21:13
shiva.kore18-Oct-10 21:13 

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.