Jim questions

Jim answers

• Update the first row in sql server table if a condition is met
• SSRS View layout different than Print layout
• SQL - User input in query
• Change the name of columns after they became rows values in unpivot query SQLSERVER2008
• SqlCommand.Prepare method requires all parameters to have an explicitly set type
• WNetAddConnection2 returns 1219
• There was an exception running the extensions specified in the config file. Maximum request length exceeded
• SQL stored procedure IF EXISTS UPDATE ELSE INSERT
• Right pad a string with variable number of spaces