Solved

Naming conventions in SQL Server

Posted on 2009-03-30
4
295 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
[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
  • 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:udaya kumar laligondla
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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

738 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