satyanarayana


is it possible to use VS Express Edition to create .NET CLR Stored Procedures




Re: using express edition

nielsb


Sure you can, but you can not deploy automatically from inside VS.

1. Create a normal class library
2. write your methods as public static
3. Compile
4. Deploy the assembly to the database (look in BOL for CREATE ASSEMBLY)
5. Create T-SQL wrapper procedures/functions/triggers against your CLR methods (look in BOL for CREATE FUNCTION/PROCEDURE/TRIGGER)

Niels






Re: using express edition

satyanarayana

for creating code

will i get same amount help that is provided professional edition






Re: using express edition

nielsb

Seeing that the Pro edition doesn't give you any help for creating code, the answer is yes :-)

Niels




Re: using express edition

satyanarayana

thanks niels