AlexArchive

.landing-page > section {
  margin-bottom: 80px;
}
.section-header {
  margin: 50px 0;
}

.section-projects .icon-container {
    margin: 0 auto;
    width: 100px;

AlexArchive

            var lookup = new Dictionary<int, Artist>();
            IEnumerable<Artist> foo =
                connection.Query<Artist, Record, Artist>(
                "SELECT * FROM dbo.Artists INNER JOIN dbo.Records ON dbo.Records.artistId = dbo.Artists.id",
                (a, r) =>
                {
                    Artist artist;
                    if (!lookup.TryGetValue(a.Id, out artist))
                    {
                        lookup.Add(a.Id, artist = a);

AlexArchive

USE COMPANY;

SELECT * FROM
	(SELECT 
		*, 
		ROW_NUMBER() OVER (ORDER BY AnnouncementDate) AS [Index]
	 FROM dbo.Announcements) AS AnnouncementsWithIndex
WHERE [Index] BETWEEN 1 AND 3

AlexArchive

USE Radio1;

DROP TABLE dbo.Records;
DROP TABLE dbo.Artists;

-- Create table dbo.Artists
CREATE TABLE dbo.Artists
(
	id          INT            NOT NULL IDENTITY,
	firstname   NVARCHAR(20)   NOT NULL,

AlexArchive

.landing-page > section {
  margin-bottom: 80px;
}
.section-header {
  margin: 50px 0;
}

.section-features .icon-container {
    margin: 0 auto;
    width: 100px;

AlexArchive

DROP TABLE Announcements

CREATE TABLE Announcements (
	AnnouncementId   INT			NOT NULL PRIMARY KEY IDENTITY(1,1),
	Title		     NVARCHAR(250)  NOT NULL,
	Body			 NVARCHAR(4000) NOT NULL,
	AnnouncementDate DATE			NOT NULL
);

INSERT INTO Announcements

AlexArchive

DROP TABLE Announcements

CREATE TABLE Announcements (
	AnnouncementId   INT			NOT NULL PRIMARY KEY IDENTITY(1,1),
	Title		     NVARCHAR(250)  NOT NULL,
	Body			 NVARCHAR(4000) NOT NULL,
	AnnouncementDate DATE			NOT NULL
);

INSERT INTO Announcements

AlexArchive

<div class="row">
  <div class="col-sm-offset-2 col-sm-8">
    <h2>Welcome to TestStack</h2>

    <p>Echo Park Neutra narwhal, master cleanse Banksy Pitchfork listicle
    hashtag occupy. 8-bit Banksy PBR&B cred, 90's next level post-ironic Echo
    Park cronut bespoke direct trade pickled scenester. Sustainable fap
    meggings, roof party twee wayfarers banh mi quinoa ugh four loko semiotics
    butcher 3 wolf moon Brooklyn typewriter.</p>
  </div>

AlexArchive

(function($) {

    var pluginName = 'ago';

    $.fn[pluginName] = function() {
        return this.each(function() {
            var element = $(this);
            updateTitle(element);
        });
    };

AlexArchive

1. Installing Visual Studio Community Edition
2. Hello, World
3. Variables
4. Primitive types
5. Arithmetic
6. If
7. Switch
8. Conditional operator
9. Random numbers
10. Methods