Mittal Profile

Sandeep

Join Date:
2011-09-27

Blogs Owned

1. IT Developers Zone

The motto of the blog is to provide solutions to the developers

Tags: sql server, asp.net, javascript, jquery, linq

2. Stories, Jokes & Fun

Stories, Jokes & Fun

Tags: stories, motivation, inspiration, jokes, fun

Latest Blog Posts

  • Except and Intersect in sql
    on Nov 9, 2013
    EXCEPT and INTERSECT operator works on two resultsets.Basic rules for combining two resultsetsNo. of columns in both resultset should be equalThe order of columns should be sameCorresponding data type of each column in each select should be...
  • row_number in sql
    on Oct 14, 2013 in SQL Server 2005
    Row_Number feature was introduced in SQL Server 2005.Row_Number generates a run-time column in the result set which generates sequential number to each row according to the column used in order by clause.SyntaxRow_Number() over (order...
  • Create End Point in SQL Server
    on Oct 7, 2013 in Sql Server
    In earlier article, we learn about EndPoint in SQL ServerIn this article, we would learn how to create an Endpoint in SQL ServerBefore creating an endpoint, we need to reserve an HTTP Namespace to expose the endpoint.EXEC sp_reserve_http_namespace N'...
  • End Points in Sql Server
    on Oct 7, 2013 in Sql Server
    A SQL Server endpoint is the point of entry into SQL Server, or a way to connect to SQL Server instance.Endpoints in SQL Server are similar to Web Services that expose database access over HTTP.There are 5 system endpoints that are automatically crea...
  • How to start or stop an endpoint in SQL Server
    on Oct 7, 2013 in Sql Server
    In this post, we would see how to start or stop a SQL End PointLet's first query sys.endpoints catalog view and see all the end points exists select * from sys.endpointsOUTPUTTo stop an endpoint:ALTER ENDPOINT endpoint_name STATE = STOPPEDT...
  • SQL Server : Msg 6004, Level 16, State 12, Line 1 User does not have permission to perform this action.
    on Oct 7, 2013 in Sql Server
    You might get the following error while creating an end point in SQL ServerThis error is generated when a user is trying to create an endpoint but do not has the access.Resolution: Contact Server Administrator and ask him/her to grant the "Create End...
  • Nested Transaction in Sql Server
    on Jul 24, 2013
    In previous article, we learnt about transaction.In this article we will see how nested transaction worksIn nested transaction, the variable @@TRANCOUNT can be used to check the count of level of nested transactions. The variable ...
  • Transaction in Sql Server
    on Jul 23, 2013 in Sql Server
    In this article, I am sharing the concept of transaction in sql server and how it is implemented.Transactions run as a group of commands or queries as single execution unit. It ensures either all the commands or queries will be executed or none of th...
  • jQuery Basic Interview Questions and Answers
    on Jul 21, 2013 in JQuery Interview Questions
    Question : What is jQuery?Answer   : jQuery is a light weight JavaScript library which provides fast and easy way of HTML DOM traversing and manipulation, event handling, and client side animations, etc. One of the greatest features of...
  • encrypt stored procedure
    on Jul 12, 2013 in Sql Server
    In SQL Server, stored procedures are generally created to hold the business logic of the application. For security reasons, you may want to hide your business logic from the end users. With Encryption keyword is used to encrypt the definiti...
  • Triggers in Sql Server : Part - 4
    on Jun 25, 2013 in Sql Server
    In earlier parts, we learnt what is trigger what are magic tables in trigger.After Trigger ExampleIn this part, we will take an example of Instead of trigger and will see how it works.In the example we are taking two tables, ...
  • Triggers in Sql Server : Part - 3
    on Jun 25, 2013 in Sql Server
    In earlier parts, we learnt what is trigger what are magic tables in trigger.In this part, we will take an example of After trigger and will see how it works. In the example we are taking two tables, one for "sales" and one for "s...
  • Triggers in Sql Server : Part - 2
    on Jun 25, 2013 in Sql Server
    In Part-1, we learnt about what is trigger.In this part, we will learn about Magic tables in triggers.Magic Tables are logical tables which are created automatically when DML operations (insert/update/delete") are performed. These tables temporarily...
  • Triggers in Sql Server : Part - 1
    on Jun 25, 2013 in Sql Server
    A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database.Types of triggerDDL triggers execute on data definition language (DDL) events like CREATE, ALTER, and DROP statements, and cert...
  • collation issues sql server
    on Jun 10, 2013 in Sql Server
    In previous article, we learnt about collation in SQL ServerIn this article, we will discuss some of the common issues that encountered with collation.Collation issues arises with string type of datataypes like char, nchar, varchar, nvarchar, text et...
  • collation in sql server
    on Jun 10, 2013 in Sql Server
    Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types, and...
  • yield keyword in c#
    on Jun 8, 2013 in Visual Studio 2005 C#
    With yield keyword, the control moves from the caller to source and from the source back to the caller to and fro.yield statement can be used in two formsyield return <expression>;yield break;yield return statement returns each e...
  • Apply operator in Sql Server
    on May 28, 2013 in SQL Server 2005
    Recently in a scenario, I used Cross Apply in a query and one of my colleagues asked me why and where to use Cross Apply and what is the difference between Cross Join and Cross Apply, so I thought of publishing an article related to same.Cross Apply...
  • Output Clause in SQL Server 2005
    on May 19, 2013 in Sql Server SQL Server 2005
    SQL Server 2005 introduced a new TSQL feature OUTPUT clause that allows you to retrieve data affected by insert/update/delete statements easily. The OUTPUT clause returns the data that you've inserted or deleted from the table within the statement.&n...
  • Customize a TFS Work Item to create new Work Item
    on May 17, 2013 in Team Foundation Server
    Prerequisite:To export or list work item types, you must be a member of the Project Administrators group or have your View project-level informationpermission set to Allow.To import work item types, you must be a member of the Team Foundation Adminis...
2
Blogs
0
Followers
0
Following
Loading Comments...

My Wall

{ds_PageTotalItemCount} commentcomments
{pvComments::date}
{pvComments::comment}

Post a Comment

Log in or Register to place a comment

Close