TechRepublic|Forums|Web Development

Web Development

Question

  • Creator
    Topic
  • September 29, 2020 at 4:42 pm #2141297

    Trying to create a SQL function in Visual Studio – nothing happens

    by apn72 · about 4 years ago

    Tags: 

    I’m creating my first function for a SQL Server database using Visual Studio.
    In the DB Explorer, I right-click Function, then Add new scalar function and amend the default script to what I want; it has no error squigglies. The script window has only one button – Update database – I click it – this produces a dialogue saying “User actions, create, [dbo].ValidateEmail] (function)” – I click the update database button.
    However, when I right-click Functions in the DB explorer & choose Refresh, nothing is there.
    What can I be doing wrong? Thank you for any useful help!

  • Creator
    Topic

You are posting a reply to: Trying to create a SQL function in Visual Studio – nothing happens

The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our Community FAQs for details. All submitted content is subject to our Terms of Use.

All Answers

Share your knowledge