Inline/Dynamic SQL vs Stored Procedures (Just 5 short summarized points)

After reading some articles and discussions on this topic, my conclusion is: It is a myth to use all inline/dynamic SQL for all the queries in the application. It is a myth to use all Stored Procedure for all the queries in the application. Use Stored Procedure when the query is very complicated, easily will Read more about Inline/Dynamic SQL vs Stored Procedures (Just 5 short summarized points)[…]

Best interactive website to learn SQL

Today, my senior recommended me a website to learn sql, http://sqlzoo.net/ This is much better than famous w3schools and better than other interactive SQL sites like http://sqlcourse2.com/groupby.html and http://www.xlinesoft.com/articles/interactive_sql_tutorial/index.htm. The reason is because you can actually type those query yourself to do those exercises and the result will appear on your right side. If the Read more about Best interactive website to learn SQL[…]