Search
-
Why does the formatting not update the casing of the fields?
Hi, See enclosed image. The columns are all defined in the table as UPPERCASE. For some reason, when formatting the document, it recognizes the FIDPERS in the second half of the union, but it doesn't in the first half of the union. Can we fix this please? I did check the casing for "user defined" but it's only working half… -
How is a schema created and used?
I had thought that a database schema was the name of the structure on which tables are interconnected by primary keys and foreign keys. But in the tool, Azure Data Studio, the user is asked to select from a pre-defined set of schemas when creating a table. What is more is that when setting up or createing a database… -
How to create user defined actions like this?
-
Re: Does flyway community edition is suitable for commercial projects?
-
SQL Prompt will not "Select in Object Explorer" for User-Defined Table Types.
-
SQL Source Control not picking up a User-Defined Table Type
Hi, We make use of a User-Defined Table Type in our stored procedures. User Defined is enabled in the filter, we only exclude roles, users and security policy. Any idea why source control is not picking up the user defined table Type and any suggestion how I can get this table type in the version control? Without the… -
Re: Why does SQL Clone create VHD Size of 2TB for each clone?
Thanks Squigley for the answer. I was merely asking about the VHDs and why the 2TB is a pre defined value. I have an instance that has 5 cloned DB images presented to it and in turn this has added 5 2TB VHDs onto the server, none of the Images are anywhere near that size. Is there a way to change the 2TB value to a lower… -
Sql Prompt for ADS
Sql Prompt for ADS is lackin the ability to import snippets that have multiple prefixes defined. ADS has the ability to define a prefix for a snippet as follows: "Inner join": { "prefix": ["inner","ij"], "description": "inner join fragment", "body": [ "inner join " ] }, The prefix for the inner join snippet is triggered by… -
BUG: wrong update script for User-defined table types
Hi, we notice one problem - when we change user-defined table type and than do compare with previous version, produced update script is wrong. PROBLEM: Sql Compare build script which will first try to drop user-defined table type, what will lead to error by execution, while user-defined table type still have dependency(s)… -
Update user-defined function used by computed column
Discussion by jstangroome · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsWe have a table containing a computed column that uses an expression calling a scalar user-defined function. When we alter our user-defined function we temporarily change the table's computed column expression to (0) or ('') as appropriate for the column data type. We can then alter the user-defined function without…
941 results