Can I use Visual Studio Snippets to generate SQL code

Question

I want to use Visual Studio snippets to generate SQL code, for example we have standard naming conventions for foreign keys etc and it would be great if I could just expand a snippet in my SQL script file.

However as far as I can tell the only languages that are supported by the Snippet manager are C#, VB J# and XML

http://msdn.microsoft.com/en-gb/library/ms171421(VS.80).aspx

Does anyone know of a way to have a snippet expand to SQL?

Derek

dove · Accepted Answer · 2008-11-06 12:02:46Z

1

I would recommend you consider using T4, which is built into Visual Studio.

Oleg has great examples, including one for stored procedures

answered Nov 6, 2008 at 12:02

dove

20.8k14 gold badges88 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matthew Manela · Accepted Answer · 2011-01-23 20:42:05Z

1

Visual Studio 2010 added support for SQL snippets.

You can read more about them at this MSDN page

edited Jan 23, 2011 at 20:42

answered Jan 23, 2011 at 7:27

Matthew Manela

16.8k3 gold badges67 silver badges67 bronze badges

Collectives™ on Stack Overflow

Can I use Visual Studio Snippets to generate SQL code

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related