Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to create stored proc with extension PRC?

Posted on 2011-03-13
1
Medium Priority
?
509 Views
Last Modified: 2012-05-11
Hi

How to create stored proc with extension PRO.Is it
CREATE PROCEDURE [dbo].[StoredProcName.PRO]
or
CREATE PROCEDURE [dbo].[StoredProcName].[PRO]

and also could any one explain significance of sqaure brackets"[ ]" in naming.

Thank You
0
Comment
Question by:mkarthik415
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 6

Accepted Solution

by:
AkAlan earned 2000 total points
ID: 35122605
CREATE PROCEDURE [dbo].[spYourSP.PRO]

AS SELECT     *
FROM         YourTable

The square brackets are placed there to seperate out which part is the Owner, unless you have a good reason to have seperate owners such as multiple people creating storedprocedures against the same database, I would alway leave it at dbo which is the database owner. It also allows you to create a sp with periods in it. If you didn't want the period in the name and you wanted the owner to be dbo you could do something like this using an underscore which is what I would suggest. For that matter I would probably put the PRO in front if you will be using multiple sp's with that naming convention, that way they would show alphabetically when you look for them. What is the significance of the PRO?

CREATE PROCEDURE spYourSP_PRO

AS SELECT     *
FROM         YourTable
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question