Download SQL SERVER Database Coding Standards and Guidelines Complete List
Just like my previous series of SQL Server Interview Questions and Answers Complete List Download, I have received many comments and emails regarding this series. Once I go through all the emails and comments, I will make a summary of them and integrate them with my series. I have also received emails asking me to create PDF for download. I have created that as well. Please feel free to download it and use it.
Please ask me any questions you might have. Contact me if you are interested in writing a mini series with me.
Download SQL SERVER Database Coding Standards and Guidelines Complete List
Complete Series of Database Coding Standards and Guidelines
SQL SERVER Coding Standards and Guidelines – Introduction
SQL SERVER – Coding Standards and Guidelines – Part 1
SQL SERVER – Coding Standards and Guidelines – Part 2
SQL SERVER Coding Standards and Guidelines Complete List Download
Other popular Series
SQL Server Interview Questions and Answers Complete List Download
SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download
I personally find this standard very useful and I practice everyday during my consultancy business. Let me know your thoughts.
Reference: Pinal Dave (https://blog.sqlauthority.com)
76 Comments. Leave new
I want to appreciate the author of this documents
keep the gud work up.
hello pinal Dave
i am really happy with u r articles
Good Pinal Dave,
Keep updating the things……….
I want to send some new concept of performance tunning and new way of using sql server 2005 coding stratergy. I will appreciate you if you can provide me your mail ID so that i can send you the document which i Collect from my learnings………
Thanks & Regards
Shashi Kant Chauhan
how can i count number of column in a row with same data?
i have a table with column empid,month, day1, day2 ………….day31 i want to count number of ‘p’ and ‘a’ of that employee id?
select
len(empid)-len(replace(empid,'p','')) as no_of_p,
len(empid)-len(replace(empid,'a','')) as no_of_a
from your_table
You are really good man. Your effort with no charge is really appreciable.
God bless you.
Rana
i am not written this for u .because i really dont no which word i say to u. no word is expressed to u.U R a very tallented person ,u have a great capabilities to done all u r effort.u also done a work that needed all jobseekers like me.
i just searches SQL related questions with ansers ,and i get this wonderful and easy solution from u.
thanks ,may have 2 requst u plz contact with me.
best of luck u r next …………………………………………………………………..
till end
Hi!
Its very nice and helpful link for me and all sql users.
regards,
Ganesh Jamdurkar
Hi!
Its very nice and helpful link for me and all sql users.
regards,
Faisal Qureshi
Wonderful website..appreciate the effort.
Arvind
hi
it is very useful and necessary to all who are all using sql server. keep on adding tips
regards,
ravi
Hi pinaldave,
Very usefull article keep going.
CONNECTION OF SQL SERVER 2005 TABLES WITH VISUAL STUDIO 2005
Hi,
wha is the command used to count foreign key in a table.
To know the foreign keys
EXEC sp_fkeys ‘table_name’
Hi Pinal,
Exist standars in SQL for creation views ?
Thanks
Cesar
thats very nice tips! lucky i found your article. that save a lot of my time to fix my problem.
it is nice to read ,very interesting.
hi everyone can you tell me the steps of how to disable procedure in sql 2000 and 2005
Hi Pinal Dave,
Surprising greatly. Keep good work. Now I am addicted this website.
Hi,
It is a very very good article. I never think these kind of questions. Thanks a lot for doing research on it and all the best for further research.
Regards
Sajitha
Hello,
Great document!
I noticed you recommend having your table names be ‘plural’. It seems there are those who are passionate about making them singular. I was wondering what your reasoning is for doing it your way.
Thanks
Frank