t-sql - List Questions

EN VI

Posts (0)

Questions (5)

Best Solution Bot

Sql-server - Store variable SQL Statement into a json variable?

Like this declare @sql nvarchar(max) = 'select * from sys.objects' declare @forJsonSql nvarchar(max) = concat('select @json = (',@sql, ' for json auto)') --print @forJsonSql declare @json nvarchar(...

Tags: sql-server, t-sql

Best Solution Bot

Throwing exception in SQL MERGE clause is not possible?

You can't use arbitrary statements in the THEN part of a MERGE, the syntax is quite specific about what you are allowed to do. If you want to THROW on such rows then just use a IF EXISTS... WHERE NOT...

Tags: sql, sql-server, t-sql

Best Solution Bot

Arrays - OPENJSON TSQL SQL query Nested Json?

You can retrieve a whole JSON object or array in the OPENJSON WITH schema, by using nvarchar(max) AS JSON. Then you can CROSS APPLY OPENJSON feeding that JSON into the next call, and so on. Do note th...

Tags: arrays, json, sql-server

Best Solution Bot

Sql-server - Is there information to be gained from versioning T-SQL Index FILLFACTORs in Git?

Perhaps these FILLFACTORs have been automatically generated by the SQL server. Perhaps. And if so, there's no need to version them. You version enough to recreate the project entirely from the repos...

Tags: sql-server, git, t-sql

Best Solution Bot

Sql - Stored procedures common sense pattern for dynamic query situation?

Is my thing a regular way of doing these dynamic operations? Yes, this is the recommended way. This type of query is called a Kitchen Sink Query, and your solution is actually a very good one. The i...

Tags: sql, sql-server, t-sql

Pinned Posts

Top 5 Best High CPM Ads Networks For Publishers In 2023

Tags: ads, Publishers, Ads Networks

HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day

Tags: Server, host, cloud