SQL - Truncate and Delete

published 1 year, 1 month ago, submitted by prashantvictory 1 year, 1 month ago

techahead.wordpress.com — Truncate an Delete both are used to delete data from the table. These both the command will only delete the data of the specified table, they cannot remove the whole table data along with its structure. Now it’s ok that both the SQL statements are used to delete only the data from the table but they both differ from each other in many aspects like syntax, performance, resources uses etc. to find out all differnces take a look of this article..... read more...

1 comment | category: Database | Views: 1

ASP.NET - Server.Transfer v/s Response.Redirect

published 1 year, 1 month ago, submitted by prashantvictory 1 year, 1 month ago

techahead.wordpress.com — This article tell you the difference between Server.Transfer and Response.Redirect. read more...

6 comments | category: ASP.NET | Views: 8

SQL – Using "UNION ALL" to Convert Horizontal Data to Vertical Data

submitted by prashantvictory 1 year, 1 month ago

techahead.wordpress.com — This post will tell u how to use the UNION ALL operator to convert horizontal data to vertical data. read the post more more information....... read more...

add a comment | category: Database | Views: 41

SQL - Derived tables

published 1 year, 1 month ago, submitted by prashantvictory 1 year, 1 month ago

techahead.wordpress.com — This article explains what are derived tables and how we can use them to perform our query better. In some situations they can be a better alternative of temporary tables, So take a look of this... :) read more...

add a comment | category: Database | Views: 15

SQL - Temporary tables a detailed view.

published 1 year, 1 month ago, submitted by prashantvictory 1 year, 1 month ago

techahead.wordpress.com — This article contains almost each and everything related to temporary tables in SQL, all the concepts of temp tables like how to use them, wht are the alternatives of temp tables, what are the benefits and drwabacks, what is the performance tunibg tips etc, i think this is the best article to learn about SQL Server Temporary tables. read more...

add a comment | category: Database | Views: 36

.NET Framework 3.5 Is Shared Source

published 1 year, 2 months ago, submitted by benrick 1 year, 2 months ago

weblogs.asp.net — Microsoft's .NET Framework 3.5 is going to be released open source. read more...

26 comments | category: Open Source | Views: 66

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

setfocus.com — This month I'll start a three-part series on new Transact-SQL language features in SQL Server 2005. Microsoft added many new language features in SQL Server 2005, in response to developer requests and also in following compliance with the SQL-99 standard. read more...

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