Hi,
Its not very obvious to open new project in VS 2013 in VB to find option for SQL CLR.
What you need to do is following:
Its not very obvious to open new project in VS 2013 in VB to find option for SQL CLR.
What you need to do is following:
Open VS 2013
Go to New
Project
Dialog box
will Appear
Expand Other
languages and click on SQL Server
Click on SQL
Server Database Project and click ok
When the
project load, right click on project and click Add new item
Now to change
the project in VB, right click on project and go to properties.
Select SQL
CLR tab.
There you
will see Language option.
Change it to
Visual Basic.
Now right
click on project and click Add new item
Now you this
time you will see SQL CLR VB in left menu.
Select it and
then add desired file according to need to build Store procedure or function.
Happy coding!
