Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.


Request Friendship

Upload Image

Chennai, India
2 · 40% · 13039

Madhivanan's Home

My name is Madhivanan. I live in Chennai, India. I work as Lead Subject Matter Expert. I blog at .  +Madhivanan
  • Openrowset and sp_who2

    Madhivanan Liked 3 Years ago through Blogs
    OPENROWSET function can be used to query on the database exists in different server or query on the stored procedure. Consider that the system procedure sp_who2 gives informations about the current users, sessions, etc. EXEC sp_who2 But note that t...
  • Why does sp_who2 return duplicate columns?

    Madhivanan Liked 3 Years ago through Blogs
    I have already posted a blog post about the usage of sp_who2 in OPENROWSET function. It is not possible to use it because sp_who2 returns duplicate column names (SPID) In this post we will analyse why it returns duplicate columns The system procedure ...
  • Is there a Batch separator in Dynamic SQL?

    Madhivanan Posted 3 Years ago through Blogs
    As you know Batch separator(GO) in SQL Server is used to signal the end of batch of statements. However this will only work if the statements are static. In a dynamic SQL, batch separator will not work. Consider the static following statements SELECT T...
  • Data validation using TRY_CONVERT function

    Madhivanan Posted 3 Years ago through Blogs
    One of the new functions introduced in version 2012 is TRY_CONVERT which is very handy in validating data with respect to specific datatypes. In earlier versions you may need to use different approaches to validate data. Let us consider the following da...
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.