sql-server-2019-CodePudding

Tags > sql-server-2019

09-10databaseImproving and solving long running query
09-02Back-endHow to do calculations and then compare them in SQL Server
08-28Software engineeringConvert mixed format string datetime value to datetime datatype
08-26BlockchainColumn Datatypes Issue in sql server 2019 when Import Flatfile using SSIS
08-24Software designA question again on cursors in SQL Server
08-24Software designUsing C# CLR in SELECT and WHERE at the same time
08-21EnterpriseCreating JSON Nested Level Arrays with Query
08-19databaseGenerating self-closing xml tags for lists in SQL Server
08-19NetCalculate Time Difference between consecutive rows based on an condition in SQL Server 2019
08-12BlockchainShould I use sp_getapplock to prevent multiple instances of a stored procedure that conditionally in
08-06Software designOld SQL function using @@ROWCOUNT causing issues
07-25Software designStored procedure to add a new order which takes a list of products
07-20Software engineeringHow to query a variable number of rows from a values list?
07-19NetFilter SQL result by condition to recieve only one row per customer
07-06EnterpriseTSQL IF appears to randomly execute code from wrong logic branch
07-02NetSQL Server - How to create custom JSON from SELECT with "key": derived from GROUP BY claus
06-29MobileHow to get the first occurrence of a group of values with T-SQL
06-21Software engineeringHow to parse a string for specific values using PATINDEX and SUBSTRING?
06-18Blockchainsql server 2019 foreign key on multiple columns from different tables
06-16OSUnable to use ALIASES in subquery inside SQL Select clause
06-12Software engineeringHow to write where clause to consider the earlier date given 2 dates?
06-12databaseOPENJSON does not detect duplicated Value
06-09BlockchainHow to sign a SQL Server assembly created with assembly_bits / hex bytes?
06-06Back-endSign SQL Server assembly create with assembly_bits
06-03MobileHow to write where clause to consider the earlier date given 2 dates?
05-27Back-endReplacing a string over multiple rows
05-24NetReuse a subquery result in another column in main query
05-24MobileHow do I select the last non-empty value for a given ID and date
05-22databaseHow to use Trim in select queries for data in SQL tables
05-20databaseSQL, Trying to split Finnish addresses
05-20BlockchainCAST to TIME in select query is taking long time to execute
05-15OSHow to prevent SQL Server from stripping leading zeros when importing data
05-04MobileParsing XML Data using T-SQL
04-30BlockchainExtract data from XML document using t-sql
04-26MobileCreate function to returned the set of rows bases on the input parameter
04-20Software designSQL statement help : Select data based on a condition
04-16Back-endSame code errors in a Stored Procedure, works in T-SQL
04-09OSHow can I count the number of orders per customer
04-08Netusing STRING_AGG and the LAST_VALUE function in same request
04-06Mobile@@DATEFIRST not returning results as described in the docs

91 1 2 3 Next Last