Viewing 2 posts - 1 through 3 (of 3 total)
SELECT * FROM testDiffTypeSameCol WHERE ( (IssueNo = 2 AND TRY_CONVERT(numeric(15,2), StringNumeric) > 1.0) OR (IssueNo = 1 AND SUBSTRING(StringNumeric, 1, 4) = 'this') );
February 17, 2025 at 9:14 am
In MS SQL Server, there is no direct equivalent to Oracle’s ROWID.
However, there are several alternatives depending on what you need to achieve:
WHERE a.id IN (...
February 16, 2025 at 4:50 am
Viewing 2 posts - 1 through 3 (of 3 total)