Skip to content

Instantly share code, notes, and snippets.

View vgashic's full-sized avatar

Vladimir Gasic vgashic

  • Belgrade, Serbia
View GitHub Profile
@vgashic
vgashic / new_gist_file.sql
Last active March 10, 2016 14:40
All tables row count (SQL Server)
SELECT SUBSTRING(obj.name, 1, 50) AS Table_Name
,ind.rows AS Number_of_Rows
FROM sysobjects AS obj
INNER JOIN sysindexes AS ind ON obj.id = ind.id
WHERE obj.xtype = 'U'
AND ind.indid < 2
AND ind.rows > 0
ORDER BY obj.name
@vgashic
vgashic / formatNumber.js
Created April 9, 2017 01:14
JavaScript format number based on pattern
function formatNumber(numbers, pattern){
//var pattern = '(999) 999-9999';
var patternArray = pattern.split('').map(function(x) { return isNumber(x) ? null : x; });
var resultArray = [];
var pos = 0;
for (var i = 0; i < patternArray.length; i++) {
if (patternArray[i] === null) {
using System;
using System.Globalization;
using System.Threading;
public class Program
{
public static void Main()
{
string s = ",3";
-- SQL Server 2012+
-- Codes for CONVERT function
SELECT n.n
,TRY_CONVERT(VARCHAR(100), GETDATE(), n) AS date_format
FROM (
SELECT TOP 200 ROW_NUMBER() OVER (ORDER BY name) AS n
FROM sys.objects) AS n
WHERE TRY_CONVERT(VARCHAR(100), GETDATE(), n) IS NOT NULL
<?xml version="1.0" encoding="utf-8"?>
<mass_auto_rpg xmlns="urn:gmi:nova:gmi_sr">
<common_parameters>
<is_simulation>true</is_simulation>
</common_parameters>
<rpg_parameters_list>
<rpg_calc>
<rpg_calc_type>rpg_calc_type1</rpg_calc_type>
<id_cont>1</id_cont>
<new_principal>1</new_principal>
using System;
using System.Collections.Generic;
using System.Linq;
public class Program {
public static void Main () {
Product p1 = new Product ();
Console.WriteLine (p1.ID);
Product p2 = new Product ();
var names = new List<String>
{
"Ana",
"Felipe",
"Emillia"
};
foreach (var name in names)
{
Console.WriteLine($"Hello {name}");
@vgashic
vgashic / Program.cs
Last active February 27, 2021 01:49
using System;
using System.Linq;
public class Program
{
public static void Main()
{
}
}
<cube><![CDATA["cube": {
"idOdobrenja": "1000000000075841",
"brojPonude": "10200",
"maticniBrojPP": "25",
"cube": {
"kompanija_id": 16213,
"url": "https://b2bonline.rs/sr/portal/pregled-kompanije/16213/tk-trade-doo-beograd",
"maticni_broj": "20512482",
"pib": "106004413",
"naziv": "TK-TRADE",