Ever wonder what Wikipedia's database schema looks like? I have read this formula recently
I like how their tables are tagged with a prefix, so that you can tell the relation with the other tables of your functionality, purpose and bat. .
I do not know that one thing is that how do they name their stored procedures, do they also use SP?
I use MS SQL Server prefixing all stored procedures with USP_ or SP_ seems unnecessary and anti-profit because the object explorer already checks for me of all types. How do the names of my SP
I like how their tables are prefixed with You are tagged with your functionality, purpose, and You can tell the relationship with other tables
That's why you have schemas in the SQL server, you create a schema with multiple objects together, and you Only access to the HR schema
Prefixing all stored procedures with USP_ or SP seems redundant and anti-profitable because Object Explorer is already available for all Checks the car How do you name your SP?
SP_ should never be used because you will get a performance hit, whenever the SQL Server looks at 'one cop' which starts with SP_, it first examines the master database If the MS decides to nominate a province with your name and it starts by you, you will not be executed at any time
BTW Not everyone Project Explorer Some people like to do this in T-IN, SQL
Comments
Post a Comment