Skip to content

Instantly share code, notes, and snippets.

kohav

Block or report user

Report or block kohav

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View gist:d797dc454b7d69cff32f0ddb4e926e05
CREATE TABLE [dbo].[tTMP](
[Id] [int] NOT NULL,
[IdResp] [int] NULL,
[IdBranch] [int] NULL,
[IdPost] [int] NULL,
[CountWorks] [int] NULL,
[CountSub] [int] NULL,
CONSTRAINT [PK_tTmp] PRIMARY KEY CLUSTERED
( [Id] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]
@kohav
kohav / gist:b3233c63507323e616158e7d1ddc637f
Last active Apr 28, 2017
MS Sql Server / using row_number()over & reversal of result set.
View gist:b3233c63507323e616158e7d1ddc637f
/*using row_number()over*/
select Id_Otdel,
firstName,
row_number()over(partition by Id_Otdel order by firstName) rn
from d_Sotr
where Id_Otdel in (11, 12, 21)
/*with reversal of result set*/
select max(case when Id_Otdel=11
then firstName else null end) as analysts,
View gist:86697c482c578e6a1f99b2cefc824301
учись - главное знать все из запросов
<SELECT statement> ::=
[ WITH { [ XMLNAMESPACES ,] [ <common_table_expression> [,...n] ] } ]
<query_expression>
[ ORDER BY { order_by_expression | column_position [ ASC | DESC ] }
[ ,...n ] ]
[ <FOR Clause>]
[ OPTION ( <query_hint> [ ,...n ] ) ]
<query_expression> ::=
{ <query_specification> | ( <query_expression> ) }
View gist:f9dec26c721c3ed789a5393eac441b3d
<?php if ( have_posts() ) : query_posts('p=1');
while (have_posts()) {
the_post();
the_content();
}endif; wp_reset_query(); ?>
@kohav
kohav / gist:7547ab6170d82f8f8f8cb12a7865f23c
Created Apr 26, 2017
#Ссылки из видео про полезные ништяки ништяки от ХаудиХо:
View gist:7547ab6170d82f8f8f8cb12a7865f23c
1) http://svgporn.com
2) http://www.dummytextgenerator.com
3) http://www.behindthename.com
4) https://nick-name.ru/generate/
5) https://www.hipsterlogogenerator.com/
6) http://compressjpeg.com/
7) http://revaxarts-themes.com/documenter/
8) http://easings.net/
9) https://www.toptal.com/designers/subt...
You can’t perform that action at this time.