function
-
MSSQL User Defined Functions vs Stored Procedures
I received this question earlier today, and thought it was a valid question often misunderstood, and deserving of a small write-up: “Should a User Defined Function be your first choice instead of a Stored Procedure?” While there are many pros… Continue reading
-
mssql aes function encrypt decrypt in microsoft sql
Simple symmetric encryption in MSSQL. Copied from MS references below: References: http://msdn.microsoft.com/en-us/library/bb669072.aspx http://msdn.microsoft.com/en-us/library/ms179331.aspx Continue reading
-
call parent page from user control to invoke page methods
To illustrate how we will accomplish this using Reflections, we will be using repeater in a user control within a page. Your repeater loads data easily within the user control code behind, but you want to utilize the “ItemCommand” event… Continue reading
-
Lambda Functions in .Net
Lambda expressions in .Net are denoted by the ‘=>’ symbol. These powerful operators can be used to create sleek, optimized loops that perform much faster. The usage below condenses the equivalent of at least 20 lines of two loops. (Sorry… Continue reading