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
-- This can be executed (star comments may occur between name parts). | |
create view [dbo]/*C1*/./*C2*/vTest | |
as | |
select * from sys.tables; | |
GO | |
-- The view is correctly created... | |
select * from dbo.vTest; | |
select * from dbo/*C*/./*C*/vTest; | |
GO | |
-- But... this is what is generated :-). |
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
select [ ]=1, [Val] = '0', Type = cast(sql_variant_property(0,'BaseType') as varchar(20)), [Precision]=cast(sql_variant_property(0,'Precision') as varchar(20)), [Scale]= cast(sql_variant_property(0,'Scale') as varchar(20)), [MaxLength] = cast(sql_variant_property(0,'MaxLength') as varchar(20)) | |
union | |
select 2, '35', cast(sql_variant_property(35,'BaseType') as varchar(20)), cast(sql_variant_property(35,'Precision') as varchar(20)), cast(sql_variant_property(35,'Scale') as varchar(20)), [MaxLength] = cast(sql_variant_property(35,'MaxLength') as varchar(20)) | |
union | |
select 3, '''str''', cast(sql_variant_property('str','BaseType') as varchar(20)), cast(sql_variant_property('str','Precision') as varchar(20)), cast(sql_variant_property('str','Scale') as varchar(20)), [MaxLength] = cast(sql_variant_property('str','MaxLength') as varchar(20)) | |
union | |
select 4, 'N''str''', cast(sql_variant_property(N'str','BaseType') as varchar(20)), cast(sql_variant_property(N'str','Precision') as varchar(20)), cast(sql_variant_proper |
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
-- Then statement of a if can be terminated by ; | |
if 0 = 1 print 'boo'; | |
else print 'murf'; | |
-- ; can appear after a end. Any number of times (empty statements). | |
if 0 = 1 | |
begin | |
print 'boo'; | |
end; | |
else |
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
-- max, output, readonly are NOT reserved keywords. | |
-- Type names are not reserved: following column names are legal. | |
create table tTestLMax( max int, output int, readonly int, int int, datetime int ); | |
select max, output, readonly, int, datetime from tTestLMax; | |
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
<html> | |
<head> | |
<script> | |
$ = ~[];$={___:++$,$$$$:(![]+"")[$],__$: ++$,$_$_:(![]+"")[$],_$_:++$,$_$$: | |
({} + "")[$],$$_$:($[$] + "")[$],_$$: ++$,$$$_:(!"" + "")[$],$__:++$,$_$: | |
++$,$$__:({}+"")[$],$$_:++$,$$$:++$,$___: ++$,$__$:++$,$__$__$:(++$[$]+"") | |
[0]};$.$_=( $.$_ = $ + "" )[$.$_$]+($._$=$.$_[$.__$])+( $.$$ =($.$+"") | |
[$.__$])+(!$ +"") | |
[$._$$]+( $.__=$.$_[$.$$_])+($.$=(!""+"")[$.__$]) + ($._= | |
(!"" +"" )[$._$_]) + $.$_[$.$_$]+$.__+$._$+ $.$;$.$$=$.$+(!""+"" )[$._$$] |
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
if OBJECT_ID( 'EG.TestWithTable' ) is not null drop procedure EG.TestWithTable; | |
if TYPE_ID( 'EG.TestWithTableData' ) is not null drop type EG.TestWithTableData; | |
GO | |
create type EG.TestWithTableData as table | |
( | |
Value int, | |
Name nvarchar(3), | |
Doc xml, | |
Point Geometry, | |
CName as Name + ' (' + cast(Value as nvarchar) + ')', |
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
[TestFixture] | |
public class CommandDemoTests | |
{ | |
[Test] | |
public async Task command_pattern_just_work_with_poco_result() | |
{ | |
var cmd = new CmdDemo() | |
{ | |
ActorId = 878, | |
CompanyName = "Invenietis", |
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
function Animal( objectName ) { | |
this._name = objectName; | |
} | |
Animal.prototype._name = "Animal’s prototype."; | |
Animal.prototype.makeNoise = function () { console.log( this._name + ' is silent.' ); }; | |
Animal.prototype.run = function () { console.log( this._name + ' runs.' ); }; | |
var a = new Animal( "Basic Animal." ); | |
a.makeNoise(); |
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
function memorize( f ) { return f; } | |
function MyObject( name ) { | |
this.name = name; | |
} | |
MyObject.prototype.show = function( x, y ) { | |
console.log( this.name, x, y ); | |
} | |
var o1 = new MyObject( 'o1' ); | |
var o2 = new MyObject( 'o2' ); |
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
using System; | |
using System.Runtime.CompilerServices; | |
public ref struct ROSpanMatcher | |
{ | |
public ReadOnlySpan<char> Head; | |
public int _le; | |
public ROSpanMatcher( ReadOnlySpan<char> text ) | |
{ | |
Head = text; |
OlderNewer