SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Temp Tables Used within Procedure giving error in one 2019 sql server instance

  I have Three stored Procedures A,B,C C is a common procedure which derives data into a common table…

  sachinleo78

  16 replies

  1 year, 9 months ago

  By: sachinleo78

• Managed Instance: Resource alerts with db_mail for usage and notifications?

  Hello SQLServerCentral community, I'm looking for guidance on setting up resource alerts for Manage…

  jamssyyy

  1 replies

  1 year, 9 months ago

  By: Site Owners

• JSON data with Pivoted

  Hi All, I need some assistance and not sure how to achieve the expected output. I have a JSON input…

  Tava

  29 replies

  1 year, 9 months ago

  By: Tava

• SQL2019 ODBC Connection from Linux setup help.

  I can connect to the sql server 2019  from my linux machine with tsql but not with isql or with PHP…

  kat35601

  7 replies

  1 year, 9 months ago

  By: kat35601

• Get text from table and join with BIT column on table 2

  Ok, not sure how to explain this 100%. Here is the issue. I have 2 tables (can't post actual schema…

  DotNetCoder

  7 replies

  1 year, 9 months ago

  By: DotNetCoder

• How to write to a file from SQL Server running on Docker Container on Linux

  So we have a SQL Server database running in a Docker Container on Linux There is a stored procedure…

  Weegee71

  8 replies

  1 year, 9 months ago

  By: Weegee71

• Selecting from a view, base table has a DENY on a column

  This is something I've never seen before and I can't think of the right way to search properly for …

  pveilleux

  17 replies

  1 year, 9 months ago

  By: Thom A

• Table Migration script copying over more rows than intended

  All, I am attempting to perform a table migration for one table (tableA) from my source database (d…

  GBeezy

  8 replies

  1 year, 9 months ago

  By: Jeff Moden

• Query to get the previous row from the row selected

  Hi I have payroll detail table in which I have payroll details id and an employee id (foreign key f…

  tgopi99@yahoo.com

  18 replies

  1 year, 10 months ago

  By: Ed B

• Cant extract values from JSON Array

  Hi there I am trying to extract values from a JSON array object but struggling so my code is as fol…

  Weegee71

  21 replies

  1 year, 10 months ago

  By: Steve Collins

• Validation of special char and replace for the good one

  Hello I need help on how to do this more efficient. I will need to write a store procedure to valid…

  Mond

  1 replies

  1 year, 10 months ago

  By: frederico_fonseca

• Improving Code Readability

  Below is a code i wanted to improve some readability and functionality: GO /****** Object: View […

  yrstruly

  7 replies

  1 year, 10 months ago

  By: Mr. Brian Gale

• converting date

  cast(DATEADD(DAY, case when j1 is null then 0 else j1 end, j_date) as date) as 'DateEnd', I get res…

  juliava

  6 replies

  1 year, 10 months ago

  By: frederico_fonseca

• Powershell, how to convert file to txt pipe

  Hello, how can I change this code to txt pipe format? $DataSet.Tables[0] | Export-csv -Path "C:\Tes…

  juliava

  2 replies

  1 year, 10 months ago

  By: juliava

• Script all logins, permissions, roles

  I found this older script by Greg Ryan in 2013 to script out all the logins, permissions, roles.  h…

  lan2022nguyen

  3 replies

  1 year, 10 months ago

  By: rothj