Mohammad Arifur Rahaman marifrahman

marifrahman / gist:600b0b24cd1f88b79c077bdede99b937

Created January 17, 2023 03:34

Git commands

	##Update last git commit command and pust it

	git commit --amend -m "some comment that to be updated to"
	git push --force-with-lease

marifrahman / Update proof seed data

Created July 26, 2019 02:18

	PRINT 'Seeding MyTest statuses.';

	BEGIN TRY
	BEGIN TRANSACTION

	CREATE TABLE [MyTest].[#Status] (
	[Id] int NOT NULL,
	[StatusLabel] varchar (50) NOT NULL
	);

marifrahman / cmd to get file list

Created November 24, 2017 00:45

dir /b *.pdf >filelist.txt

marifrahman / getGithubProjects.js

Created September 29, 2017 03:17

Javascript to load all github projects

	// Inspired by the code from http://jointheconversation.org


	jQuery.githubUser = function(username, callback) {
	jQuery.getJSON("https://api.github.com/users/" + username + "/repos?callback=?", callback);
	}

	jQuery.fn.loadRepositories = function(username) {
	this.html("<span>Querying GitHub for repositories...</span>");

marifrahman / Excel VSLOOKUP example

Last active September 22, 2016 23:56

=IF(ISERROR(VLOOKUP(A14,Sheet2!B:B,1,FALSE)),"FILTER ME OUT","KEEP ME")

marifrahman / index.html

Created December 12, 2014 04:02

jQuery Multiple email address Validation // source http://jsbin.com/pomofoc

	<!DOCTYPE html>
	<html>
	<head>
	<meta name="description" content="jQuery Multiple email address Validation" />
	<script src="http://code.jquery.com/jquery-2.1.1.min.js"></script>

	<script src="http://ajax.aspnetcdn.com/ajax/jquery.validate/1.8/jquery.validate.js"></script>

	<meta charset="utf-8">
	<title>JS Bin</title>

marifrahman / jsbin.AVOseno.css

Created January 10, 2014 06:30

	body {
	background-image: url('http://lorempixel.com/output/technics-q-c-1244-1096-2.jpg');
	background-repeat: no-repeat;
	background-size: cover;
	text-align:center;
	}

	#maindiv {
	width:900px;
	height:500px;

marifrahman / jsbin.IfiheQu.css

Created August 20, 2013 00:56

	* {
	margin: 0;
	padding: 0;
	}
	body {
	background: url(http://i47.tinypic.com/2090r3c.jpg) no-repeat;
	}
	h1 {
	font:small-caps bold 25px Times New Roman;
	text-transform:capitalize;

marifrahman / SQL_Single _from_multiple_row

Created August 5, 2013 03:08

SQL to create single record from Multiple rows

marifrahman / SQL_server_get_duplicate

Created July 18, 2013 03:08

Get duplicate record in a column for each group

	use DATABASE_NAME
	go
	SELECT YOUR_FIELD, COUNT(*) AS dupes
	FROM YOUR_TABLE_NAME
	GROUP BY YOUR_FIELD
	HAVING (COUNT(*) > 1)

	use DATABASE_NAME
	go
	SELECT YOUR_FIELD, COUNT(*) AS dupes
	FROM YOUR_TABLE_NAME
	GROUP BY YOUR_FIELD
	HAVING (COUNT(*) > 1)