Viewing 15 posts - 76 through 90 (of 825 total)
The explanation is that constant numbers are evaluated as one token! It doesn't matter if there is not a space at the end of the constant
These queries are equivalent:
August 26, 2019 at 7:28 am
I should try, but I think that if you specify "header=true or false" the first row contains column names (true= less names than columns, false=same number for names and columns.
August 7, 2019 at 1:34 pm
I found this in the syntax:
"header is set to TRUE if and only if the first row contains one fewer field than the number of columns."
So, because of the same...
August 7, 2019 at 7:53 am
The correct answer is: "The command seems to pause and hang, and the add file operation will run when the backup is complete."
From BOL: https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-2017
Interoperability
SQL Server uses an online...
July 18, 2019 at 8:03 am
Well done, "WAITFOR DELAY '00:00:05' " makes the difference.
June 17, 2019 at 9:18 am
My results:
Processed 5128 pages for database 'test', file 'test' on file 1.
100 percent processed.
Processed 3 pages for database 'test', file 'test_log' on file 1.
BACKUP DATABASE WITH DIFFERENTIAL successfully processed 5131...
June 17, 2019 at 7:45 am
Maybe R language is case sensitive? So, Sys.time() is the correct answer, but it's not in the list.
May 8, 2019 at 7:42 am
DBCC CHECKIDENT('dbo.SalesOrderHeader', RESEED, 0)Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your...
February 28, 2019 at 2:27 am
February 26, 2019 at 2:02 am
December 27, 2018 at 9:28 am
December 19, 2018 at 2:17 am
December 6, 2018 at 6:53 am
Viewing 15 posts - 76 through 90 (of 825 total)