MS-SQL : Stored procedure coding standard/check list
It is always better to have check list for creating stored procedure in SQL server. Most people may not think that it is really required to have; yes I agreed that for experienced developer it may not be required because by default they use the entire coding standard because of their experience. But during my 8 years of experience I have seen many of experienced developers also forgetting basic principles and hence this post.
1. Procedure name should be as per the standard provided by the client or decided by the project team.
2. Proper comments to understand the functionality.
3. Name of the preson created, date, purpose,sample execution statement at the beginning as shown in fig 1.
4. All the syntax should be in CAPS
5. Align the code with right indentation- this helps to understand the code very easily
6. Proper exception handling as shown in Fig 2
7. Raise error appropriately to help the user understand what exactly happened.
8. Keep declaration, initiation etc. in separate section of procedure and do not mix the same.
1. Procedure name should be as per the standard provided by the client or decided by the project team.
2. Proper comments to understand the functionality.
3. Name of the preson created, date, purpose,sample execution statement at the beginning as shown in fig 1.
4. All the syntax should be in CAPS
5. Align the code with right indentation- this helps to understand the code very easily
6. Proper exception handling as shown in Fig 2
7. Raise error appropriately to help the user understand what exactly happened.
8. Keep declaration, initiation etc. in separate section of procedure and do not mix the same.
 |
| Fig 1 |
 |
| Fig 2 |
Hi to all. The blog is really good and the above information is helpful to me. Thank you so much.
ReplyDeletejavascript training in chennai
javascript course in chennai
core java training in chennai
core java training institutes in chennai
C C++ Training in Chennai
C Training in Chennai
Appium Training in Chennai
JMeter Training in Chennai
Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important. Project Center in Chennai It’s what organizations do with the data that matters. Big data can be analyzed for insights that lead to better decisions and strategic business moves.
DeleteSpring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai
The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training
I have been reading for the past two days about your blogs and topics, still on fetching! Wondering about your words on each line was massively effective. Techno-based information has been fetched in each of your topics. Sure it will enhance and fill the queries of the public needs. Feeling so glad about your article. Thanks…!
ReplyDeletemagento training course in chennai
magento training institute in chennai
magento 2 training in chennai
magento development training
magento 2 course
magento developer training
Thanks for sharing an informative blog keep rocking bring more details.I like the helpful info you provide in your articles. I’ll bookmark your weblog and check again here regularly. I am quite sure I will learn much new stuff right here! Good luck for the next!
ReplyDeleteWeb Designing Training Institute in Chennai | web design training class in chennai | web designing course in chennai with placement
Mobile Application Development Courses in chennai
Data Science Training in Chennai | Data Science courses in Chennai
Professional packers and movers in chennai | PDY Packers | Household Goods Shifting
Web Designing Training Institute in Chennai | Web Designing courses in Chennai
Google ads services | Google Ads Management agency
Web Designing Course in Chennai | Web Designing Training in Chennai
Nice post. Thanks for sharing! I want people to know just how good this information is in your article. It’s interesting content and Great work.
ReplyDeleteappium online training
appium training centres in chennai
best appium training institute in chennnai
apppium course
mobile appium in chennnai
mobile training in chennnai
appium training institute in chennnai
Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site. keep t up
ReplyDeleteAi & Artificial Intelligence Course in Chennai
PHP Training in Chennai
Ethical Hacking Course in Chennai Blue Prism Training in Chennai
UiPath Training in Chennai
Mua vé tại đại lý vé máy bay Aivivu, tham khảo
ReplyDeleteVe may bay di My
vé máy bay vinh sài gòn hôm nay
vé máy bay saigon- hà nội
giá vé máy bay hà nội đà lạt khứ hồi
giá vé máy bay đi quy nhơn bình định
taxi sân bay đi nội bài
combo du lịch đà lạt 2021
It might maintain to come into the dispensation into it and prepare the music to run. It gives you full convenience for data from one records site. Rekordbox License Key
ReplyDeleteYou can download this Malwarebytes key crack. You can just download this Malwarebytes anti-malware crack application on your computer. Malwarebytes Anti Malware Premium Keygen
ReplyDeleteThe best Christmas is the one when you're with me all day and all night. Spending time with you is my wish for this season. Merry Christmas my love Website
ReplyDelete