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
2 · 40% · 13039
  • Maximum length of each column

    Madhivanan Liked 7 Months ago through Blogs | 1 Point
    How do I find out the maximum length of each column in a table? Here is the answer declare @sql varchar(8000), @table sysname select @table='your_table', @sql='' select @sql=@sql+'select '''+@table+''' as table_name,'''+column_nam...
  • Removing tags from a string

    Madhivanan Liked 7 Months ago through Blogs | 1 Point
    In http://ask.sqlteam.com, a question was asked about removing the comments from the HTML template The comments have the following pattern {/*}comment{*/} The comments can be nested too The task is to remove all the comments Here is my ...
  • Generate Fibonacci series - No loop, no recursion

    Madhivanan Liked 7 Months ago through Blogs | 1 Point
    Generating the Fibonnaci series generally involves in writing the code which has while loop or a recursive function Peso posted the code using the Common table expression Here are my methods that involve no loop or no recursion 1 Use Quirky u...
  • Cursor statuses

    Madhivanan Liked 7 Months ago through Blogs | 1 Point
    Here are the queries that findout the cursors based on their statuses 1 Find out the cursors that are allocated but not opened or closed --Method 1 select name from sys.dm_exec_cursors(0) where is_open =0 --Method 2 select cu...
  • Dropping all temp tables

    Madhivanan Liked 7 Months ago through Blogs | 1 Point
    In SQL Forum one of the posters asked a question about dropping all the temporary tables There are many ways to do this One of the ways to to run the following code declare @sql varchar(8000) set @sql='' select @sql = @sql+' drop table '+name f...
  • How to Generate Script along with Data?

    Madhivanan Liked 7 Months ago through Blogs | 1 Point
    One of the new features available in SQL Server 2008 is scripting the tables along with data (in the form of INSERT statements). Here are the useful links that can help you generating script with data SQL Server 2008 http://www.kodyaz.com/articl...
  • Regular expression

    Madhivanan Liked 7 Months ago through Blogs | 1 Point
    <pre>One of the posters asked a question in the forums about finding a number in an expression consists of alphabets and number if a particular digit is provided Consider the following set of data this is test place located at no 123456 te...
  • How to display detailed data below each header data?

    Madhivanan Liked 7 Months ago through Blogs | 1 Point
    One of my friends asked me if it possible to generate Detailed data for each Header data without using a Cursor or while loop. (The output is something like the one usually seen via reporting tool). He wanted the result to be output to text file ...
  • CTE in a View

    Madhivanan Liked 7 Months ago through Blogs | 1 Point
    It is possible to use Common Table Expression in a View. But newbies wonder why the following is not possible create view numbers as with numbers(n) as ( select 1 as n union all select n+1 from numbers where n Which when created results to the...
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.