Monthly Archives: April 2013

Telerik Controls

I am wroking on Telerik controls from 1.6 yrs in my company so would like to say something on it. Telerik controls are third party vendor controls which are designed and created by Telerik organization. These controls are mainly designed on behalf of ASP.net controls though we have a lot of controls in asp.net but […]

Query to get last modified procedures or table names in sql server

These are the some basic sql queries which helps during the development process. In order to get top 10 procedures names which are modified recently you can use SELECT top(10)OBJECT_NAME(object_id) as name,modify_date,type_desc,create_date FROM sys.objects WHERE type = ‘P’  Gives you last 10 modified procedure names SELECT top(10)OBJECT_NAME(object_id) as name,modify_date,type_desc,create_date FROM sys.objects WHERE type = ‘U’ […]

Reflection

Introduction Reflection is used to get the information regarding assemblies,type of object,modules and classes at runtime. you can also create instances of type and assemblies at runtime,invoke methods of objects,get names of assemblies dynamically. it’s similar to Runtime type information in c++. System.Reflection namespace used for reflection which contains all required classes and interfaces for […]

Window Azure – A cloud Platform

Today the entire IT industry moving towards the Cloud Computing technology.Window Azure amongst the one which gain more name in field of cloud computing by providing its platform as service. The cloud computing mainly categories under three services SAAS : – Software as a service (Eg : Gtalk) PAAS : – Platform as a service […]

PHP Framework

Here we have top 20 framework for php using which we can build real-world application which are fast,secure and reailable. please follow url : http://woork.blogspot.in/2008/11/20-great-php-framework-for-developers.html Thank You!

Difference between ISNULL and COALESCE

ISNULL ISNULL  function returns null value with replacement value. Syntax : ISNULL(expression_value,replacement_value) It will take only 2 parameters or arguments.First it will check the expression value if its null then it will return replacement value. Eg : Declare @value varchar(10) Set @value = 10 Select ISNULL(@value,’n/a’) as Demo In the above scenario the output is […]

Getting all the table names from Database

I was creating some POC on migrating the data from Sql Server to MongoDB that time i faced this problem how to get all table names from a particular database in sql server 2008 and i came up with this query SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = ‘BASE TABLE’ After executing this query you […]