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

Madhivanan's Home

My name is Madhivanan. I live in Chennai, India. I work as Lead Subject Matter Expert. I blog at .  +Madhivanan
  • Export to Excel - data length exceeds 255 characters

    Madhivanan Liked 2 Years ago through Blogs
    If you use Data Transaformation Services to send data to EXCEL, you may get error about the size of the cell if length of data exceeds 255 characters. This KB from microsoft explains how to solve it http://support.microsoft.com/default.aspx?scid=kb;...
  • Removing unwanted characters

    Madhivanan Liked 2 Years ago through Blogs
    Sometimes when you import data from other system, you may want to clean up data by removing unwanted characters You can use Replace function. Suppose you want to remove the character ^ from the string declare @str varchar(100) set @str='test^ st...
  • How to find size of backup files in a folder?

    Madhivanan Liked 2 Years ago through Blogs
    I was asked to findout total size of all the backup files in the folder As I didnt have access to view the folder of the server, I used this. I hope it may be helpful create table #t(files varchar(1000)) Insert into #t EXEC master..xp_cmdshell...
  • Last Backup/Restore date of database

    Madhivanan Liked 2 Years ago through Blogs
    If you want to know the last Backup/Restore date of database, use the following --Last Backup date of database --Method 1 In Management Studio,Expand database,Right Click on the database and click properties Refer Last Batabase Backup which is...
  • Tables with no Primary and Foreign keys

    Madhivanan Liked 2 Years ago through Blogs
    John Paul Cook has posted in his blog to show the list of tables that have no Referential Integrity. What if you want to know list of tables that have no primary and foreign keys? Here is the query select table_name from INF...
  • Beware of the Usage of SET ROWCOUNT

    Madhivanan Liked 2 Years ago through Blogs
    This is used to set the number of rows affected for DML Declare @test table(number int) set rowcount 1 insert into @test select 11 union all select 10 set rowcount 0 select number from @test The above inserts only one row to the table v...
  • Which columns uniquely identify a row?

    Madhivanan Liked 2 Years ago through Blogs
    Without seeing the table structure,If you are interested in knowing which columns uniquely identify a row in a table, you can use this system procedure EXEC sp_special_columns table_name ......
  • Table level Backup/Restore

    Madhivanan Liked 2 Years ago through Blogs
    It may be very useful if we have feature to take backup or restore a table I have posted my suggestion here Table level Backup/Restore What do you think of it? ......
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.