Order, etc, and you have to accept any of 'em. Stored proc with parameters for product category, name, price range, sort For example, you have that "product search" You're comfortable writing T-SQL, and you've built a lot of stored procedures
#Sqlpro for mssql create table from table how to#
Video: Dynamic SQL Pro Tips – from my Mastering Query Tuning class, where I go into even more detailsĭynamic SQL - When, Why, and How to Use It.Dynamic Search Conditions in T-SQL by Erland Sommarskog.The Curse and Blessings of Dynamic SQL by Erland Sommarskog.
4 SQL Injection Techniques for Stealing Data by Bert Wagner.You can use any size, small/medium/large – they’ll all work to show the problems.Īfter this session, your next steps for learning are: I’ll be using the Stack Overflow public database. Show you my favorite tips to make it faster and easier to troubleshoot (and note that in the live class, I don’t cover all of the tips – the script keeps going with my conversational style in the comments, so you can read through more tips & tricks after class).Build a multi-parameter stored procedure the old-fashioned way.It can also be a route to sitting under your desk, banging your head against a wine bottle, wishing you could stop seeing double apostrophes mocking you. It can be an awesome, powerful, and fast solution to a lot of performance problems. If you’ve ever needed to build a stored procedure that took a lot of different parameters and served a lot of different purposes, you’ve probably used dynamic SQL.
0 kommentar(er)
