Click here to Skip to main content
15,512,747 members
Home / Discussions / Database
   

Database

 
AnswerRe: VB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
Mycroft Holmes1-Mar-15 14:54
professionalMycroft Holmes1-Mar-15 14:54 
GeneralHow to increase SQL Query Performance for the Oracle Database Pin
Blog euth27-Feb-15 0:08
Blog euth27-Feb-15 0:08 
GeneralRe: How to increase SQL Query Performance for the Oracle Database Pin
Jörgen Andersson27-Feb-15 0:37
professionalJörgen Andersson27-Feb-15 0:37 
GeneralRe: How to increase SQL Query Performance for the Oracle Database Pin
Mycroft Holmes1-Mar-15 14:48
professionalMycroft Holmes1-Mar-15 14:48 
GeneralRe: How to increase SQL Query Performance for the Oracle Database Pin
PIEBALDconsult6-Mar-15 15:56
professionalPIEBALDconsult6-Mar-15 15:56 
QuestionDifficult Select Query Pin
Dimitris Sakellariou26-Feb-15 0:59
Dimitris Sakellariou26-Feb-15 0:59 
AnswerRe: Difficult Select Query Pin
Corporal Agarn26-Feb-15 1:56
professionalCorporal Agarn26-Feb-15 1:56 
AnswerRe: Difficult Select Query Pin
Abdulnazark9-Mar-15 9:49
Abdulnazark9-Mar-15 9:49 
create table #tmp (ColA varchar(2),ColB varchar(100))
insert into #tmp
select '1', '12.324.145'
union all
select '2', '425.152.643'
union all
select '3', '12'



select a.ColA,t.c.value('.','varchar(100)') as col2 from (select cola,cast('<t>'+replace(colB,'.','<t>')+'' as xml) as c2 from #tmp) a


cross apply c2.nodes('/t') t(c)

modified 13-Mar-15 4:04am.

QuestionDB Conversion Advice Pin
Kyudos25-Feb-15 12:00
Kyudos25-Feb-15 12:00 
GeneralRe: DB Conversion Advice Pin
PIEBALDconsult25-Feb-15 13:21
professionalPIEBALDconsult25-Feb-15 13:21 
AnswerRe: DB Conversion Advice Pin
Mycroft Holmes25-Feb-15 14:10
professionalMycroft Holmes25-Feb-15 14:10 
GeneralRe: DB Conversion Advice Pin
Kyudos25-Feb-15 15:38
Kyudos25-Feb-15 15:38 
GeneralRe: DB Conversion Advice Pin
Mycroft Holmes25-Feb-15 15:59
professionalMycroft Holmes25-Feb-15 15:59 
GeneralRe: DB Conversion Advice Pin
Mycroft Holmes25-Feb-15 16:05
professionalMycroft Holmes25-Feb-15 16:05 
GeneralRe: DB Conversion Advice Pin
Kyudos25-Feb-15 16:23
Kyudos25-Feb-15 16:23 
GeneralRe: DB Conversion Advice Pin
Mycroft Holmes25-Feb-15 16:37
professionalMycroft Holmes25-Feb-15 16:37 
AnswerRe: DB Conversion Advice Pin
manchanx25-Feb-15 21:37
professionalmanchanx25-Feb-15 21:37 
GeneralRe: DB Conversion Advice Pin
Jörgen Andersson25-Feb-15 22:08
professionalJörgen Andersson25-Feb-15 22:08 
GeneralRe: DB Conversion Advice Pin
manchanx25-Feb-15 22:33
professionalmanchanx25-Feb-15 22:33 
QuestionService Broker Pin
Member 1116162519-Feb-15 18:15
Member 1116162519-Feb-15 18:15 
AnswerRe: Service Broker Pin
Richard MacCutchan19-Feb-15 22:32
mveRichard MacCutchan19-Feb-15 22:32 
QuestionThe following stored proc is not working Pin
indian14318-Feb-15 17:18
indian14318-Feb-15 17:18 
GeneralRe: The following stored proc is not working Pin
PIEBALDconsult18-Feb-15 17:21
professionalPIEBALDconsult18-Feb-15 17:21 
GeneralRe: The following stored proc is not working Pin
indian14319-Feb-15 7:26
indian14319-Feb-15 7:26 
AnswerRe: The following stored proc is not working Pin
Wendelius18-Feb-15 18:28
mveWendelius18-Feb-15 18:28 

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.