New T-SQL Capabilities in SQL Server 2005 - Part 3 of 3 (setfocus.com)

submitted by SetFocus(510) 5 years, 1 month ago

In last month's article, I covered the new APPLY operator, Ranking functions, and the new TRY...CATCH capabilties in T-SQL 2005. This month I'll talk about two of the largest enhancements in the SQL 2005 language - Common Table Expressions (CTEs) and Recursive Queries. Both fo these are part of the SQL-99 standard. CTEs allow developers to more expressively identify a temporary result set (similar to a derived table or temporary view). Recursive Queries allow developers to more easily query hierarchies of data, by permitting developers (in a single SQL statement) to recursively query into a CTE that's also being populated). CTEs and Recursive queries can be a little difficult to initially grasp, so I'm going to show several code examples to demonstrate their value. read more...

add a comment |category: Visual Studio |Views: 27

tags: T-SQL kevin goff Server Database another

Video: Hacking SQL Server(jumpstarttv.com)

submitted by bknight(220) 5 years, 3 months ago

In this presentation at the Jacksonville SQL Server Users Group, Bayer White playS the part of a developer protecting his application and Brian Knight attempts to hack his application using SQL Injection and cross-site scripting. Then, Bayer will show you how to protect yourself from the hacker and then Brian tries again. Back and forth the chess match goes until someone wins! read more...

2 comments |category: Security |Views: 76

tags: SQL XSS SQLHacks Injection Video another

Using a trigger to perform mass-update-safe, specific-field calculatio(dotnetzone.gr)

submitted by sotirisf(315) 5 years, 4 months ago

You’ve got a table which contains some information and you want to perform calculations based on this information and store them in the same table or in another table. The calculations must always be up-to-date. The calculations are performed via a complex User Defined Function which accepts the other fields’ values as parameters. The table has got thousands of rows and thus you do not want to use a view because it’ll degrade the overall performance. For the same reason, you do not want to use a calculated field. read more...

add a comment |category: Database |Views: 4

tags: Server mass calculation SQL trigger another

Conditional WHERE clauses in T-SQL using comparison operators(dotnetzone.gr)

submitted by sotirisf(315) 5 years, 4 months ago

Ever had a query where you wished you could be able to specify the operator (equal, not equal, greater than, etc.) for each column contained in your WHERE clause, without having to use ugly string concatenations and the infamous EXEC keyword? Here we'll see an example of how this can be achieved with the use of a plain SQL query together with some CASE statements. read more...

add a comment |category: Database |Views: 668

tags: comparison operator where SQL Server another

When to use .NET inside SQL Server 2005(andreas-kraus.net)

submitted by reteep(739) 5 years, 7 months ago

Some meaningful scenario when to use .NET programming inside SQL Server 2005. read more...

1 comment |category: Database |Views: 0

tags: SQLServer Server 2005 SQL .Net another

IE7 BETA 3 Released(blog.lotas-smartman.net)

submitted by tiernano(1674) 5 years, 10 months ago

downloads for XP x32 and x64 and Windows Server (x32, X64 and Itanium builds) read more...

2 comments |category: IE |Views: 0

tags: WinXP Server Itanium x32 Windows another