ststeiger

        public static string GetFlagDescription(int flag)
        {
            string vcRet = null;

            // Flag: 
            // SUM
            // (
            // 	CASE 
            // 		WHEN PRIVILEGE_TYPE = 'SELECT' THEN 1 

ststeiger

/*
CREATE TABLE dbo.T_SYS_Ref_MimeTypes 
(
	 MIME_UID uniqueidentifier NOT NULL 
	,MIME_Name national character varying(255) NULL 
	,MIME_FileExtension national character varying(25) NULL 
	,MIME_FileExtensionNoPoint national character varying(25) NULL 
	,MIME_Type national character varying(255) NULL 
	,MIME_Details national character varying(255) NULL 

ststeiger

SELECT 
	 MIME_UID
	,MIME_Name
	,MIME_FileExtension
	,MIME_FileExtensionNoPoint
	,MIME_Type
	,MIME_Details
	,MIME_IsAllowed
	,MIME_IsTextFile

ststeiger

/*
CREATE TABLE dbo.T_SYS_Ref_MimeTypes 
(
	 Mime_ID integer NULL 
	,MIME_Name national character varying(255) NULL 
	,MIME_FileExtension national character varying(25) NULL 
	,MIME_FileExtensionNoPoint national character varying(25) NULL 
	,MIME_Type national character varying(255) NULL 
	,MIME_Details national character varying(255) NULL 

ststeiger

fontface (IE9+)
http://caniuse.com/#feat=fontface

http://codingstill.com/2013/01/set-mime-types-for-web-fonts-in-iis/

.eot    application/vnd.ms-fontobject
.ttf    application/octet-stream
.svg    image/svg+xml
.woff   application/font-woff

ststeiger

SELECT 
'
IF EXISTS(
	SELECT rc.*
	FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS rc 

	LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU1 
		ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG  
		AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA 

ststeiger

/*
SELECT * 
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc 
LEFT JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu 
ON tc.CONSTRAINT_NAME = ccu.Constraint_name 
WHERE tc.CONSTRAINT_TYPE = 'Primary Key' 
*/

ststeiger

/*
SELECT *
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
LEFT JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu 
ON tc.CONSTRAINT_NAME = ccu.Constraint_name
WHERE tc.CONSTRAINT_TYPE = 'Primary Key'
*/

ststeiger

mysqld.exe --skip-grant-tables

mysql
UPDATE mysql.user SET Password=PASSWORD('TopSecret') WHERE User='root';
FLUSH PRIVILEGES;


"D:\Programme\mariadb-10.0.12-winx64\bin\mysqld.exe"

ststeiger

DECLARE @bla nvarchar(128) 
SET @bla = N'T_FMS_Reports' 
-- SET @bla = N'T_Users' 

SELECT 
	 FK_TABLE_NAME,
	 FK_COLUMN_NAME  -- RE_RE_UID
	,REFERENCED_COLUMN_NAME, -- RE_UID
	-- 'SELECT * FROM ' + REPLACE(QUOTENAME(@bla), '''', '''''') AS cmd2,