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

Posted to Riaan's Blog (Weblog) by riaan on 08-13-2008
Stored procedure generator

A tool to create the basic insert,update,select statements to your SQL tables. http://www.codeplex.com/spgen

Posted to Riaan's Blog (Weblog) by riaan on 05-27-2008
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

Posted to Riaan's Blog (Weblog) by riaan on 04-18-2008
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...

Posted to Riaan's Blog (Weblog) by riaan on 03-12-2008

Page 1 of 1 (4 items)

dotnet.org.za