Proud To Be Pakistanis!
Welcome to weblogs.com.pk Sign in | Join | Help
in Search

Browse by Tags

All Tags » Databases
Showing page 2 of 2 (52 total posts)
  • Knowing Identity Value

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on April 3, 2004
  • Verifying Strings In TSql

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on March 25, 2004
Powered by Community Server (Personal Edition), by Telligent Systems