Comments
Sort by recent activity
Paul, Where do we get the download? I have v5 installed and its currently ceased to prompt so need to either get the new EAP or revert to v4 soon / comments
Paul, Where do we get the download? I have v5 installed and its currently ceased to prompt so need to either get the new EAP or revert to v4 soon
Thanks Chris, I'll take a look / comments
Thanks Chris, I'll take a look
Anu, I can get the values in to the columns fine, its just I have to do it 30 times. The feature I am asking for is to be able to select more than one column and apply the same data generation rules to them all. / comments
Anu, I can get the values in to the columns fine, its just I have to do it 30 times. The feature I am asking for is to be able to select more than one column and apply the same data generation rul...
Thats great, many thanks Pete.
Jonathan / comments
Thats great, many thanks Pete.
Jonathan
Yeah, I expect you'd have to do it as a second pass or maybe create the values for referenced columns in a primary step so they were available. You just need a copy of what will be inserted into col1 ready beforehand so that col2 can pick some values from it ... / comments
Yeah, I expect you'd have to do it as a second pass or maybe create the values for referenced columns in a primary step so they were available. You just need a copy of what will be inserted into co...
Hi Brian,
Thanks for that. All a bit too complicated and involved. I think I'll just add a static value and run a bespoke TSQL to update the column after the import is done.
May be worth adding as a new feature though ...
Cheers
Jonathan / comments
Hi Brian,
Thanks for that. All a bit too complicated and involved. I think I'll just add a static value and run a bespoke TSQL to update the column after the import is done.
May be worth adding as ...
Hi Chris,
any of the SSMS templates seem to do it as well as any that I put in scripts myself. The shortest one I can think of is the Create Database one:
-- =============================================
-- Create database template
-- =============================================
USE master
GO
-- Drop the database if it already exists
IF EXISTS (
SELECT name
FROM sys.databases
WHERE name = N'<Database_Name, sysname, Database_Name>'
)
DROP DATABASE <Database_Name, sysname, Database_Name>
GO
CREATE DATABASE <Database_Name, sysname, Database_Name>
GO
in order to use it you press Alt +Q, S and the parameter completion dialog comes up to accept parameter values but if you try to apply layout from Refactor or Prompt it crashes with an error mesage of: "SQL Prompt was unable to format this scrupt because syntax errors were found while it was being parsed. These errors have been highlighted."
Hope this helps, any problems feel free to call.
Jonathan / comments
Hi Chris,
any of the SSMS templates seem to do it as well as any that I put in scripts myself. The shortest one I can think of is the Create Database one:
-- =======================================...
Chris, that is my point. I understand its not valid SQL but I want to save this script, with proper layout, to reuse it. Is it not possible for Prompt and Refactor to ignore the parameter(s) ie anything between < and > but still layout the code? / comments
Chris, that is my point. I understand its not valid SQL but I want to save this script, with proper layout, to reuse it. Is it not possible for Prompt and Refactor to ignore the parameter(s) ie any...
Hi Stephanie, thanks for that. / comments
Hi Stephanie, thanks for that.
I would also vote for XML formatting to be reviewed in future versions.
Taking the Books OnLine example from http://msdn.microsoft.com/en-us/library/ms186918.aspx the WITH block from example B gets treated as a single line rather than as a column list when formatted by SQL Prompt + SQL Refactor / comments
I would also vote for XML formatting to be reviewed in future versions.
Taking the Books OnLine example from http://msdn.microsoft.com/en-us/library/ms186918.aspx the WITH block from example B gets...