Viewing 15 posts - 481 through 495 (of 6,036 total)
DinoRS - Friday, September 14, 2018 5:39 AMProbably you have never seen any use for geospatial data either.
Name it.
September 14, 2018 at 7:46 am
September 13, 2018 at 10:45 pm
September 12, 2018 at 7:50 pm
September 12, 2018 at 7:37 pm
You paid so much attention to catching errors that you forgot about error-less run.
What if there are no errors?
You execute
COMMIT TRANSACTION
END TRY
then you...
September 12, 2018 at 7:27 pm
Conversion to integer happens not on multiplication but on applying the result to the function parameter.
60 is implicitly converted to decimal anyway.
September 11, 2018 at 4:10 pm
I cannot see anything from OfacValidation v used anywhere else in the query:SELECT
@CreatedBy_AssociateID AS CreatedBy_AssociateID,
@RunDateTime AS CreatedDateTime,
@CreatedBy_AssociateID AS UpdatedBy_AssociateID,
@RunDateTime ...
September 10, 2018 at 7:30 am
Add a new step at the end of the first job:exec msdb.[dbo].[sp_start_job]
Parameters:
@job_name sysname = NULL,
@job_id UNIQUEIDENTIFIER...
September 9, 2018 at 6:33 pm
SQL Server does not discard query results immediately after presenting it to a user.
All resultsets stay in memory cache in case they're are requested again.
They are removed from...
September 9, 2018 at 5:58 pm
DELETE dbo.<table_name1> WITH (READPAST)
FROM dbo.<table_name1>...
September 9, 2018 at 5:46 pm
In the MS SQL database world, there's only one cert that one can trust...
September 7, 2018 at 3:02 pm
ChrisM@Work - Friday, September 7, 2018 7:06 AMI can spell most of those big words. What's the rate?
Don't expect too much.
Some...
September 7, 2018 at 7:32 am
September 7, 2018 at 7:21 am
Here is the screenshot of a fresh job description.
Seems like ticks all the boxes.
🙂
September 7, 2018 at 7:01 am
Viewing 15 posts - 481 through 495 (of 6,036 total)