    INSERT INTO atable (x,y,z) VALUES ( NULL,NULL,NULL)



If you&#39;re using SSMS (or old school Enterprise Manager) to edit the table directly, press CTRL+0 to add a null.

Can ASP.Net routing (not MVC) be used to serve static files?

Say I want to route

    http://domain.tld/static/picture.jpg

to

    http://domain.tld/a/b/c/picture.jpg

and I want to do it dynamically in the sense that the rewritten URL is computed on the fly. I cannot set up a static route once and for all.

Anyway, I can create a route like this:

    routes.Add(
      &quot;StaticRoute&quot;, new Route(&quot;static/{file}&quot;, new FileRouteHandler())
    );

In the `FileRouteHandler.ProcessRequest` method I can rewrite the path from `/static/picture.jpg` to `/a/b/c/picture.jpg`. I then want to create a handler for static files. ASP.NET uses the `StaticFileHandler` for this purpose. Unfortunately, this class is internal. I have tried to create the handler using reflection and it actually works:

    Assembly assembly = Assembly.GetAssembly(typeof(IHttpHandler));
    Type staticFileHandlerType = assembly.GetType(&quot;System.Web.StaticFileHandler&quot;);
    ConstructorInfo constructorInfo = staticFileHandlerType.GetConstructor(BindingFlags.NonPublic | BindingFlags.Instance, null, Type.EmptyTypes, null);
    return (IHttpHandler) constructorInfo.Invoke(null);

But using internal types doesn&#39;t seem to be the proper solution. Another option is to implement my own `StaticFileHandler`, but doing so properly (supporting HTTP stuff like ranges and etags) is non-trivial.

How should I approach routing of static files in ASP.NET?

Using ASP.NET routing to serve static files

While searching for an implementation of the Barnsley&#39;s Fern fractal I came across a implementation that has .pde extension. Which programming language uses this extension?

[Implementation Page][1]


  [1]: http://www.openprocessing.org/visuals/?visualID=198

Which language uses .pde extension?

In sql server enterprise manager, how do you write an insert statement and pass in `null` values?

how do you insert null values into sql server

<p>In sql server enterprise manager, how do you write an insert statement and pass in <code>null</code> values?</p>


What is the benefit of using **`SET XACT_ABORT ON`** in a stored procedure?

What is the benefit of using &quot;SET XACT_ABORT ON&quot; in a stored procedure?

Is there a way using SQL to list all foreign keys for a given table? I know the table name / schema and I can plug that in.

How to list table foreign keys

In the SQL Server, I am trying to insert values from one table to another by using the below query:

    delete from tblTable1
    
    insert into tblTable1 select * from tblTable1_Link

I am getting the following error:

&gt; Column name or number of supplied values does not match table definition.


I am sure that both the tables have the same structure, same column names and same data types.
 

Column name or number of supplied values does not match table definition

Is there a way I can get a scripting of all tables, procs, and other objects from a database?  I know there&#39;s an option to script the database but it only gave me some sort of top level script, certainly not a script to create all tables, procs, udfs, .etc.

Script entire database SQL-Server

How can I get the table creation date of a MS SQL table using a SQL query?  
I could not see any table physically but I can query that particular table.

SQL Server table creation date query

My SQL Server 2005 doesn&#39;t restore a backup because of active connections. How can I force it?

When restoring a backup, how do I disconnect all active connections?

What is the best column type for a URL field for SQL Server?

Type: VARCHAR or NVARCHAR?

**Length**?


Similar [question for MySQL][1].

  [1]: https://stackoverflow.com/questions/219569/best-database-field-type-for-a-url

What is the best column type for URL?

I&#39;ve heard some voices saying that checking for a returned null value from methods is bad design. I would like to hear some reasons for this.

pseudocode:

    variable x = object.method()
    if (x is null) do something



Is returning null bad design?

&gt; **Possible Duplicate:**  
&gt; https://stackoverflow.com/questions/858080/nullable-types-and-the-ternary-operator-why-wont-this-work


Why doesn&#39;t this work? Seems like valid code.

      string cert = ddCovCert.SelectedValue;
      int? x = (string.IsNullOrEmpty(cert)) ? null: int.Parse(cert);
      Display(x);

How should I code this? The method takes a Nullable&lt;int&gt;. If the drop down has a string selected I need to parse that into an int otherwise I want to pass null to the method.


C# code won&#39;t compile. No implicit conversion between null and int

I have a general question about writing init methods in Objective-C.

I see it everywhere (Apple&#39;s code, books, open source code, etc.) that an init method should check if self = [super init] is not nil before continuing with initialisation.

The default Apple template for an init method is:

    - (id) init
    {
        self = [super init];
        
        if (self != nil)
        {
            // your code here
        }
        
        return self;
    }

Why?

I mean when is init ever going to return nil? If I called init on NSObject and got nil back, then something must be really screwed, right? And in that case, you might as well not even write a program...

Is it really that common that a class&#39; init method may return nil? If so, in what case, and why?

In Objective-C why should I check if self = [super init] is not nil?

In C, there appear to be differences between various values of zero -- `NULL`, `NUL` and `0`.

I know that the ASCII character `&#39;0&#39;` evaluates to `48` or `0x30`.

The `NULL` pointer is usually defined as:

    #define NULL 0

Or

    #define NULL (void *)0

In addition, there is the `NUL` character `&#39;\0&#39;` which seems to evaluate to `0` as well.

Are there times when these three values can not be equal?

Is this also true on 64 bit systems?


What is the difference between NULL, &#39;\0&#39; and 0?

I&#39;m using this code and I&#39;m beyond frustration:

    try {
        $dbh = new PDO(&#39;mysql:dbname=&#39; . DB . &#39;;host=&#39; . HOST, USER, PASS);
        $dbh-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $dbh-&gt;setAttribute(PDO::MYSQL_ATTR_INIT_COMMAND, &quot;SET NAMES &#39;utf8&#39;&quot;);
    }
    catch(PDOException $e)
    {
        ...
    }
    $stmt = $dbh-&gt;prepare(&#39;INSERT INTO table(v1, v2, ...) VALUES(:v1, :v2, ...)&#39;);
    $stmt-&gt;bindParam(&#39;:v1&#39;, PDO::PARAM_NULL); // --&gt; Here&#39;s the problem

`PDO::PARAM_NULL, null, &#39;&#39;,` all of them fail and throw this error:

&gt; **Fatal error**: Cannot pass parameter 2 by reference in /opt/...

Content Type	Original Author	Original Content on Stackoverflow
Question	leora	View Question on Stackoverflow
Solution 1 - Sql	anon	View Answer on Stackoverflow
Solution 2 - Sql	mattmc3	View Answer on Stackoverflow

how do you insert null values into sql server

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Which language uses .pde extension?

Using ASP.NET routing to serve static files

Attributions