Posts
Sort by recent activity
Removal of space before FROM in sub-query undesired, how to stop it?
I have the following Sql query and Sql Prompt insists on removing the space before the FROM in the sub-query every time. How do I stop this?SELECT TOP (50000000)
[Id] , [SourceBranch]
...
Valid Sql merge statement fails Sql Prompt layout
The below valid sql stored proc fails the layout command in Sql Prompt. Why?
<bbcode>
create PROCEDURE dbo.usp_mrg_JournyxTimeRecs
AS
BEGIN
SET NOCOUNT ON;
MERGE INTO dbo.journyx_time_recs T
USING...
Unable to restore backup sqb file
Well, this is depressing. I have hundreds of sqb backup files and this is the first time I'm trying to restore one ever! when I do, I get the error shown in the attached image file. what can I d...
DateTimeOffset support not working
I have 2 databases with several tables that contain datetimeoffset fields. I have emptied one of the databases so that sdc10 will basically be doing a move from one db to the other and the script ...
Strange failure of Data Compare
I often use SQL Data Compare and recently have been running into some strange results. I compare 2 dbs, select synchronization of the differences (which happen to be in float columns) and then whe...