Search
-
Formatting help
Discussion by CraigRichards · · Home› Discontinued and Previous Versions› SQL Prompt Previous VersionsDoes anyone know how to get the following formatting to work? From IF EXISTS ( SELECT TOP 1 1 FROM inserted ) IF EXISTS ( SELECT TOP 1 1 FROM deleted ) /*Update Block*/ To IF EXISTS ( SELECT TOP 1 1 FROM inserted ) IF EXISTS ( SELECT TOP 1 1 FROM deleted ) AND This FROM deleted INNER JOIN INSERTED ON DELETED.PeopleId =… -
SQL Source Control
I want to buy SQL Source Control for my company and needed some clarification. Came across the pricing below and not sure about the '1 license' part. $495 Total (excluding VAT) 1 license 1 year of support & upgrades What is 1 licence means? 1 User? 1 user multiple activation? 1 Machine? if means 1 user multiple activation,… -
How to generate the consistent result for multiple days of data.
I am using SQL Data generator first time and trying to generate the data for following scenario for stress test. Scenario : I am trying to populate the MasterData in DailyFeedData table for each Business Day. BusinessDay_Id and MasterData_Id are foreign keys. The problem is Generator is populating the data in random… -
Re: Build server pipeline failing after auto-update of SQL Change Automation (v 4.4.22194.30982)
Hi It looks like a similar issue might have occurred again? TeamCity server version is 2022.10.2 (build 117025) RedGate SQL Change Automation Plugin: 5.0.7 [15:38:05] : [Step 1/6] Invoke-DatabaseBuild, SQL Change Automation 4.5.23032.654, Copyright ¸ Red Gate Software Ltd 2014-2023 ... [15:38:05] : [Step 1/6]… -
Can not get access to localDb
When attempting to install server components for localDb, I get could not find (shows my machine name) which is the machine I'm on and zero problem when doing the same for SQLEXPRESS (which works). So step 1 fails and I am a admin on this machine, step 2 validates, never get to step 3 but selected windows authentication. -
Re: memory issue
-
bug:Case and when become a word.
-
An unexpected null value has been found while running postprocessing operations on the script databa
-
Re: Connection failed Internal SQL Monitor error "namespace root/mscluster is invalid"
-
SQL Data Generator, Datatype: hierarchyid
We are testing SQL Data Generator. we have a table with a hierarchy ID column: / /1/ / 1/1 / / 1/1/1 / / 1/1/2 / / 2 / / 2/1 / etc. With the data generator we can generate hierarchyid data without problems: / 1002/16262/19222/14780 / / 10021/14301/8796/8797 / / 10036/18117/24409/28027 / etc. But the generated values do not…
>5989 results