4 results found
- 
Invalid colimn add scripting for new columnsIf 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 queryIn 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 BehaviourThe 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?
