This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
USE YOUR_DATABASE_NAME | |
-- Disable all referential integrity constraints | |
EXEC sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' | |
GO | |
-- Drop all PKs and FKs | |
declare @sql nvarchar(max) | |
SELECT @sql = STUFF((SELECT '; ' + 'ALTER TABLE ' + Table_Name +' drop constraint ' + Constraint_Name from Information_Schema.CONSTRAINT_TABLE_USAGE ORDER BY Constraint_Name FOR XML PATH('')),1,1,'') | |
EXECUTE (@sql) | |
GO |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
^(http:\/\/www\.|https:\/\/www\.|http:\/\/|https:\/\/)?[a-z0-9]+([\-\.]{1}[a-z0-9]+)*\.[a-z]{2,20}(:[0-9]{1,5})?(\/.*)?$ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
javascript:var h = document.getElementsByClassName("post_actions");var i = 0;function del_wall(){var fn_str = h[i].getElementsByTagName("div")[0].onclick.toString();var fn_arr_1 = fn_str.split("{");var fn_arr_2 = fn_arr_1[1].split(";");eval(fn_arr_2[0]);if(i == h.length){clearInterval(int_id)}else{i++}};var int_id=setInterval(del_wall,1000); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/// <summary> | |
/// Разбивает массив строк на части, заданного размера. Возращает список частей | |
/// </summary> | |
/// <param name="array">Массив для разбиения на части</param> | |
/// <param name="chunkSize">Размер части. Часть может быть меньше, если остаток массива меньше (краешек)</param> | |
/// <returns></returns> | |
static public List<string[]> MakeChunksFromArray(string[] array, int chunkSize) // todo можно сделать generic | |
{ | |
var chunks = new List<string[]>(); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public static string[] RandomStringArray(int size) | |
{ | |
var result = new string[size]; | |
Random random = new Random(); | |
char ch; | |
for (int i = 0; i < size; i++) | |
{ | |
//Генерируем число являющееся латинским символом в юникоде | |
ch = Convert.ToChar(Convert.ToInt32(Math.Floor(26 * random.NextDouble() + 65))); | |
//Конструируем строку со случайно сгенерированными символами |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
window.onload = function() { | |
// Parse the URL | |
function getParameterByName(name) { | |
var name = name.replace(/[\[]/, "\\[").replace(/[\]]/, "\\]"); | |
var regex = new RegExp("[\\?&]" + name + "=([^&#]*)"); | |
var results = regex.exec(location.search); | |
return results === null ? "" : decodeURIComponent(results[1].replace(/\+/g, " ")); | |
} | |
// Give the URL parameters variable names | |
var source = getParameterByName('utm_source'); |