Viewing 15 posts - 1 through 15 (of 722 total)
Why are you still planning to run SQL Server from a laptop instead of an actual server or at least a regular (desktop) PC?
January 15, 2025 at 1:48 pm
Did you install SQL Server Express Advanced or LocalDB package (rather than "regular" Express)? They appear to be the only ones that actually install LocalDB.
On command line, what does
January 10, 2025 at 5:51 pm
' A' is not equal to 'A' -- leading space in the in example):
SELECT * FROM #Results
WHERE 1=1 AND [Column1] in ('A') AND [Column2] = 'B'
January 8, 2025 at 10:25 pm
What discrepancy?
Both queries should return nothing (if AnotherColumn is in SomeView), since AnotherColumn can't equal both 'XYZ' and '1'.
Is the leading space intended in 'XYZ'?
Negated/clarified by example
January 8, 2025 at 10:14 pm
The change in database focus only occurs within the scope of the dynamic sql session. Your "outer" session is still using whatever database you were using prior to executing sp_executesql.
December 23, 2024 at 9:52 pm
You could use a parameter to let user choose server, & programmatically derive the connection string & dataset. See links below
Or -- not recommended -- you could embed all 100...
December 5, 2024 at 7:26 pm
They are probably right. There is probably no value in that column (not to mention the ambiguous "ID" name) unless you are using an ORM or other tool/framework that insists...
November 26, 2024 at 10:10 pm
What do you mean by "Update routine"? A stored procedure? A script? Or ORM or other C# code
If SQL code add something like
SELECT @@ROWCOUNT AS UpdatedCount
directly after...
October 29, 2024 at 3:16 pm
Just exclude first_name & last_name from the constraint -- per your new requirement, they are no longer part of the definition of unique. e.g.,
CREATE UNIQUE INDEX ix_unique_email
ON...
October 2, 2024 at 2:43 pm
4 versions of this post -- reply to https://www.sqlservercentral.com/forums/topic/between-datetime-statement-not-working-4 which seems to be the one being updated.
October 2, 2024 at 2:28 pm
4 versions of this post -- reply to https://www.sqlservercentral.com/forums/topic/between-datetime-statement-not-working-4 which seems to be the one being updated.
October 2, 2024 at 2:28 pm
4 versions of this post -- reply to https://www.sqlservercentral.com/forums/topic/between-datetime-statement-not-working-4 which seems to be the one being updated.
October 2, 2024 at 2:28 pm
Just use UNION ALL between the two selects you're using for the inserts into the temp tables, and eliminate the rest.
September 18, 2024 at 1:24 pm
Unintentional duplicate due to delay in save.
September 18, 2024 at 1:24 pm
If it is truly indexed appropriately (and filtered indexes may be a part of that), then none of the other approaches may be needed to maintain performance at that level.
What...
September 9, 2024 at 1:50 pm
Viewing 15 posts - 1 through 15 (of 722 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy