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

Database

 
GeneralRe: mysql decimal fromat like ##.## Pin
Shweta N Mishra23-Nov-14 2:06
professionalShweta N Mishra23-Nov-14 2:06 
GeneralRe: mysql decimal fromat like ##.## Pin
Gilbert Consellado24-Nov-14 12:47
professionalGilbert Consellado24-Nov-14 12:47 
QuestionProblem in Insering Long text in mysql from c# Pin
Ramachandra12720-Nov-14 7:09
Ramachandra12720-Nov-14 7:09 
GeneralRe: Problem in Insering Long text in mysql from c# Pin
PIEBALDconsult20-Nov-14 7:33
mvePIEBALDconsult20-Nov-14 7:33 
QuestionSQL Replace Function - error recognizing two or more strings Pin
miss78617-Nov-14 23:44
miss78617-Nov-14 23:44 
AnswerRe: SQL Replace Function - error recognizing two or more strings Pin
Richard Deeming18-Nov-14 2:53
mveRichard Deeming18-Nov-14 2:53 
GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
miss78618-Nov-14 3:53
miss78618-Nov-14 3:53 
GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
Richard Deeming18-Nov-14 6:00
mveRichard Deeming18-Nov-14 6:00 
I can't reproduce the problem using your SQL Fiddle data and the code I posted.


<Body><p align="justify">One is a 1m block of <a href="pagename.aspx?tag=AIREM 2006-1X 2A3>AIREM 2006-1X 2A3</a>, which has never appeared on SMO.<p></Body>


<body>It consists of: <a href="pagename.aspx?tag=BANKP>BANKP</a>, <a href="pagename.aspx?tag=BCJA>BCJA</a>, <a href="pagename.aspx?tag=BCJA>BCJA</a>M, <a href="pagename.aspx?tag=<a href="pagename.aspx?tag=BFTH>BFTH</a>><a href="pagename.aspx?tag=BFTH>BFTH</a></a>, <a href="pagename.aspx?tag=<a href="pagename.aspx?tag=BFTH>BFTH</a>><a href="pagename.aspx?tag=BFTH>BFTH</a></a>, and <a href="pagename.aspx?tag=EMPOP>EMPOP</a>.</body>


SQL
DECLARE @XML nvarchar(max);

SELECT
  @XML = XML
FROM
  article
WHERE
  id = '1'
;

SELECT
  @XML = Replace(@XML, [Name], N'<a href="pagename.aspx?tag=' + [Name] + N'>' + [Name] + N'</a>')
FROM
  [dbo].[database_tags]
WHERE
  @XML LIKE N'%' + [Name] + N'%'
;

SELECT @XML As Result;


NB: You should avoid using text, ntext or image types in SQL. They are deprecated and will be removed in a future version[^]. Use varchar(max), nvarchar(max) and varbinary(max) instead.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
PhilLenoir18-Nov-14 10:41
professionalPhilLenoir18-Nov-14 10:41 
GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
miss78620-Nov-14 1:45
miss78620-Nov-14 1:45 
GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
PhilLenoir20-Nov-14 3:13
professionalPhilLenoir20-Nov-14 3:13 
AnswerRe: SQL Replace Function - error recognizing two or more strings Pin
PhilLenoir18-Nov-14 3:41
professionalPhilLenoir18-Nov-14 3:41 
Questionsuggest various tables for shopping site Pin
smart_vikas12-Nov-14 18:53
smart_vikas12-Nov-14 18:53 
AnswerRe: suggest various tables for shopping site Pin
Jörgen Andersson12-Nov-14 19:59
professionalJörgen Andersson12-Nov-14 19:59 
AnswerRe: suggest various tables for shopping site Pin
Mycroft Holmes12-Nov-14 22:40
professionalMycroft Holmes12-Nov-14 22:40 
QuestionRe: suggest various tables for shopping site Pin
Eddy Vluggen13-Nov-14 7:18
professionalEddy Vluggen13-Nov-14 7:18 
AnswerRe: suggest various tables for shopping site Pin
PIEBALDconsult13-Nov-14 7:35
mvePIEBALDconsult13-Nov-14 7:35 
QuestionLONGTEXT not accepting large text! Pin
Jassim Rahma12-Nov-14 9:15
Jassim Rahma12-Nov-14 9:15 
AnswerRe: LONGTEXT not accepting large text! Pin
PIEBALDconsult12-Nov-14 9:20
mvePIEBALDconsult12-Nov-14 9:20 
GeneralRe: LONGTEXT not accepting large text! Pin
Jassim Rahma12-Nov-14 9:51
Jassim Rahma12-Nov-14 9:51 
AnswerRe: LONGTEXT not accepting large text! Pin
Richard Deeming12-Nov-14 9:55
mveRichard Deeming12-Nov-14 9:55 
GeneralRe: LONGTEXT not accepting large text! Pin
Jassim Rahma12-Nov-14 9:59
Jassim Rahma12-Nov-14 9:59 
GeneralRe: LONGTEXT not accepting large text! Pin
Richard Deeming12-Nov-14 10:03
mveRichard Deeming12-Nov-14 10:03 
GeneralRe: LONGTEXT not accepting large text! Pin
Jassim Rahma12-Nov-14 10:08
Jassim Rahma12-Nov-14 10:08 
GeneralRe: LONGTEXT not accepting large text! Pin
Richard Deeming12-Nov-14 10:12
mveRichard Deeming12-Nov-14 10:12 

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.