Download: Microsoft SQL Server 2008 Express

submitted by crpietschmann 8 days, 8 hours ago

microsoft.com — This is the direct download link for SQL Server 2008 Express RTM. read more...

add a comment | category: Database | Views: 8

SQL SERVER - 2005 - Difference Between INTERSECT and INNER JOIN

published 14 days, 20 hours ago, submitted by pinaldave 16 days, 4 hours ago

blog.sqlauthority.com — INTERSECT operator in SQL Server 2005 is used to retrieve the common records from both the left and the right query of the Intersect Operator. INTERSECT operator returns almost same results as INNER JOIN clause many times. When using INTERSECT operator the number and the order of the columns must be the same in all queries as well data type must be compatible. Let us see understand how INTERSECT and INNER JOIN are related.We will be using AdventureWorks database to demonstrate our example. read more...

3 comments | category: Database | Views: 235

Transferring data from SQL Server database to MySql database

submitted by dotnetfunda 1 month, 5 days ago

dotnetfunda.com — The other day I was facing problem while migrating my Sql Server database tables into MySql database. I tried to google it but couldn't find any great solution that can do it through code easily. read more...

add a comment | category: Database | Views: 4

T4 template for generating SQL view from C# enumeration

olegsych.com — Database tables often contain columns that store “codes”, or values with special meaning. In application code, these special values can be encapsulated as enumerations. This article demonstrates how to use T4 code generation templates and Visual Studio CodeModel API to generate SQL views that encapsulate the special values for use in SQL code. read more...

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

Complex SQL conditional statements with SubSonic 2.1

biasecurities.com — Create complex SQL conditional statements in C# with SubSonic. Eg. select * from Product where IsActive = 1 and (ExpiredOn is null OR ExpiredOn <= '01/01/2020') read more...

add a comment | category: ASP.NET | Views: 14

How To: Rename SQL Server 2005 Database Using TSQL

dbalink.wordpress.com — For some reasons, DBA’s need to rename their Databases. One of the reasons might be to comply to Best Practices Policy changes. Here we are going to rename our Database named “Bad_Ass_DB” into “Best_Practice_DB”. This is how Database renaming with TSQL is done in SQL Server 2005.... read more...

add a comment | category: Database | Views: 16

Efficient Paging in SQL Server 2005

published 1 month, 14 days ago, submitted by justin_etheredge 1 month, 16 days ago

codethinked.com — Sure, SQL Server 2008 is getting ready to drop, but are you familiar with all of the new features that 2005 gave you? Or maybe you haven't used 2005, well, this is a good article to introduce to you several of the new features in SQL Server 2005. read more...

add a comment | category: Database | Views: 432

10 reasons why SQL Server 2008 is going to rock

published 1 month, 27 days ago, submitted by crpietschmann 1 month, 29 days ago

angryhacker.com — Just like its predecessor, SQL Server 2008 is taking its sweet time to actually ship. However, unlike its predecessor, it won't just be a "worthwhile upgrade". It will kick ass. Here are the top 10 reasons why. read more...

add a comment | category: Database | Views: 948