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 (53 total posts)
  • TSql Wishes (Part 1)

    TSQL’s IN keyword has tremendous power; using it one can determine the given value matches any value in a sub query or list. For example;   select userid from users where accountindex in (14, 17);   I wish, that modern languages like Java/C# offers same kind of keyword that can ease many implementation scenarios.   I also wish, that ...
    Posted to Khurram Aziz (Weblog) by khurram on April 8, 2004
  • 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 was required to verify each character of the string passed to the SQL sproc. Here is the TSql snippet that I used to implement this requirement. --@@i is int, @PinCode is nvarchar(15)set @@i=1;while @@i <= datalength(@PinCode)--datalength ...
    Posted to Khurram Aziz (Weblog) by khurram on March 25, 2004
Powered by Community Server (Personal Edition), by Telligent Systems