jbubriski

public void NonQuery()
{
    var connectionString = ConfigurationManager.ConnectionStrings["Default"].ConnectionString;
    var sqlCommandText = "UPDATE People SET Name = 'John'";
    
    using (var sqlConnection = new SqlConnection(connectionString))
    using (var sqlCommand = new SqlCommand(sqlCommandText, sqlConnection))
    {
        sqlCommand.Connection.Open();
    

jbubriski

SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + o.Name
FROM sys.Objects o
INNER JOIN sys.Schemas s on o.schema_id = s.schema_id
WHERE s.Name = 'your_schema_name'
And (o.Type = 'U' Or o.Type = 'P' Or o.Type = 'V')

jbubriski

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Web.Routing;
using System.Web.Security;
using Recaptcha;
 
namespace Controllers

jbubriski

(function() {
  $(function() {
    var dataRequested = false;
    var $form = $('#form');

    $form.on('submit', function() {
      if (!dataRequested) {
        callMethodToGetAjaxData();

        return false;

jbubriski

<#@ template debug="True" hostspecific="True" language="C#" #>
<#@ output extension=".cs" #>
<#@ Assembly Name="System.Configuration" #>
<#@ assembly name="System.Core" #>
<#@ Assembly Name="System.Collections" #>
<#@ Assembly Name="System.Data" #>
<#@ Assembly Name="System.Linq" #>
<#@ Assembly Name="System.Xml" #>
<#@ Assembly Name="System.Xml.Linq" #>
<#@ assembly name="Microsoft.SqlServer.ConnectionInfo" #>

jbubriski

public class LoadCsvDataIntoSqlServer
{
    // Queries for truncating the tables and copying data
    protected string _truncateTempTableCommandText = @"TempTable";
    protected string _truncateLiveTableCommandText = @"LiveTable";

    protected string  _copyDataCommandText = @"
    INSERT INTO LiveTable (FirstName, LastName)
    SELECT FirstName, LastName
    FROM TempTable";

jbubriski

public class Example
{
    private static int GetRandomNumber(int max)
    {
        var bytes = new byte[3];
        var cr = new System.Security.Cryptography.RNGCryptoServiceProvider();

        cr.GetBytes(bytes);

        // Get 3 random digits as a string, and parse it as an int, then keep it between 0 and the max

jbubriski

Hello there! This is a sample post for gist.io, a super-lightweight writing soapbox for hackers.

Now look up. Further. Above the post title. See that grey text with the gist ID?

Now back to me. That grey text is a link! Open that sucker in a new tab to see the source for this post. Also, I'm on a horse.

This is a major heading

If you peek at it with a web inspector, you'll see that it is a second-level heading. You can use first level headings, but they'll look just like the second level ones, and the gods of the HTML5 outlining algorithm will frown upon you.

jbubriski

ALTER DATABASE mydatabase SET RECOVERY SIMPLE
DBCC SHRINKFILE (mydatabase_Log, 1)

jbubriski

DROP TABLE #f 
GO 
CREATE TABLE #f (name sysname, fileid int, filename sysname, filegroup sysname null, 
size sysname, maxsize sysname, growth sysname, usage sysname) 
GO 
EXEC sp_MSforeachdb 'DECLARE @s VARCHAR(8000);
USE [?]; 
TRUNCATE TABLE #f;
INSERT #f (name, fileid, filename, filegroup, size, maxsize, growth, usage ) 
EXEC sp_helpfile