Nipul Parikh

Alert user before leaving web page with unsaved changes

I have spent the last few days trying to search for the solution to alert users before leaving the web page when users make some change and try to leave the page without saving changes.

After trying multiple solutions using client-side and server-side, I found a very useful jQuery plugin – Are You Sure?

Find how you can configure in your project from here. GitHub 

I found this very simple and…

After 1 year, I am writing this article which I feel can help many developers like me.

Converting word document in HTML format has now become easier. I came across a solution to convert the .docx file into HTML file with its formatting using Open XML Tool.

First, we need to install the following NuGet packages in our Visual Studio Project solution.

Install-Package DocumentFormat.OpenXml

Install-…

How to parse html tags and return only text from string in SQL Server without using regular expressions or remove text between < and > and get only text from string in SQL Server

To implement this functionality we need to create one user defined function to parse html text and return plain text.

Function to replace html tags in string

CREATE FUNCTION [dbo].[RemoveHTMLTag]

(@HTMLText VARCHAR(MAX)

— TO GET STORED PROCEDURE TEXT/INFORMATION

SP_HELPTEXT  ‘<STORE PROCEDURE NAME>’;

— TO RENAME THE STORED PROCEDURE

SP_RENAME ‘<CURRENT STORED PROCEDURE NAME>’, ‘<NEW STORED PROCEDURE NAME>’;

— TO CHECK TABLE DEPENDENCIES

SELECT DISTINCT SYSOBJ.NAME, SYSOBJ.XTYPE

FROM SYSCOMMENTS SYSCOM

INNER JOIN SYSOBJECTS SYSOBJ ON SYSCOM.ID = SYSOBJ.ID

WHERE SYSCOM.TEXT LIKE ‘%<TABLE NAME>%’;

— TO FIND TABLE…

SELECT IDENT_CURRENT(‘<Table Name>‘);

SELECT IDENT_CURRENT(‘<Table Name>‘)+IDENT_INCR(‘<Table Name>‘);

SELECT MAX(<primary key column name>) FROM <Table Name>;

This won’t work if the database is empty, because it returns NULL.

⇒ Please note that this method can be used to predict the next id, but does not guarantee this return value. Because the time you execute request and time it take to…

The Six Commandments of Good Code: Write Code that Stands the Test of Time

Humans have only been grappling with the art and science of computer programming for roughly half a century. Compared to most arts and sciences, computer science is in many ways still just a toddler, walking into walls, tripping over its own feet, and occasionally throwing food across the table. As a consequence of its relative youth, I don’t believe we have a consensus yet on what a proper…

BEM Methodology : Introduction

BEM stands for Block Element Modifier.

Blocks, elements, and modifiers are all called BEM entities.

It is a notion that can be used both to refer to an individual BEM entity and as a generic term for blocks, elements, and modifiers.

BEM methodology was invented at Yandex to develop sites which should be launched fast and supported for a long time. It helps to create extendable and reusable…

Alternate Key, Candidate key, Composite Key, Foreign Key, Primary Key in RDBMS

We use the database to organize information. To maintain data in a correct and well formed, we use concept of keys. There are five types of keys in database which are as follows –

Alternate Key

Candidate key

Composite Key

Foreign Key

Primary Key

To understand keys, we will take EmployeeMaster table as example –

EmployeeMaster { EmployeeID, EmpFirstName, EmpLastName, DesignationID }

Table keys are:

Access modifiers in C#

Access modifiers in C#:

public, protected, internal, and private.

Public access means accessible by any code.

Protected access enables access for all derived classes.

Internal access enables access from any code in the same assembly.

Private access is limited to code in the same class.

Happy Coding :)

Xamarin acquired by Microsoft

Now it is a part of # Visual Studio

Following script find out which are the queries running currently on your server.

SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

While running above query if you find any query which is running for long time it can be killed using following command.

KILL…

Replace multiple space with single space – SQL Server

Replace multiple space with single space – SQL Server

DECLARE @Temp TABLE (OriginalString VARCHAR(8000))

INSERT INTO @Temp (OriginalString) SELECT ‘ Hello. This is Hello World. ‘

SELECT REPLACE(REPLACE(REPLACE(LTRIM(RTRIM(OriginalString)), ‘ ‘, ‘ ‘ + CHAR(7)), CHAR(7) + ‘ ‘, ”), CHAR(7), ”) AS [result] FROM @Temp WHERE CHARINDEX(‘ ‘, OriginalString) > 0

Happy Coding :)

Split a delimited string AND LOOP through

Split a delimited string AND LOOP through

DECLARE @Id VARCHAR(50)

SET @Id = ‘51,52,61,75,95’

WHILE LEN(@Id) > 0 BEGIN PRINT LEFT(@Id, CHARINDEX(‘,’, @Id + ‘,’) – 1)

–Your SP Code

SET @Id = STUFF(@Id, 1, CHARINDEX(‘,’, @Id + ‘,’), ”) END

Happy Coding :)