Databases - TopAnswers

TopAnswers Databases

Meta

Databases

TeX

Code Golf

APL

C++

.net

db<>fiddle

Java

*nix

PHP

PowerShell

Python

Rust

टेक्-मराठी

Typst

Web Client Dev

Web Server Dev

Variable to select database in SQL query

sql-server-2017

James Jenkins James Jenkins

3 Per the [comment by Tibor Karaszi](https://dba.stackexchange.com/questions/253195/variable-to-select-database-in-sql-query#comment499255_253195) the change only applies "to the EXEC scope" This is validated by the Microsoft statement below.

James Jenkins

How to combine date and time to datetime2 in SQL Server?

sql-server

Martin Smith Martin Smith

5 This seems to work and keep the precision as well:

ypercubeᵀᴹ

5 Thought I'd share a simple method that is a bit shorter and some might find easier to read:

Brian Jorden

5 This approach, while similar to [ypercube's answer](https://topanswers.xyz/databases?q=1777#a2003), avoids the need to use any string conversion (which can be more expensive than date conversions), is deterministic, and should continue to work if Microsoft ever changes the default date value from 1900-01-01 (even though they probably wont change this):

knuckles

3 For SQL Server 2012 and above there is the [DATETIME2FROMPARTS](https://docs.microsoft.com/en-us/sql/t-sql/functions/datetime2fromparts-transact-sql) function. It has this form:

Michael Green

Incorrect Result with Apply

sql-server

Phist0ne Phist0ne

10 This is a bug in the way SQL Server decides whether a rebind is required with certain plan shapes. It has been in the product since SQL Server 2005.

Paul White

9 > is this a bug in SQL Server?

Martin Smith

Changing the use of GETDATE() in the entire database

sql-server-2017 azure-sql-database

Lamak Lamak

2 Rather than export, manually edit, and rerun, you could try do the job directly in the database with something like:

david spillett

1 > Dynamically alter all proc and udf to change value

kumarharsh

0 I have upvoted Evan Carrolls answer, as I think this is the *best* solution. I have not been able to convince my colleagues that they should change a lot of C# code, so I had to use the code that David Spillett wrote. I have fixed a couple of problems with UDFs, Dynamic SQL and Schemas (not all code use "dbo.") like this:

Henrik Staun Poulsen

0 I really like David's answer and upvoted that for a programmatic way of doing things.

sting

0 > What would be the best way to implement this change?

evan carroll

0 1. Use the SQL Server tool to export the database objects definition to a SQL file which should include: tables, views, triggers, SPs, functions, and so on

amg

Why does TSQL return the wrong value for POWER(2.,64.)?

sql-server azure-sql-database

Triynko Triynko

3 The result of 2^64^ is exactly representable in `float` (and `real` for that matter).

Paul White

2 From [the online documentation](https://docs.microsoft.com/en-us/sql/t-sql/functions/power-transact-sql), the implication is that whatever you pass as the first parameter is going to be implicitly cast to a `float(53)` *before* the function is executed. :

Jack Douglas

Is it possible to use OPENROWSET to import fixed width UTF8 encoded files?

sql-server azure-sql-database

Martin Smith Martin Smith

8 One workaround is to just change the format file to bring the whole line in, in bulk, and do the substring-ing in TSQL

Martin Smith

6 > from which I conclude the `LENGTH` is counting bytes rather than characters.

Paul White

SQL Server - How to achieve READCOMMITED and NOLOCK at the same time?

sql-server

mateus viccari mateus viccari

2 What you're looking for is an optimistic isolation level, like Snapshot Isolation, or Read Committed Snapshot Isolation.

meme

What to consider when setting flush_interval_seconds in SQL Query Store?

sql-server

James Jenkins James Jenkins

2 >Is query store data written to the log? If so would a restore let us recover any Query Store data, that had not been pushed to disk?

Kin Shah

Grouped string concatenation with XML PATH and STUFF error

sql-server-2008-r2

B McCarthy B McCarthy

5 Sorry, I missed a step in the relationship. Try this version (though [Martin's will work as well](https://pastebin.com/Fz601fDC)):

aaron bertrand

4 I thought I would try a solution using XML:

Paul White

Optimize extraction of json data via OPENJSON

sql-server-2019 azure-sql-database

Hannah Vernon Hannah Vernon

8 You should directly extract the values from the json array using the `WITH` clause, like this:

Biju jose

Hi guys. Someone found an issue in my SO answer and posted a [better one](https://stackoverflow.com/a/75035802/297408). Would be great if you could vote it up to make it more visible. Hopefully the OP notices and changes their choice too, although they don't seem to have been around lately.

Thinking about it, it's what we've already had since 2014, which was when the war actually began. Only at that time it was much less prominent and covered less area, hence the sense of normality was easier to maintain. Even here in Ukraine, many lived as though nothing was happening. "Yeah, we have some conflict in the eastern part, yeah, Russia's annexed Crimea, but other than that everything's fine, nothing to worry about." I have to admit that was very close to my way of thinking during those years. Partly the reason was that the conflict wasn't officially called a war, it was just an anti-terrorist operation. But for the people in Donbas it was as much an actual war as it's been for everyone since February 24th. Even so, most of Ukraine isn't occupied or near the front lines, so life must go on (as much as possible, yes).

@@@ wikipedia 837cbf123c919a5a39148a1e6f9fd6ef16e583e7e7d21ebef56e8b42d5e83ff7 4uKk "Battle of Kharkiv (2022)" "The Battle of Kharkiv is an ongoing military engagement taking place in and around the city of Kharkiv in Ukraine as part of the Eastern Ukraine offensive during the 2022 Russian invasion of Ukraine. Kharkiv, located just 32 kilometres (20 mi) south…"

@@@ wikipedia 70d0d831c20ee4ccf2f076823bd9084a87194c8c9222c8dba6a60ec38a627521 4wMH "Kharkiv" "Kharkiv, also known as Kharkov, is the second-largest city and municipality in Ukraine. Located in the northeast of the country, it is the largest city of the historic Slobozhanshchyna region. Kharkiv is the administrative centre of Kharkiv Oblast an…"