Showing page 2 of 2 (52 total posts)
If you are involved in database application development, especially in Data Access Layer development, it is often required to know the value of the last inserted Identity Value (SQL Server equivalent of AutoNumber in Access)
Once I happen to see a very funny code doing this. It was an ASP3 application, coded in VBScript using ADO. The ...
One should always verify the inputs of the code; it applies to the SQL stored procedure. It is often required to verify each character of the given string.
Recently I moved such checking logics into the database engine to get few extra performance bits. We have a field in the database PinCode, that in routine should only be numeric, but in few ...