Whats up with Stored Procedures these days?

published 2 months, 17 days ago, submitted by cheetahtech 2 months, 17 days ago

spoiledtechie.com — When life throws you hard balls, you can either step back and take a swing or bunt the hell out of it. I just recently went to an information session on T-SQL, Stored Procedures and now LINQ. These folks discussed stored procedures and why they are so important in the world today. read more...

2 comments | category: Database | Views: 503

The Oncoming Microsoft ASP.NET MVC with Some LINQ Tossed In - Part 2

adronbhall.com — In the <a href="http://adronbhall.com/blogs/technology__software_development/archive/2007/12/25/6062.aspx" target="_blank">first part of this series</a> I went over how to create a basic skeleton of controllers and models so that we could create a mock test and get it green lighted along with some other tests for getting the basic navigation methods tested and green lighted.&nbsp; In this part of the series I'm going to go over the model from a LINQ point of view.&nbsp; After that in subsequent parts of this series I'll start building out the views, utilizing of course a test driven development process.&nbsp; So no more blabbering, let's code. read more...

add a comment | category: Linq | Views: 0

SQL Server error messages

weblogs.sqlteam.com — Ever needed to find the text associated with an error number in SQL Server? This blog shows you how to retrieve it from SQL Server's metadata using T-SQL. read more...

add a comment | category: Database | Views: 1

InnerWorkings tackles Transact-SQL for developers

cs.innerworkings.com — We help developers learn to code fundamental Transact-SQL activities such as making queries, sorting and filtering, and using table joins. Delve into control-of-flow language and using functions to manipulate data. Hands-on, practice-based, just for developers looking to learn T-SQL. read more...

1 comment | category: Database | Views: 2

Using a comma delimited string with id's as input parameter for a SQL

blog.krisvandermast.com — Split function in T-SQL read more...

add a comment | category: Database | Views: 8

New T-SQL Capabilities in SQL Server 2005 - Part 3 of 3

setfocus.com — 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: 19

OUTPUT Clause in SQL Server 2005

published 1 year, 9 months ago, submitted by keyvan 1 year, 9 months ago

nayyeri.net — In this post you'll read about a new clause that is added to T-SQL with SQL Server 2005. OUTPUT clause helps you to retrieve data from inserted, updated or deleted rows. read more...

add a comment | category: Database | Views: 5

Count(1) vs Count(*)

submitted by crpietschmann 1 year, 9 months ago

blogs.msdn.com — In T-SQL, count(*) is good enough, but in PL/SQL, count(1) actually yields better results. read more...

add a comment | category: Database | Views: 8