SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• when check directory at shared path remotely it display not exist (false) althou

  when check directory at shared path remotely it display not exist (false) although it exists I have…

  ahmed_elbarbary.2010

  4 replies

  3 years, 10 months ago

  By: Jeff Moden

• Finding Special Characters in Email Address

  Hi All, I have to find the special characters in email address apart from alphabets, numbers SELECT…

  sathishkm

  1 replies

  3 years, 10 months ago

  By: Jeff Moden

• Calculate a new field in SQL statement

  I have need calculate new field on this logic Is there way to do in SQL instead of procedure or fun…

  sks_989

  4 replies

  3 years, 10 months ago

  By: sks_989

• Can´t delete foreign key

  Hi there, I try to delete a foreign key with ALTER TABLE [dbo].[Projektplanung] DROP CONSTRAINT [Pr…

  Sachers

  4 replies

  3 years, 10 months ago

  By: Ed B

• Error converting data type varchar to numeric issue

  I tried a lot of things to fix it, and no success. I have a field called MASTER_BOL_NUMBER . Accord…

  JeremyU

  5 replies

  3 years, 10 months ago

  By: Phil Parkin

• How to modify python script to append data on file using sql server 2019?

  I need to append data to excel file already exist from table students on SQL Server . Excel file al…

  ahmed_elbarbary.2010

  3 replies

  3 years, 10 months ago

  By: Phil Parkin

• Extracting first three words from Address field

  I am trying to standardize an address field.  I want to extract the first three words of the full a…

  Kin16

  2 replies

  3 years, 10 months ago

  By: Jeff Moden

• Issue "Error converting data type varchar to numeric."

  Hello, I am not sure why but I have a difficult time selecting fields that have a value 'X' in one …

  JeremyU

  14 replies

  3 years, 10 months ago

  By: Ed B

• Count a new field in SQL statement

  Hello all, I am trying to find a query that bring results like on the example. Thanks a lot all and…

  giladsh

  3 replies

  3 years, 10 months ago

  By: Jeff Moden

• SQL Query Best Approach Recommendations

    */This topic was modified 3 years, 10 months ago by RenzoSQL.

  RenzoSQL

  7 replies

  3 years, 10 months ago

  By: RenzoSQL

• Need to rearrange order of names from a fullname column to LAST, SUFFIX, FIRST

  I currently have a FULLNAME field that is first last and suffix (Laverne Holley, LPN). I am trying …

  shel 29143

  3 replies

  3 years, 10 months ago

  By: Thom A

• How to get an SQL Statement that would clone a table with data?

  Hello, I have a table and would like to clone it. I have an admin access to SQL queries. No access …

  jbeclapez

  8 replies

  3 years, 10 months ago

  By: jbeclapez

• Get data for last 4 week and issue \"Arithmetic overflow error for type varchar\"

  I am trying to get data only for last 4 weeks. My field where I have dates is called [WED], what I …

  JeremyU

  8 replies

  3 years, 10 months ago

  By: Jeff Moden

• Substring charindex Mid - Get name within String

  Hi, I am trying to get the name  inbetween the forward slash / for the column Full List There are c…

  SQL_Kills

  7 replies

  3 years, 10 months ago

  By: Jeff Moden

• Get Saturday from the week specified in column

  Hello everyone, I have such an issue. I have a column S1SDAT  that contains dates within the week p…

  JeremyU

  14 replies

  3 years, 10 months ago

  By: Jeff Moden