ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login
    1. Topics
    2. Tags
    3. t-sql
    Log in to post
    • All categories
    • scottalanmillerS

      Restoring a Windows MS SQL Server Database to Linux With Move SQLCMD

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion sql server 2012 sql server 2014 sql server 2016 sql server 2017 sql server 2019 ubuntu linux database t-sql
      3
      2 Votes
      3 Posts
      928 Views
      scottalanmillerS

      @jaredbusch said in Restoring a Windows MS SQL Server Database to Linux With Move SQLCMD:

      @scottalanmiller I have not had to do that before with a normal backup to a .bak and then restore. Not some an place move like it seems you are doing.

      Happens if going to a space with a different storage layout. If you are coming from Linux you are probably fine. But Windows injects the drive letter into the path (obviously) and so going from one machine to another that doesn't keep identical storage path names causes the issue.

    • garak0410G

      SQL Question - Removing Part Of A Field

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion lightswitch sql server sql t-sql
      18
      0 Votes
      18 Posts
      4k Views
      JaredBuschJ

      @NetworkNerd said:

      If I understand correctly, that code snippet is only for a validation that will be run against the Phone1 field. Are you just trying to throw up a validation error on a web page or within an application if a proper phone number is not entered in the PHONE1 field?

      He wants to extract out the first 10 digits of the PHONE1 field and present them to the application / page as the phone number so that the native regional formatting of 10 digit TN handles it correctly.

    • 1 / 1