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
  • DATETIME, DATE and TIME datatypes and arithmetic operation

    Madhivanan Posted 22 Days ago through Blogs | 10 Points
    In this post DATE and arithmetic operation we have known that we can not use arithmetic operation directly on DATE datatype as we use it for DATETIME datatype. In this post I am going to show you some other examples with DATE and TIME datatypes as well....
  • DATE datatype and arithmetic operation

    Madhivanan Commented 2 Months ago through Blogs | 1 Point
    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 | 10 Points
    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 | 1 Point
    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 | 1 Point
    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...
  • Finding out datatype of an expression or a variable

    Madhivanan Posted 3 Months ago through Blogs | 10 Points
    One of friends asked me if there is a way to identify the datatype of an expression or a variable. In SQL Server, you can make use of the function named SQL_VARIANT_PROPERTY. This function accepts a parameter of any datatype and return it's various prop...
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.