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

My Badges

Request Friendship



Upload Image

My Sections

My Activities

Blogs25
Pages1
riks
1023 · 0% · 26

riks's Home

My name is riks. I live in Ahmedabad, India. I work as SQL Server Developer at VCS.
  • #0259-SQL Server-Implementing Wildcard Search-ESCAPE keyword

    riks Commented 4 Years ago through Blogs
    I try to do by another way.... not sure that is applicable to all the case. DECLARE @Filter VARCHAR(50) ---SET @Filter='*.xlsx' ---SET @Filter='*.Xls' SET @Filter='sample%.txt' SET @Filter=REPLACE(REPLACE(@Filter,'*',''),'%','%[%]%') SELE...
    Nakul Vachhrajani
    4 · 36% · 11648
  • Conditional aggregation - SUM Vs COUNT

    riks Commented 4 Years ago through Blogs
    ok thank you very much Madhivanan...
    Madhivanan JR
    2 · 40% · 13039
  • Question of the month April 2013 - Is space used by VARCHAR(1) and CHAR(1) same?

    riks Commented 4 Years ago through Blogs
    I think char(1) is always occupy one byte space, and varchar occupy space dynamically according to size....
    Madhivanan JR
    2 · 40% · 13039
  • #0253-SQL Server-HASHBYTES-String or binary data would be truncated: Msg 8152

    riks Commented 4 Years ago through Blogs
    @Nakul : Thanks for reply. Is application data type specific? can you give some example that this particular app based on unicode data type and other is based on non unicode data type....
    Nakul Vachhrajani
    4 · 36% · 11648
  • #0253-SQL Server-HASHBYTES-String or binary data would be truncated: Msg 8152

    riks Commented 4 Years ago through Blogs
    Hi , I do not have idea about HASHBYTES but if we use VARCHAR datatype instead of NVARCHAR it would allow USE tempdb; GO --Declare an VARCHAR((MAX) variable DECLARE @tHashInputs VARCHAR(MAX); --Create a 4000 character string SELECT @tHashInput...
    Nakul Vachhrajani
    4 · 36% · 11648
  • #0252 - Shutdown/Restart a local or remote server via command prompt

    riks refreshed 4 Years ago through Blogs
    When working on development projects, one may need to restart servers and/or workstations often. When working from remote locations or on virtual machines hosted on the network, this often becomes a challenge. Today, I will show how to shutdown or resta...
    Nakul Vachhrajani
    4 · 36% · 11648
  • #0252 - Shutdown/Restart a local or remote server via command prompt

    riks Liked 4 Years ago through Blogs
    When working on development projects, one may need to restart servers and/or workstations often. When working from remote locations or on virtual machines hosted on the network, this often becomes a challenge. Today, I will show how to shutdown or resta...
    Nakul Vachhrajani
    4 · 36% · 11648
  • Conditional aggregation - SUM Vs COUNT

    riks Commented 4 Years ago through Blogs
    Hi , Bala Thanks for your reply. but if we use COUNT(CASE WHEN gender='M' THEN 1 ELSE NULL END) . than is it give correct o/p or not??...
    Madhivanan JR
    2 · 40% · 13039
  • Conditional aggregation - SUM Vs COUNT

    riks Liked 4 Years ago through Blogs
    ...
    Madhivanan JR
    2 · 40% · 13039
  • Conditional aggregation - SUM Vs COUNT

    riks Commented 4 Years ago through Blogs
    hi using COUNT(CASE WHEN gender='M' THEN 1 END) as male_count give correct count?? as you said count work as count(*). and can we do COUNT(CASE WHEN .. THEN 1 ELSE NULL END) is it give correct answer??...
    Madhivanan JR
    2 · 40% · 13039
Previous 1 | 2 Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.