Is there a way to SET DATEFIRST server or database wide? I need Saturday be first day of the…
20 hours, 19 minutes ago
By: Jeff Moden
I am using the below query to fetch a data from SQL server. But the query returned Invalid leng…
1 day, 3 hours ago
By: Jonathan AC Roberts
Do we have any way to find out the space occupied by individual records in a table? My obje…
1 day, 5 hours ago
Hi, I am brand new to SQL. I'm using postgres with PopSQL interface.
I am trying to run the follo…
1 day, 6 hours ago
What I have missed from this code?
I'm trying to show the DateTimeRaised field as a week ending Sun…
1 day, 8 hours ago
By: Mr. Brian Gale
I am having issues parsing the following Json string using openjson. I am having problem…
2 days, 9 hours ago
By: Paul Stasny
What is the DBA world consensus on using this to implement databases for an application? An applica…
4 days, 7 hours ago
I created a SSIS package in Visual Studio Community 2019:
Everything is working fine,…
4 days, 12 hours ago
Are there app developers in this forum? Where does your app's SQL live?
I'm out with a new vers…
4 days, 23 hours ago
I am working a lot with SQL Server and Python and after updating the SQL Server from 2017 to 201…
5 days, 10 hours ago
I am testing two examples in which a WHERE clause is compared to the results of a subquery.
6 days ago
I am testing the TRY_CONVERT( ). Here is my code:
SELECT TRY_CONVERT(int, 'ABC') as Result; -- …
I have a query that looks something like this
from table a
inner join (select …
1 week, 1 day ago
By: Jeffrey Williams
I am testing on the AdventureWorks database (the OLTP version, not the data warehouse version). T…
I want this function to retrieve the latest buyer from two databases db1 and db2.
It worked for a…
1 week, 2 days ago
Viewing 15 topics - 1 through 15 (of 186 total)
You must be logged in to create new topics.