Idea 代码段

1. SQL

1.1. cvtdt108

• Abbreviation: cvtdt108

• Description: convert datetime to "HH:mm:ss" format

• Template text:

  CONVERT(VARCHAR(8), $dt$, 108)

• Variables:

  Name	Expression	Default Value	Skip if defined
  dt		"GETDATE()"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.2. cvtdt108s

• Abbreviation: cvtdt108s

• Description: convert datetime to "HHmmss" format

• Template text:

  REPLACE(CONVERT(VARCHAR(8), $dt$, 108), ':', '')

• Variables:

  Name	Expression	Default Value	Skip if defined
  dt		"GETDATE()"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.3. cvtdt112

• Abbreviation: cvtdt112

• Description: convert datetime to "yyyyMMdd" format

• Template text:

  CONVERT(VARCHAR(8), $dt$, 112)

• Variables:

  Name	Expression	Default Value	Skip if defined
  dt		"GETDATE()"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.4. cvtdt120

• Abbreviation: cvtdt120

• Description: convert datetime to "yyyy-MM-dd HH:mm:ss" format

• Template text:

  CONVERT(VARCHAR(19), $dt$, 120)

• Variables:

  Name	Expression	Default Value	Skip if defined
  dt		"GETDATE()"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.5. cvtdt121

• Abbreviation: cvtdt121

• Description: convert datetime to "yyyy-MM-dd HH:mm:ss.fff" format

• Template text:

  CONVERT(VARCHAR(23), $dt$, 121)

• Variables:

  Name	Expression	Default Value	Skip if defined
  dt		"GETDATE()"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.6. cvtdt23

• Abbreviation: cvtdt23

• Description: convert datetime to "yyyy-MM-dd" format

• Template text:

  CONVERT(VARCHAR(10), $dt$, 23)

• Variables:

  Name	Expression	Default Value	Skip if defined
  dt		"GETDATE()"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.7. droptmptbl

• Abbreviation: droptmptbl

• Description: drop temporary table

• Template text:

  IF OBJECT_ID('tempdb.dbo.$tmp$') IS NOT NULL
    DROP TABLE $tmp$

• Variables:

  Name	Expression	Default Value	Skip if defined
  tmp		"#temp"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.8. errinfo

• Abbreviation: errinfo

• Description: error info

• Template text:

  ERROR_MESSAGE() + N' (' + CAST(ERROR_LINE() AS NVARCHAR(20)) + N')'

• Variables: none

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.9. eve

• Abbreviation: eve

• Description: search everywhere

• Template text:

  EXEC master.dbo.EverythingProc @srh = N'$DEFAULT_CONDITIONS$', @dbs = N'$dbs$', @orders = N'$orders$', @options = $options$

• Variables:

  Name	Expression	Default Value	Skip if defined
  DEFAULT_CONDITIONS		"!ww:Discarded t:P,FN,IF,TF,V"	×
  dbs		"*"	×
  orders		"db, sch, obj"	×
  options		"0x01"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.10. fmtnum

• Abbreviation: fmtnum

• Description: format number

• Template text:

  FORMAT($num$, '$fmt$')

• Variables:

  Name	Expression	Default Value	Skip if defined
  num			×
  fmt		"#,0.##"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.11. printlongmsg

• Abbreviation: printlongmsg

• Description: EXEC master.dbo.PrintLongMsgProc

• Template text:

  EXEC master.dbo.PrintLongMsgProc @msg = $msg$

• Variables: none

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.12. printscript

• Abbreviation: printscript

• Description: EXEC master.dbo.PrintObjectScriptProc

• Template text:

  EXEC master.dbo.PrintObjectScriptProc @dbname = N'$db$', @name = N'$obj$', @isAllowTR = $tr$

• Variables:

  Name	Expression	Default Value	Skip if defined
  db			×
  obj			×
  tr		"0"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.13. printscripts

• Abbreviation: printscripts

• Description: EXEC master.dbo.PrintMultiObjectScriptProc

• Template text:

  DECLARE $targets$ NVARCHAR(MAX)
  SET $targets$ = N'
  $cursor$'
  SET $targets$ = REPLACE(REPLACE($targets$, N'	', N'..'), N'
  ', N',')
  EXEC master.dbo.PrintMultiObjectScriptProc @targets = $targets$, @isAllowTR = $tr$

• Variables:

  Name	Expression	Default Value	Skip if defined
  targets		"@targets"	×
  cursor			×
  tr		"0"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.14. rounddt

• Abbreviation: rounddt

• Description: round datetime

• Template text:

  DATEADD($round$, DATEDIFF($round$, 0, $dt$)$END$, 0)

• Variables:

  Name	Expression	Default Value	Skip if defined
  round		"MONTH"	×
  dt		"GETDATE()"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.15. varmonthfir

• Abbreviation: varmonthfir

• Description: declare this month first day variable

• Template text:

  DECLARE $monthFir$ DATE = DATEADD(MONTH, DATEDIFF(MONTH, 0, $now$), 0)

• Variables:

  Name	Expression	Default Value	Skip if defined
  monthFir		"@monthFir"	×
  now		"GETDATE()"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.16. varnow

• Abbreviation: varnow

• Description: declare now variable

• Template text:

  DECLARE $now$ DATETIME = GETDATE()

• Variables:

  Name	Expression	Default Value	Skip if defined
  now		"@now"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.17. varsysmgr

• Abbreviation: varsysmgr

• Description: declare system manager variables

• Template text:

  DECLARE $id$ INT = 26467, $name$ NVARCHAR(100) = N'管理员'

• Variables:

  Name	Expression	Default Value	Skip if defined
  id		"@id"	×
  name		"@name"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names

1.18. vartoday

• Abbreviation: vartoday

• Description: declare today variable

• Template text:

  DECLARE $today$ DATETIME = DATEADD(DAY, DATEDIFF(DAY, 0, $now$), 0)

• Variables:

  Name	Expression	Default Value	Skip if defined
  today		"@today"	×
  now		"GETDATE()"	×

• Options:

  • Expand with: Default
  • √ Reformat according to style
  • × Shorten FQ names