Archives
-
Tip 12 : Common T-SQL Escape Scenarios: Percent (%), Underscore (_)
Scenario 1 : You have a Purchase table with field named DiscountRate. The DiscountRate values can be true percentage such as "2.5%", "5.0%", or can be other values such as "N/A", "Fixed Rate", etc. You want all the records with true percentage.
-
Tip 11 : Group By Date for DateTime Type Field
You have a Purchase table with fields of ID, PurchaseAmount and PurchaseDate. The PurchaseDate field is DateTime type that includes Date and Time information. You want daily total purchase amount.
-
Architect 3 : Building Data Access Layer Using Microsoft Enterprise Library 4.1
You have a Customer table with three fields: ID, LastName and FirstName. You are building a data access layer to retrieve all the records from the Customer table and return the result as a collection of Customer objects. You want implement it using Microsoft Enterprise Library.
-
Solution 5 : Implementing Optional Parameters in T-SQL Stored Procedures
You have a stored procedure GetCustomers with two parameters: LastName, FirstName. The stored procedure returns all the records matching the values of the parameters. You want the parameters be optional, which means skipping the parameter if you do not pass a value.
-
Tip 10 : Returning the first part of a string with delimiter
You have a string delimited by underscore such as 1stPart_2ndPart_3rdPart and want to return the first part of the string only.