0

Preface: Sort of green to this, apologies if it is beyond obvious.

I'm using SQL Server Management Studio 2014, and in one of our schemata found this:

enter image description here

I've gone down a number of rabbit holes regarding variants in schemata, != functionality, schema objects, and can't seem to get a handle on what this syntax definitively stands for or accomplishes.

Help appreciated.

Martin Smith
  • 438,706
  • 87
  • 741
  • 845
Joy_TK
  • 11
  • 3
  • It's considered rude here to post an image instead of the actual code. – Joel Coehoorn Feb 09 '17 at 20:00
  • I am unable to do that since this code snippet (from my work, where we deal with PII) occurs in a virtual machine that does not allow anything to be copied out. (Rudeness unintended.) – Joy_TK Feb 22 '17 at 19:39
  • So you retype it. That's what we'll have to do. It's much more efficient for you to retype it once than for us to each retype it individually as we try to help you. – Joel Coehoorn Feb 22 '17 at 20:31

2 Answers2

1

These are SSMS template parameters. The syntax includes name, datatype, and example value (blank in your case).

You can press Ctrl + Shift + M to bring up a dialogue box to fill them in.

Or if that doesn't do anything see this article for how to fix.

Martin Smith
  • 438,706
  • 87
  • 741
  • 845
  • Very interesting -- and I never would have known to google template parameters, which explains why my searches were unproductive. Really appreciate insight into this mystery! – Joy_TK Feb 22 '17 at 19:44
0

It's autogenerated code - in this case for INSERT INTO query. Those values in <> should be replaced with proper values - they're just hints including column name and type.

barbsan
  • 3,418
  • 11
  • 21
  • 28