database,SQL Server - Riaan's Blog

Browse by Tags

SQL And Case Sensitive queries: Ever wondered how to do a Sql query on case sensitive data, for example passwords? The answer is basically in the collation type. By changing the collation type on the column to SQL_Latin1_General_CP1_CS_AS (Case Sensitive) queries as below will shown will give the required results. Select * from table 1 where password = @password COLLATE SQL_Latin1_General_CP1_CS_AS Subscribe in a reader Join my blog network on Facebook Blog Networks Share this post: email it! | bookmark it! | digg it! | reddit...
Posted 13 August 2008 06:05 AM by riaan | 1 comment(s)
Filed under: Development, database, SQL Server, T-SQL

Stored procedure generator: A tool to create the basic insert,update,select statements to your SQL tables. http://www.codeplex.com/spgen Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!
Posted 27 May 2008 02:18 AM by riaan
Filed under: C#, Development, query, programming, database, SQL Server, Design

VLINQ and LINQPad: This article describes 2 cool LINQ tools. These tools help make the LINQ learning curve a bit better: http://www.infoq.com/news/2008/04/linq-tooling Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!
Posted 18 April 2008 03:26 AM by riaan | 2 comment(s)
Filed under: C#, query, programming, LINQ, database, SQL Server

Microsoft SQL Data Services: From the official site: "SQL Server Data Services (SSDS) are highly scalable, on-demand data storage and query processing utility services. Built on robust SQL Server database and Windows Server technologies, these services provide high availability, security and support standards-based web interfaces for easy programming and quick provisioning." Seems like a very cool concept. For more information go read here: http://www.microsoft.com/sql/dataservices/default.mspx Share this post: email...
Posted 12 March 2008 02:23 AM by riaan
Filed under: C#, Development, web development, database, asp.net, SQL Server