Skip to content

Instantly share code, notes, and snippets.

Avatar

Jeremy Long jeremylong

  • Oak Hill, VA
View GitHub Profile
View keybase.verification
### Keybase proof
I hereby claim:
* I am jeremylong on github.
* I am ctxt (https://keybase.io/ctxt) on keybase.
* I have a public key ASAql61mIWSSolrhG_4ZfciMvbefNKfoq71kw-d43wbw6Qo
To claim this, I am signing this object:
@jeremylong
jeremylong / pom.xml
Last active Feb 26, 2016
dependency-check-maven-mysql
View pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.owasp</groupId>
<artifactId>dependency-check-maven-mysql</artifactId>
<version>1.3.1</version>
<packaging>maven-plugin</packaging>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.7</maven.compiler.source>
@jeremylong
jeremylong / bind_table_type.cs
Created Jun 11, 2013
Binding a user defined table type for use within an IN clause.
View bind_table_type.cs
DataTable dt = new DataTable();
dt.Columns.Add("id", typeof(int));
var row = dt.NewRow();
row["id"] = 1;
dt.Rows.Add(row);
row = dt.NewRow();
row["id"] = 2;
dt.Rows.Add(row);
SqlConnection conn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=test");
conn.Open();
View table_type_parameter.sql
CREATE TYPE [dbo].[PrimaryKeyINT] AS TABLE(
[id] [int]
)
GO
CREATE PROCEDURE [dbo].[usp_GetDetails]
(
@inClause PrimaryKeyINT READONLY
)
You can’t perform that action at this time.