Viewing 15 posts - 61 through 75 (of 812 total)
You also can create synonym without an existing object.
In your example you mismatched the synonym StagingSongs with SongStaging
CREATE SYNONYM SongStaging FOR #songs
GO
CREATE PROCEDURE dbo.LoadSongs
AS
INSERT Songs
(
songid,
title,
releasedate,
genre
)
SELECT songid,
title,
releasedate,
genre
FROM dbo.StagingSongs
WHERE...
September 6, 2019 at 6:56 am
The second dot is a "virtual AS".
Absolutely NO, but if you like to think so OK.
August 27, 2019 at 9:35 am
This clearly shows that if the expression before the dot is data type numeric,
then the expression after the dot is taken as a column name.
The dot is part of constant...
August 27, 2019 at 6:56 am
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
Viewing 15 posts - 61 through 75 (of 812 total)