Solved

Naming conventions in SQL Server

Posted on 2009-03-30
4
270 Views
Last Modified: 2012-05-06
Here is an easy one... I am not familiar with SQL Server but have some programming experience.  I was handed some documentation about a new system process we are going to use in SQl Server 2005 where it makes several references to things like "Exec UT_Load_Catalogs"  Is the "UT" a naming convention for a particular type of script or process in SS?  Thanks

0
Comment
Question by:snyperj
  • 2
4 Comments
 
LVL 29

Expert Comment

by:QPR
ID: 24024867
well "exec" (short for execute) would indicate that ut_load_catalogs is a stored procedure.
You "select" from a table, view or user defined function. You execute a stored procedure.
0
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 24024874
not knowing what ut_load_catalogs does limits my response but perhaps....
UT = update table?
0
 
LVL 12

Expert Comment

by:udayakumarlm
ID: 24024937
UT is used for Usage type. if you are using third party tool/library then they might have their own naming convention.
the following are some of the naming standards follwoed in SQL
XP      extended stored proc
via      view
Tr      trigger
sys%      system table
sp      stored procedure
more about naming conventions
http://www.sql-server-performance.com/articles/dev/sql_best_practices_p1.aspx
http://www.tek-tips.com/faqs.cfm?fid=5276
http://sqlserverpedia.com/wiki/T-SQL_Coding_and_Naming_Standards
0
 

Author Closing Comment

by:snyperj
ID: 31564609
That was it.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Physical server SQL Server swap file size and memory allocation ? 4 77
How to enforce inte 8 43
SQL Server Degrading on Write 13 63
Set the max value for a column 7 37
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

919 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now