Comments
Sort by recent activity
That's strange. Yep, seems like a bug. Reporting to the dev team [image] / comments
That's strange. Yep, seems like a bug. Reporting to the dev team
What version of SQL Prompt? Seems to work in v8 [image] / comments
What version of SQL Prompt? Seems to work in v8
Well, Prompt get remove if you reformat (CTRL+K,Y). As for removing on scripting, that's an SSMS function. We can't jump into that. Now, the Prompt menu with script as alter might be able to tag this together with a format, but I'm not sure. I think this is just calling the SSMS function.
Is there a reason reformatting doesn't work? / comments
Well, Prompt get remove if you reformat (CTRL+K,Y). As for removing on scripting, that's an SSMS function. We can't jump into that. Now, the Prompt menu with script as alter might be able to tag th...
This isn't SQL Prompt, at least, not necessarily. If you right click a procedure and choose script, you get SSMS defaults. If I do that, I get this: [image]
If I then reformat with SQL Prompt (CTRL+K, y), I get this: [image]
I have my formatting set to not use extra brackets [image] / comments
This isn't SQL Prompt, at least, not necessarily. If you right click a procedure and choose script, you get SSMS defaults. If I do that, I get this:
If I then reformat with SQL Prompt (CTRL+K, y), ...
Can you provide a bit more detail here? Are you trying to ignore specific tables, as in some random names? Are you looking to ignore those with a pattern?
One thing to look at is a SQL Compare filters: https://documentation.red-gate.com/display/SCO4/Viewing+the+comparison+results#Viewingthecomparisonresults-Usingthefilter
You can build a file and then use that as a command line switch: https://documentation.red-gate.com/display/SCO4/Command+line+switches#Commandlineswitches-/filter:<filterfile.scpf> / comments
Can you provide a bit more detail here? Are you trying to ignore specific tables, as in some random names? Are you looking to ignore those with a pattern?
One thing to look at is a SQL Compare filt...
We don't have the column picker in the UPDATE, which is a hole. I've noted this to the product team.
However, the pattern of adding the column name in there is interesting. I don't have a Prompt solution for you right now. Certainly, you could use Shift+ALT to help here. Here's what I'd do: https://youtu.be/XdIA0EFrXOU
Let me know if this helps. I've logged this with the team for discussion. / comments
We don't have the column picker in the UPDATE, which is a hole. I've noted this to the product team.
However, the pattern of adding the column name in there is interesting. I don't have a Prompt so...
I've passed along the request. The list is:
CSV - Use values in a CSV as random values
File Import - Import files into a column, useful for images or BLOB values
File List - Import values from a text file.
Python script - Generate data using a Python script
Regexp - Generate values with a regular expression
Simple expression - One line expression that selects from another table, a Python function or a C# DateTime method
SQL Statement - Use a SELECT statement to return data
SQL FK - Use a column in another table as a FK
SQL defaults - use the default for a column
Text Shuffler - random shuffle of text you enter
Weighted List - list of values weighted by a ratio / comments
I've passed along the request. The list is:
CSV - Use values in a CSV as random values
File Import - Import files into a column, useful for images or BLOB values
File List - Import values from a te...
I tried a few things. One that does work, if you have the domain mapping, is to use this python function: def main(config):
penlist = ['A', 'B', 'C']
pencillist = ['D', 'E']
if Device == 'pen' or Device == 'Pen':
return random.choice(penlist)
else:
return random.choice(pencillist)
I'm assuming here your colunm is Device, and this is the appropriate mapping. I did need to add a reference to my list of Python 2.7 libraries to get the random module. / comments
I tried a few things. One that does work, if you have the domain mapping, is to use this python function:def main(config):
penlist = ['A', 'B', 'C']
pencillist = ['D', 'E']
if Devi...
What you really have here is a key of sorts. Does the database have any referential integrity for these columns? Or do you have a source database that has this type of constraint? / comments
What you really have here is a key of sorts. Does the database have any referential integrity for these columns? Or do you have a source database that has this type of constraint?
Are these both date columns? What's the DDL? / comments
Are these both date columns? What's the DDL?