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.

Friends

Request Friendship



Upload Image

Chennai, India
Male
Madhivanan
3 · 40% · 12936

Madhivanan's Home

My name is Madhivanan. I live in Chennai, India. I work as Lead Subject Matter Expert. I blog at .  +Madhivanan
  • Numbers in ORDER BY Clause

    Madhivanan Posted 5 Hours ago through Blogs
    You can use numbers in ORDER BY Clause so that it will sort the result set based on the ordinal position of the column. But when numbers are used in a CASE Expression, they do not refer the ordinal position of the columns but they behave like ordering a...
  • DATE datatype and arithmetic operation

    Madhivanan Commented 2 Months ago through Blogs
    Thanks Jeff Moden for your reply. I have seen significant usage of these DATE and TIME datatypes recently by many people and when they try to simulate everything they do with DATETIME, these errors are coming in. So when some one is using both DATE and ...
  • DATE datatype and arithmetic operation

    Madhivanan Posted 2 Months ago through Blogs
    DATE datatype was introduced in version SQL Server 2008 which stores only Date part. If you use DATETIME datatype it is possible to do arithmetic operations directly like adding or subtracting day part as shown below declare @datetime datetime select @d...
  • Remove duplicate characters from a string

    Madhivanan Liked 2 Months ago through Blogs
    Pinal Dave in his weblog posted about Remove Duplicate Chars From String Here is its alternate method with Number table approach create procedure remove_duplicate_characters(@string varchar(100)) as Declare @result varchar(100) set @result='' se...
  • Extract only numbers from a String

    Madhivanan Liked 2 Months ago through Blogs
    Sometimes we may need to extract only numbers from a string. Usually I see people using while loop to check each and every character to see if it is a number and extract it Here is a different approach Declare @s varchar(100),@result varchar(100) set...
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.