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
  • I have moved my blog

    Madhivanan Posted 2 Years ago through Blogs
    To the people who follow me in this blog, for your informaion, I have moved my blog to Please make sure to follow it to get the posts from me. I would like to thank Jacob Sebastian for giving me a space in this site. I ...
  • Object Catalog Views in SQL Server 2005

    Madhivanan Liked 2 Years ago through Blogs
    In addition to INFORMATION_SCHEMA VIEWS, in SQL Server 2005, we can use Object Catalog Views to know more informations about the objects Refer this
  • Union Vs Union All

    Madhivanan Liked 2 Years ago through Blogs
    Well. Most of you know the diffrence between the two. ...
  • Different ways to know structure of a table

    Madhivanan Liked 2 Years ago through Blogs
    You can use one of the following to know the structure of a table Generate SQL Script option from Enterprise Manager/Management Studio select * from information_schema.columns where table_name='table_name' EXEC sp_help 'table_name' EXEC sp...
  • Derived Table - New approach to avoid SQL Injection

    Madhivanan Liked 2 Years ago through Blogs
    People use Dynamic SQL for various purposes One of the disadvantages of it is SQL injection that can attack your database by doing the things that you didn't want to do Consider a case where usage of Dynamic SQL in unavoidable You have a table that reco...
  • How to disable all jobs using a query?

    Madhivanan Liked 2 Years ago through Blogs
    When one of posters asked a question about this, someone posted the following reply UPDATE msdb.dbo.sysjobs SET enabled = 0 As sysjobs is a system and updating it is generally not advised, the following can be used instead declare @sql varchar(max...
  • routine_definition from information_schema.routines

    Madhivanan Liked 2 Years ago through Blogs
    Some people suggest usage of information_schema.routines View to view the definition of the procedure The problem is the datatype of that column is nvarchar(4000) and there is a chance that the definition gets truncated. So, the following wont give yo...
  • Find alternate week day

    Madhivanan Liked 2 Years ago through Blogs
    My co-worker had a task of finding minimum alternate week day as of today for a given date and day. Consider these data Date : 2009-12-22 day : 5 (it denotes Thursday) It means the event was scheduled on 2009-12-22 which s...
  • Happy Holidays

    Madhivanan Liked 2 Years ago through Blogs
    In the Query Analyser, set the Result mode to Text (Press CTRL+T) and run the following code set nocount on select space(17-len(replicate(char(94),no)))+ replicate(char(94),no*2-1) from ( select top 10 row_nu...
  • Replace data of one table with data of other table

    Madhivanan Liked 2 Years ago through Blogs
    One of the questions asked in a forum was about replacing data of one table by the data of another table The solution that the questioner used was having cursor by looping through the source table and replace particular words by other words from ...
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.