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

Database

 
AnswerRe: VB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
Mycroft Holmes1-Mar-15 13:54
professionalMycroft Holmes1-Mar-15 13:54 
GeneralHow to increase SQL Query Performance for the Oracle Database Pin
Blog euth26-Feb-15 23:08
Blog euth26-Feb-15 23:08 
GeneralRe: How to increase SQL Query Performance for the Oracle Database Pin
Jörgen Andersson26-Feb-15 23:37
professionalJörgen Andersson26-Feb-15 23:37 
GeneralRe: How to increase SQL Query Performance for the Oracle Database Pin
Mycroft Holmes1-Mar-15 13:48
professionalMycroft Holmes1-Mar-15 13:48 
GeneralRe: How to increase SQL Query Performance for the Oracle Database Pin
PIEBALDconsult6-Mar-15 14:56
mvePIEBALDconsult6-Mar-15 14:56 
QuestionDifficult Select Query Pin
Dimitris Sakellariou25-Feb-15 23:59
Dimitris Sakellariou25-Feb-15 23:59 
AnswerRe: Difficult Select Query Pin
Corporal Agarn26-Feb-15 0:56
professionalCorporal Agarn26-Feb-15 0:56 
AnswerRe: Difficult Select Query Pin
Abdulnazark9-Mar-15 8:49
Abdulnazark9-Mar-15 8: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 11:00
Kyudos25-Feb-15 11:00 
GeneralRe: DB Conversion Advice Pin
PIEBALDconsult25-Feb-15 12:21
mvePIEBALDconsult25-Feb-15 12:21 
AnswerRe: DB Conversion Advice Pin
Mycroft Holmes25-Feb-15 13:10
professionalMycroft Holmes25-Feb-15 13:10 
GeneralRe: DB Conversion Advice Pin
Kyudos25-Feb-15 14:38
Kyudos25-Feb-15 14:38 
GeneralRe: DB Conversion Advice Pin
Mycroft Holmes25-Feb-15 14:59
professionalMycroft Holmes25-Feb-15 14:59 
GeneralRe: DB Conversion Advice Pin
Mycroft Holmes25-Feb-15 15:05
professionalMycroft Holmes25-Feb-15 15:05 
GeneralRe: DB Conversion Advice Pin
Kyudos25-Feb-15 15:23
Kyudos25-Feb-15 15:23 
GeneralRe: DB Conversion Advice Pin
Mycroft Holmes25-Feb-15 15:37
professionalMycroft Holmes25-Feb-15 15:37 
AnswerRe: DB Conversion Advice Pin
manchanx25-Feb-15 20:37
professionalmanchanx25-Feb-15 20:37 
GeneralRe: DB Conversion Advice Pin
Jörgen Andersson25-Feb-15 21:08
professionalJörgen Andersson25-Feb-15 21:08 
GeneralRe: DB Conversion Advice Pin
manchanx25-Feb-15 21:33
professionalmanchanx25-Feb-15 21:33 
QuestionService Broker Pin
Member 1116162519-Feb-15 17:15
Member 1116162519-Feb-15 17:15 
AnswerRe: Service Broker Pin
Richard MacCutchan19-Feb-15 21:32
mveRichard MacCutchan19-Feb-15 21:32 
QuestionThe following stored proc is not working Pin
indian14318-Feb-15 16:18
indian14318-Feb-15 16:18 
GeneralRe: The following stored proc is not working Pin
PIEBALDconsult18-Feb-15 16:21
mvePIEBALDconsult18-Feb-15 16:21 
GeneralRe: The following stored proc is not working Pin
indian14319-Feb-15 6:26
indian14319-Feb-15 6:26 
AnswerRe: The following stored proc is not working Pin
Wendelius18-Feb-15 17:28
mentorWendelius18-Feb-15 17: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.