Replace function in TEXT or NTEXT fields SQL Server We often use replace function in SQL server databases to find and replace a specific string. The SQL statement is straightforward and there is no any issue when we search and replace a string on a column with a datatype, not either TEXT or NTEXT. The general search and replace SQL statement is UPDATE tbl_name SET column_name = REPLACE(column_name, 'old_string', 'new_string') WHERE column_name like '%old_string%' The problem occurs when you try to search and replace a string on a column with datatype TEXT or NTEXT and the error message: Argument data type text is invalid for argument 1 of replace function. and SQL server do not have any recommendation on how to resolve, probably we know REPLACE function only work on varchar or nvarchar datatype The simplest way is converted TEXT or NTEXT data to NVARCHAR(MAX) and then use Replace function. Using below query you can replace string in TEXT or NTEXT data type column. UPDATE tbl_name SET column_name = CAST(REPLACE(CAST(column_name as nvarchar(MAX)),'old_string','new_string') AS NText) WHERE column_name LIKE '%old_string% This way you can replace strings in TEXT or NTEXT column.

Multiple pages on a Netlify github-deployed website?

AnotherOps

I recently deployed a website from Netlify using a demo github repo that I copied. Although it seems pretty straightforward at first, I know too little about JS, html, and CSS to continue. I'm only looking to host three pages that contain only text and hyperlinks, but I cannot for the life of me figure out how to implement more than one page with this particular code base I started with. Here's the index.js script:

import Head from 'next/head'
import Header from '@components/Header'
import Footer from '@components/Footer'

export default function Home() {
  return (
    <div className="container">
    <div className="container-1">
    
      
      <Head>
        <title>Cool Page Title</title>
        <link rel="icon" href="/coolicon.ico" />
      </Head>

    
      <div className="box-1">
        <h3>Links</h3>
        <p>
          Current page <br /> 
          Page 2 <br /> 
          Another Page
        </p>
      </div>
    
    
      <div className="box-2">
        <h3>My cool page</h3>
        <p>
          Site under construction. <br />
          For all inquiries, please call 555-5555
        </p>
      </div>
   
    </div>
    
    <div className="container-2">
      <Footer />
    </div>
    </div>
  )
}

The syntax is the really tricky part for me. The Home() function seems to return the html for the home page, so then how would I implement a second page and have the links change them out? Would a switch/case statement work here?