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
3 · 40% · 12958
  • Replacing exact words

    Madhivanan Posted 9 Months ago through Blogs | 10 Points
    A question was asked in a Facebook group. I am struck in a situation where I have to replace specific characters from a string in sql server.. This's simple but now the condition is, replace the only characters which are not tied with any other characte...
  • Identity insert error

    Madhivanan Posted 9 Months ago through Blogs | 10 Points
    create table identity_test(id int identity(1,1),first_name varchar(100)) insert into identity_test (first_name ) select 'Madhivanan' union all select 'Nilesh' select * from identity_test set identity_insert identity_test on insert into identit...
  • Dynamic PIVOT in SQL Server 2005

    Madhivanan Commented 9 Months ago through Blogs | 1 Point
    Hi sqlgator, can you remove alias names in the second and third parameters? Try the below exec dynamicpivot 'SELECT prov.PROVIDER, ids.providerid from dbo.Providers as prov left outer join dbo.providerIDS as ids on prov.provider = ids.PROVIDER', 'pro...
  • Openrowset and sp_who2

    Madhivanan Liked 9 Months ago through Blogs | 1 Point
    OPENROWSET function can be used to query on the database exists in different server or query on the stored procedure. Consider that the system procedure sp_who2 gives informations about the current users, sessions, etc. EXEC sp_who2 But note that t...
  • Why does sp_who2 return duplicate columns?

    Madhivanan Liked 9 Months ago through Blogs | 1 Point
    I have already posted a blog post about the usage of sp_who2 in OPENROWSET function. It is not possible to use it because sp_who2 returns duplicate column names (SPID) In this post we will analyse why it returns duplicate columns The system procedure ...
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.