What is Mobile app?

Mobile app

A mobile application (or mobile app) is a software application designed to run on smartphones, tablet computers and other mobile devices. They are available through application distribution platforms, which are typically operated by the owner of the mobile operating system, such as the Apple App Store, Google Play, Windows Phone Store and BlackBerry App World. Some apps are free, while others have a price. Usually, they are downloaded from the platform to a target device, such as an iPhone, BlackBerry, Android phone or Windows Phone, but sometimes they can be downloaded to less mobile computers, such as laptops or desktops.

Mobile apps were originally offered for general productivity and information retrieval, including email, calendar, contacts, and stock market and weather information. However, public demand and the availability of developer tools drove rapid expansion into other categories, such as mobile games, factory automation, GPS and location-based services, banking, order-tracking, and ticket purchases. The explosion in number and variety of apps made discovery a challenge, which in turn led to the creation of a wide range of review, recommendation, and curation sources, including blogs, magazines, and dedicated online app-discovery services.

Distribution as on 20-09-2012

Google Play
             -  application store for the Google Android operating system.With over 600,000 apps

BlackBerry App World
             -  Apps for the BlackBerry mobile devices . With over 99,500 apps
Nokia Store
             -  An app store for the Nokia phone.  With over 1,20,000 apps

Windows Phone Marketplace
              -  Windows Phone Marketplace is a service by Microsoft for its Windows Phone 7 platform. with over 1,00,000 apps
Apple App Store
                - The Apple App Store is a digital application distribution platform for iOS developed and maintained by Apple Inc. 7,25,700+ apps

SyncLock and Lock in C#

SyncLock and Lock in C#

The lock (C#) and SyncLock (Visual Basic) statements can be used to ensure that a block of code runs to completion without interruption by other threads. This is accomplished by obtaining a mutual-exclusion lock for a given object for the duration of the code block.

A lock or SyncLock statement is given an object as an argument, and is followed by a code block that is to be executed by only one thread at a time. For example:

public class TestThreading
{
    private System.Object lockThis = new System.Object();

    public void Process()
    {

        lock (lockThis)
        {
            // Access thread-sensitive resources.
        }
    }

}

Copy one table name to another table name in Sql Server

Copy one table name to another table name in Sql Server



 INSERT INTO tablename1(column1,

column2

,

column3

)

SELECT  column1,

column2

,column3 from tablename2

Stored procedure that create in last N Days in Sql Server

Stored procedure that create in last N Days in Sql Server



SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 7
----Change 7 to any other day value.

Stored Procedure that change in last N days in Sql Server

Stored Procedure that change in last N days in Sql Server


SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < 7
----Change 7 to any other day value

To know the stored procedure created date and modified date in Sql Server

To know the stored procedure created date and modified date in Sql Server


SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND name = 'sp_name'  -- stored procedure name

To show the stored procedure permission details in SQL Server

To show  the stored procedure permission details in SQL Server:

select U. name, O. name, permission_name from sys . database_permissions
join sys . sysusers U on grantee_principal_id = uid
join sys . sysobjects O on major_id = id
where O. name like 'sp_name' -- stored procedure name
order by U. name