2 Comments

• 
  SQLUserCJ - 12 years ago

  I tried SQL Prompt. It seemed neat, but I didn't really get what was so great about it compared to just the intellisense features of SSMS 2008. Anyone care to enlighten me on some of its potential?

• 
  Mark Tassin - 12 years ago

  I use SQL Prompt, up until the point that a semi-complex query causes it to grind SSMS to a halt.

  i.e.

  Something like this to extract survey data from sharepoint is too much for it.
  DECLARE @test VARCHAR(50) = 'test'

  ;WITH
  t1 AS (SELECT 1 AS N UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 ), --10
  t2 AS (SELECT a.* FROM t1 a,t1 b), --100
  t3 AS (SELECT a.* FROM t2 a ,t2 b), --10000
  t4 AS (SELECT a.* FROM t3 a ,t3 b),
  Tally AS (SELECT N=ROW_NUMBER() OVER (ORDER BY (Select NULL)) FROM t3)
  ,Survey AS (
  SELECT
  QuestionPortion =1
  ,l.tp_id
  , topicttitel = l.tp_title
  , l.tp_created
  , d.ntext1
  , d.ntext2
  , d.ntext3
  , d.ntext4
  , u.tp_login
  , usertitle = u.tp_title
  , u.tp_email
  , parsed = SUBSTRING(('#' + ntext1 ),N+1,CHARINDEX('#',('#' + ntext1 ),N+1)-N-1)
  ,N
  FROM allLists l
  JOIN allUserData d on l.tp_id = d.tp_ListId
  JOIN UserInfo u on d.tp_author = u.tp_id
  JOIN Tally T ON 1=1
  WHERE l.tp_title = @test
  AND N