Viewing 15 posts - 826 through 840 (of 1,838 total)
Brandie Tarvin - Friday, August 4, 2017 4:35 AM...My whole day is going to be like this now. I just know it.
Hope...
August 4, 2017 at 10:57 am
I use PowerShell scripting periodically, but mainly for things that would be too complicated to script in a .CMD batch file. Those handle parameters well, but calculations and expressions can...
July 31, 2017 at 2:28 pm
I guess the main point I'd like to make is the quiz UI in general is good, but you might want to give some explanation for your answers at the...
July 31, 2017 at 1:31 pm
CONCAT errors in SQL Server 2008 because it wasn't added to TSQL until 2012:
https://docs.microsoft.com/en-us/sql/t-sql/functions/concat-transact-sql
July 31, 2017 at 1:13 pm
I had a question about your first question, in what databases are DMVs stored in. I selected ALL, which the quiz said was wrong. However, I can clearly see many...
July 31, 2017 at 12:56 pm
using the technique described here:
http://improve.dk/sql-server-datetime-rounding-made-easy/
you probably want to declare your variable as NVARCHAR:DECLARE @date
July 31, 2017 at 12:18 pm
July 31, 2017 at 8:18 am
I notice the proposed solution took absolute value of date difference, so it could include ones that end after the 12-31-2017 date.
ROW_NUMBER() evaluation can be good, but depending...
July 31, 2017 at 7:26 am
I'm afraid my PL/SQL is a bit rusty, I haven't really worked with it since Oracle 9. I did find an article though that mentions in 10G they added something...
July 28, 2017 at 11:45 am
July 28, 2017 at 10:41 am
if you can't use IDENTITY, can you use a SEQUENCE? That would allow you to get new values after each run, and you not having to worry about querying MAX(WorkCommentID)...
July 28, 2017 at 10:39 am
if the trust is setup, you can add the active directory logins to the instance just as you would if they were from domain A:
July 27, 2017 at 3:28 pm
the NT user in that case is technically not orphaned, because the active directory group they are in has a login. The user can still have permissions that the rest...
July 26, 2017 at 1:45 pm
July 26, 2017 at 11:33 am
left joining server_principals to database_principals will work for SQL Authenticated users, but this query shows some false positives for database users that do have a login which is a windows...
July 26, 2017 at 10:06 am
Viewing 15 posts - 826 through 840 (of 1,838 total)