4 results found
-
Invalid colimn add scripting for new columns
If new colums have a sparse they will be scrithed without.
At second syng diff can be detected and scripted as :
ALTER TABLE [dbo].[lalala]
ALTER
COLUMN [lala] ADD SPARSE
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO4 votes -
Autocomplete not working if more than 1 query
In an Sql window, if I type:
select Field1 from Table1
... autocomplete works ok (i.e. Field1 and Table1 will appear as suggestions). However, if in the same window I type:
select Field1 from Table1
select Field2 from Table2... Autocomplete doesn't work for the second line of sql. It only seems to work for the query which is at the top of the sql window.
3 votes -
selected stored proc execution script is deselected after execution
- in SQL Editor, execute selected stored proc e.g. declare @p1 nvarchar(4000) set @p1=NULL declare @p4 xml set @p4=convert(xml,N'<paramData></paramData>') exec api.widgetpreferencesave select @p1
- after execution (multiple recordset returned), the selected code has been deselected
3 votes -
Strange Cursor Behaviour
The cursor sometimes displays as a bar, but in the wrong place - i.e. you can be typing somewhere else. Or the bar becomes stuck, and the cursor where you're typing becomes a small vertical rectangle - and it all doesn't quite work correctly.
This ambiguity over where the cursor really is, coupled with the (very nice) F8 feature, is quite dangerous: you could easily think you're going to execute one statement, when actually you will execute a quite different statement.1 vote
- Don't see your idea?