SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• How to ALTER COLUMN without SELECT and UPDATE permissions

  I try to ALTER a column by changing the datatype from integer to NUMERIC(35,10).  IMPORTANT : The u…

  Pete Softown

  7 replies

  5 years ago

  By: Jeff Moden

• filter by WHERE has no effect

  SQL WHERE clause not working trying to filter by date "WHERE [dtmDocDate] >= '2020-09-01'" has n…

  onechipshot

  8 replies

  5 years ago

  By: onechipshot

• Question on BCP

  I have been looking everywhere, and cannot find anything on this . Can anyone tele me if you can us…

  itmasterw 60042

  13 replies

  5 years ago

  By: itmasterw 60042

• must be drop table ?

  Hello, i'm an Italian developer (excuse me for my english). I have a Store Procedure like this BEGI…

  Alessandro Andreatta

  3 replies

  5 years ago

  By: DesNorton

• SchemaBinding and Temporal Tables

  I have schema bound a view to a temporal (system-versioned) table and receive no errors in doing do…

  dandschulz1433

  2 replies

  5 years ago

  By: Bredon

• Subquery returned more than 1 value. This is not permitted !

  Hello, I run the following query: SELECT RIS_OPT_SERV.CTC_DEPOT ,CONVERT(CHAR(4), B.DATE_DE…

  silbahi

  3 replies

  5 years ago

  By: Jonathan AC Roberts

• SSIS SQL Agent Job - SQL Step referring other server

  Hi there, everyone. I have a bit of a pickle. I need to move all our SSIS jobs from one server to a…

  darkangelBDF

  2 replies

  5 years ago

  By: darkangelBDF

• tune a table valued function that is using recursive CTE

  We have a function that calculates student truancy records by counting their absence in a moving 30…

  sqlfriend

  15 replies

  5 years ago

  By: VoldemarG

• Only lists records when StockValue changes

  Good day, After running below create and insert scripts, my query should only return the rows in bl…

  waldemar

  6 replies

  5 years ago

  By: waldemar

• Is Fuzzy Matching available in SQL 2019 Standard?

  Hey folks. I can't seem to find a definitive answer to what seems like it ought to be a really simp…

  danchard

  4 replies

  5 years ago

  By: Steve Jones - SSC Editor

• How to stop a user creating a new table

  I'm experiencing a problem where tables in my SQL Server database are getting randomly re-created a…

  Rupster

  6 replies

  5 years ago

  By: Rupster

• T-SQL SubQuery Help Please

  Hi, I know this will be rather obvious to many, but I am struggling writing a sub-query at the mome…

  gs1975

  6 replies

  5 years ago

  By: gs1975

• String Manipulation Work?

  Hello Geniuses, I have a string manipulation task that I am not sure is even possible...   Her…

  sqlislife

  2 replies

  5 years ago

  By: sqlislife

• Where statment is not working when reference to table

  Good day today i manage to come across a problem when i am using where statment in my quri and refe…

  Deimos_farm

  5 replies

  5 years ago

  By: Deimos_farm

• Help with non-clustered index fragmentation

  I'm trying to rebuild indexes to clear some heavy fragmentation in the nonclustered indexes.  I've …

  rando

  3 replies

  5 years ago

  By: Jeff Moden