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

34 years old
Ahmedabad
Male
Alpesh Patel
36 · 5% · 1662

Alpesh Patel's Home

My name is Alpesh Patel. I live in Ahmedabad, India. I work as Sr. Analyst Programmer at Gateway Technolabs.
  • SQL SERVER : Insert a value in table which has only Identity field.

    Alpesh Patel Liked 4 Years ago through Blogs
    Insert a value in table which has only Identity column automatically without specifying any hard value for that column. No identity_insert ON/OFF.....
    PareshPatel
    1641 · 0% · 12
  • With Result Sets in Denali (SQL Server 2012)

    Alpesh Patel Commented 4 Years ago through Blogs
    Hi, insert into @tblStoreWithResultSetsData EXEC Usp_FetchRecords WITH RESULT SETS ( ( [Emp Id] int, [Emp Name] varchar(6), -- as a proof of concept, -- change the dataType size to 6. -- Records wil...
    Niladri Biswas
    7 · 21% · 6720
  • Nested INTO EXEC statement in SQL Server

    Alpesh Patel Learned 4 Years ago through Just Learned
    Today I came across the problem. When One my SP has Insert Into Table Exec SP_Name and doing same another SP using the Main SP. The moment I am getting the error "An INSERT EXEC statement cannot be nested." To resolve the Issue Do the steps. **...
  • Nested INTO EXEC statement in SQL Server

    Alpesh Patel Liked 4 Years ago through Just Learned
    Today I came across the problem. When One my SP has Insert Into Table Exec SP_Name and doing same another SP using the Main SP. The moment I am getting the error "An INSERT EXEC statement cannot be nested." To resolve the Issue Do the steps. **...
  • Nested INTO EXEC statement in SQL Server

    Alpesh Patel Posted 4 Years ago through Just Learned
    Today I came across the problem. When One my SP has Insert Into Table Exec SP_Name and doing same another SP using the Main SP. The moment I am getting the error "An INSERT EXEC statement cannot be nested." To resolve the Issue Do the steps. **To ...
  • Risk Matrix Chart in SSRS

    Alpesh Patel Liked 4 Years ago through Blogs
    ...
    Jason Thomas
    19 · 9% · 2997
  • T-SQL Enhancement: EXECUTE WITH RESULT SETS

    Alpesh Patel refreshed 4 Years ago through Blogs
    All developers know, that it is very important to encapsulate code in classes and methods to be able to reuse bits and pieces for other purposes than they were originally made for. The same goes for t-sql development, by usin...
    Geniiius
    136 · 1% · 369
  • T-SQL Enhancement: EXECUTE WITH RESULT SETS

    Alpesh Patel Liked 4 Years ago through Blogs
    All developers know, that it is very important to encapsulate code in classes and methods to be able to reuse bits and pieces for other purposes than they were originally made for. The same goes for t-sql development, by usin...
    Geniiius
    136 · 1% · 369
  • How to check value is a whole number or having decimal fraction in sql sever?

    Alpesh Patel Learned 4 Years ago through Just Learned
    The trick is to append `.0e0` to the string and if it returns 1, the value is a whole number (no decimal fractions). DECLARE @val VARCHAR(100) SELECT @val = 'a' SELECT ISNUMERIC(@val + '.0e0') -- Returns 0 SELECT @val = '25' SELECT ISNUMERI...
    maninderwadhva
    2275 · 0% · 6
  • How to check value is a whole number or having decimal fraction in sql sever?

    Alpesh Patel Liked 4 Years ago through Just Learned
    The trick is to append `.0e0` to the string and if it returns 1, the value is a whole number (no decimal fractions). DECLARE @val VARCHAR(100) SELECT @val = 'a' SELECT ISNUMERIC(@val + '.0e0') -- Returns 0 SELECT @val = '25' SELECT ISNUMERI...
    maninderwadhva
    2275 · 0% · 6
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.