Dynamic SQL Is Not Inline SQL

Posted by: youve been HAACKED, on 02 Nov 2005 | View original | Bookmarked: 0 time(s)

Perhaps there is a better term I could be using when I referred to dynamic SQL in my last post. To my defense, I did mention using Prepared Statements. The key point to keep in mind while reading the last post is that Dynamic SQL does not necessarily imply Inline SQL. By inline SQL, I mean concatenated sql statements flung all over the code like a first year classic ASP developer. Like any good security minded developer, I detest inline SQL (as I define it here). A much better and safer approach...

Advertisement
Free Agile Project Management Tool from Telerik
TeamPulse Community Edition helps your team effectively capture requirements, manage project plans, assign and track work, and most importantly, be continually connected with each other.
Category: SQL | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 1281 | Hits: 132

Similar Posts

  • SQLAuthority News Meeting SQL Friends SQLPASS 2011 Event Log more
  • SQLAuthority News SQLPASS Today FREE 100 SQL Wait Stats Book Print Copy Book Signing more
  • SQLAuthority News SQLPASS 100 SQL Wait Stats Book Print Copy Giveaway A Book Every Minute for an Hour Tomorrow more
  • SQLAuthority News Whitepaper Running SQL Server with Hyper-V Dynamic Memory Best Practices and Considerations Consolidating Databases Using Virtualization Planning Guide more
  • SQLAuthority News SQL Server Health Check Service Speed UP SQLServer more
  • Html Encoding Nuggets With ASP.NET MVC 2 more
  • Introducing Versatile DataSources more
  • Migrating to Postgresql with my friend NHibernate more
  • Dynamic in C# 4.0: Creating Wrappers with DynamicObject more
  • Migrated from Community Server to DasBlog more

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD