DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 637 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

Stories recently tagged with 'T-SQL' Subscribe to this feed
21
kicks
published 1 month, 26 days ago, submitted by powerrush powerrush 2 months, 1 day ago

blog.troyd.net — Compare / Test the Equality of two Queries in SQL Server using this short T-SQL read more...

Add a comment 1 comment | category: | Views: 339
tags: , , , , | tag it

17
kicks
published 2 months, 17 days ago, submitted by cheetahtech 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...

Add a comment 2 comments | category: | Views: 503
tags: , , , , | tag it

13
kicks
published 11 months ago, submitted by kprernn 11 months, 1 day ago

weblogs.sqlteam.com — In this blog, Joe demonstrates the power of the CROSS JOIN and how it can be harnessed to create lots of test data very quickly. read more...

Add a comment add a comment | category: | Views: 9
tags: , , , , | tag it

4
kicks
submitted by adron 11 months, 6 days ago

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 add a comment | category: | Views: 0
tags: , , , , | tag it

1
kicks
submitted by HaGever HaGever 11 months, 18 days ago

gaaton.blogspot.com — 2 SQL queries how to find tables, which includes column name via using in system tables of SQL Server 2005. read more...

Add a comment add a comment | category: | Views: 0
tags: , , , | tag it

2
kicks
submitted by kprernn 1 year ago

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 add a comment | category: | Views: 1
tags: , , , , | tag it

17
kicks
published 1 year, 5 months ago, submitted by powerrush powerrush 1 year, 5 months ago

blog.troyd.net — SQL Server 2000/2005 function to calculate distance in miles between 2 latitude/longitude points for zip or address proximity search, etc. read more...

Add a comment add a comment | category: | Views: 69
tags: , , , , | tag it

5
kicks
submitted by bfinnerty 1 year, 7 months ago

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...

Add a comment 1 comment | category: | Views: 2
tags: , , , , | tag it

10
kicks
published 1 year, 7 months ago, submitted by aleph 1 year, 8 months ago

codeproject.com — Deploy MS SQL Server databases using System.Configuration.Install and a VS.NET Setup Project. The article targets C# 1.1 but is 100% compatible with C# 2.0 and VS.NET 2005. read more...

Add a comment add a comment | category: | Views: 9
tags: , , , , | tag it

3
kicks
submitted by KvdM 1 year, 8 months ago

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

Add a comment add a comment | category: | Views: 8
tags: , , | tag it

10
kicks
published 1 year, 8 months ago, submitted by keyvan keyvan 1 year, 8 months ago

nayyeri.net — TABLESAMPLE is a new clause in SQL Server 2005 to select a sample table from an exisiting table. read more...

Add a comment 1 comment | category: | Views: 2
tags: , , , , | tag it

19
kicks
published 1 year, 8 months ago, submitted by SetFocus 1 year, 8 months ago

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 add a comment | category: | Views: 19
tags: , , , , | tag it

13
kicks
published 1 year, 8 months ago, submitted by SQL_Menace 1 year, 8 months ago

sqlservercode.blogspot.com — In SQL Server 2005 Management studio you can not script out multiple procedures with a create and drop statement This article shows how to do it by using T-SQL read more...

Add a comment add a comment | category: | Views: 4
tags: , , , , | tag it

18
kicks
published 1 year, 9 months ago, submitted by keyvan 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 add a comment | category: | Views: 5
tags: , , , , | tag it

18
kicks
published 1 year, 9 months ago, submitted by SetFocus 1 year, 9 months ago

setfocus.com — In last month's article, I covered the PIVOT, OUTPUT, and TOP N capabilities in T-SQL 2005. This month I’ll cover three more new language features in T-SQL 2005: The new APPLY operator that (as the term indicates) allows developers to more efficiently apply/integrate table-valued User-Defined Functions into SQL queries New Ranking functions to more easily and effectively assign sequential ranking numbers to a result set The new TRY….CATCH error handling capabilities to allow developers and DBAs to write more robust stored procedure code read more...

Add a comment add a comment | category: | Views: 15
tags: , , | tag it

4
kicks
submitted by crpietschmann 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 add a comment | category: | Views: 8
tags: , , , | tag it

 

Sponsored Link: www.carlist.ie

Search:

Ads by The Lounge