Viewing 6 posts - 1 through 7 (of 7 total)
The behavior of SQL Server's sqlcmd utility when writing a file to a shared directory can depend on several factors, including the version of SQL Server, the network configuration, and...
September 14, 2023 at 1:16 pm
The error you're encountering, "Invalid object name '#partA'," is likely due to the fact that you're trying to drop or insert data into temporary tables conditionally based on the value...
September 11, 2023 at 1:13 pm
To read data from a DB2 database on SQL Server 2017, you can use the Linked Server feature. First, create a linked server using the "sp_addlinkedserver" system stored procedure. Specify...
August 17, 2023 at 1:41 pm
To achieve the desired logic, you can use nested CASE statements to combine the conditions and determine the overall color. Here's an example:
CASE
WHEN
(
(
ISNULL(FORMAT((SUM(CASE WHEN [CAS_AT].[Event_Code] IN (@EC01, @EC02) THEN 1.0...
July 6, 2023 at 12:03 pm
In Microsoft SQL, you can find the spaces between the first and last name using various string manipulation functions. One approach is to use the CHARINDEX function, which returns the...
July 5, 2023 at 12:58 pm
Yes, it is possible to export Data Classification recommendations as a PDF or text file. Here are the steps to do so in Microsoft 365 Compliance Center:
April 29, 2023 at 12:54 pm
Viewing 6 posts - 1 through 7 (of 7 total)