Monthly Archives: July 2008

OleDbCommand doesn’t support named parameters

When calling a parameterized stored procedure, if you pass parameters to a SqlCommand object (i.e. cmd.Parameters.AddWithValue(“@productID”, strProductID); cmd.Parameters.AddWithValue(“@productName”, strName); … ) SqlCommand will correctly map the value with the parameter regardless of the order these AddWithValue methods are called. However, … Continue reading

Posted in .NET, SQL | Leave a comment

Sorted view in SQL 2005

It looks like something new in SQL 2005. If you try to add a “order by” in the view, the management studio will automatically add a “TOP (100) PERCENT” after the SELECT clause. However this only works in “preview” mode. … Continue reading

Posted in SQL | Leave a comment