VIBE CODED

Search This Blog

Using SQL Profiler

on December 22, 2011

Get link
Facebook
X
Pinterest
Email
Other Apps

Goto Sql Server Management Studio.

Tools - >Sql Server Profiler

Click on "OK" and enjoy.

SQL

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

IPL 2014 live streaming

Watch your favorite teams playing.... Just put the below code in your blog or website

SQL Server 2008 MERGE statement

One Statement for INSERT, UPDATE, DELETE In earlier versions of SQL Server we had to write separate statements for Insert,update and Delete based on certain conditions but now, using MERGE statement we can include the logic of such data modifications in one statement that even checks when the data is matched then just update it and when unmatched then insert it. One of the most important advantage of MERGE statement is all the data is read and processed only once. In previous versions three different statement has to be written to process three different activity (INSERT, UPDATE or DELETE), however using MERGE statement all update activity can be done in one pass of database table. This is quite an improvement in performance of database query. Syntax of MERGE statement is as following: MERGE [ TOP ( expression ) [ PERCENT ] ] [ INTO ] target_table [ WITH ( ) ] [ [ AS ] table_alias] USING ON [ WHEN MATCHED [ AND ] THEN ] [ WHEN NOT MATCHED [ BY TARGET...

Google Authentication with ASP.Net

Code download available at the bottom of the post In this post i would like to share my experience with Google Authentication with Asp.net membership (Forms Authentication) High level google authentication work flow with ASP.NET membership 1. Your application requests access and gets an unauthorized request token from Google's authorization server. 2. Google asks the user to grant you access to the required data. 3. Your application gets an authorized request token from the authorization server. 4. You exchange the authorized request token for an access token. 5. You use the access token to requ...

Powered by Blogger

@Aditya

Using SQL Profiler

Comments

Post a Comment