**StartsWith**

    a) left(@edition, 15) = &#39;Express Edition&#39;
    b) charindex(&#39;Express Edition&#39;, @edition) = 1

**Contains**
    
    charindex(&#39;Express Edition&#39;, @edition) &gt;= 1

**Examples**

[`left`][1] function

    set @isExpress = case when left(@edition, 15) = &#39;Express Edition&#39; then 1 else 0 end

[`iif`][2] function (starting with SQL Server 2012)

    set @isExpress = iif(left(@edition, 15) = &#39;Express Edition&#39;, 1, 0);

[`charindex`][3] function

    set @isExpress = iif(charindex(&#39;Express Edition&#39;, @edition) = 1, 1, 0);


  [1]: https://docs.microsoft.com/en-us/sql/t-sql/functions/left-transact-sql
  [2]: https://docs.microsoft.com/en-us/sql/t-sql/functions/logical-functions-iif-transact-sql
  [3]: https://docs.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql

It seems like what you want is http://msdn.microsoft.com/en-us/library/ms186323.aspx.

In your example it would be (starts with):

    set @isExpress = (CharIndex(&#39;Express Edition&#39;, @edition) = 1)

Or contains

    set @isExpress = (CharIndex(&#39;Express Edition&#39;, @edition) &gt;= 1)

I would use

    like &#39;Express Edition%&#39;

Example:

    DECLARE @edition varchar(50); 
    set @edition = cast((select SERVERPROPERTY (&#39;edition&#39;)) as varchar)
    
    DECLARE @isExpress bit
    if @edition like &#39;Express Edition%&#39;
        set @isExpress = 1;
    else
        set @isExpress = 0;
    
    print @isExpress

I am working on a Universal app &amp; would like to access the values stored in app-info.plist file in my code.

Reason: I instantiate a UIViewController dynamically from a storyboard using:

    UIStoryboard* storyboard = [UIStoryboard storyboardWithName:@&quot;MainStoryboard_iPhone&quot; bundle:nil];
    self = [storyboard instantiateViewControllerWithIdentifier:@&quot;ExampleViewController&quot;];

Now, having the storyboard name @&quot;MainStoryboard_iPhone&quot; above is ugly. 

I want to do something like:

    UIStoryboard* storyboard = [UIStoryboard storyboardWithName:appInfo.mainStoryboardBaseNamePhone bundle:nil];
    self = [storyboard instantiateViewControllerWithIdentifier:@&quot;ExampleViewController&quot;];

where appInfo can perhaps be an NSDictionary of all values in app-info.plist


iOS: Access app-info.plist variables in code

Based on [this][1]

&gt; A positional argument is a name that is not followed by an equal sign
&gt; (=) and default value.
&gt; 
&gt; A keyword argument is followed by an equal sign and an expression that
&gt; gives its default value.



    def rectangleArea(width, height):
        return width * height
    
    print rectangleArea(width=1, height=2)

**Question**&gt; I assume that both `width` and `height` are positional arguments. Then why can we also call it with the keyword argument syntax?


  [1]: http://infohost.nmt.edu/tcc/help/pubs/python/web/def.html


Positional argument v.s. keyword argument

I am trying to detect if the server is running Express Edition.

I have the following t sql.

	DECLARE @edition varchar(50); 
	set @edition = cast((select SERVERPROPERTY (&#39;edition&#39;)) as varchar)
	
	print @edition

In my instance, `@edition = Express Edition (64-bit)`

How can I do the following? (C# inspired).

    DECLARE @isExpress bit;
    set @isExpress = @edition.StartsWith(&#39;Express Edition&#39;);





Is there StartsWith or Contains in t sql with variables?

I am trying to detect if the server is running Express Edition.
I have the following t sql.
<pre><code class="hljs language-sql">DECLARE @edition varchar(50); 
set @edition = cast((select SERVERPROPERTY ('edition')) as varchar)

print @edition
</code></pre>
In my instance, <code>@edition = Express Edition (64-bit)</code>
How can I do the following? (C# inspired).
<pre><code class="hljs language-scss">DECLARE @isExpress bit;
set @isExpress = @edition.StartsWith('Express Edition');
</code></pre>

I need to sort a PostgreSQL table ascending by a date/time field, e.g. `last_updated`.

But that field is allowed to be empty or null and I want records with null in `last_updated` come *before* non-null `last_updated`.  
Is this possible?

    order by last_updated asc  -- and null last_updated records first ??

Sort by column ASC, but NULL values first?

We have an old SQL table that was used by SQL Server 2000 for close to 10 years.

In it, our employee badge numbers are stored as `char(6)` from `000001` to `999999`.

I am writing a web application now, and I need to store employee badge numbers.

In my new table, I could take the short cut and copy the old table, but I am hoping for better data transfer, smaller size, etc, by simply storing the `int` values from `1` to `999999`.

In C#, I can quickly format an `int` value for the badge number using

    public static string GetBadgeString(int badgeNum) {
      return string.Format(&quot;{0:000000}&quot;, badgeNum);
      // alternate
      // return string.Format(&quot;{0:d6}&quot;, badgeNum);
    }

How would I modify this simple SQL query to format the returned value as well?

    SELECT EmployeeID
    FROM dbo.RequestItems
    WHERE ID=0

If `EmployeeID` is 7135, this query should return `007135`.

Formatting Numbers by padding with leading zeros in SQL Server

I have two columns: 
    
    job_start                         job_end
    2011-11-02 12:20:37.247           2011-11-02 13:35:14.613

How would it be possible using T-SQL to find the raw amount of time that has passed between when the job started and when the job ended?

I tried this:

    select    (job_end - job_start) from tableA

but ended up with this:

    1900-01-01 01:14:37.367

How to compare two dates to find time difference in SQL Server 2005, date manipulation

I have a column in my database called &quot;dob&quot; of type datetime. How do I select all the rows after a specific DoB in SQL Server 2005?

List rows after specific date

What are the list of statements that need to be committed before further action on the table in order to avoid a lock? I am not talking about full transactions with multiple statements and transaction integrity; instead I am referring to single statements.

I know insert should be committed but truncate has an autocommit. What is the full list of statements that need to be committed?

Need to be committed (starter list):

    UPDATE
    INSERT
    DELETE

oracle - what statements need to be committed?

Given a `datetime`, is there a way we can know it happens to be a `Saturday` or `Sunday`.

Any ideas and suggestions are appreciated!

How to check if datetime happens to be Saturday or Sunday in SQL Server 2008

Is it possible to list information about the files (MDF/LDF) of all databases on an SQL Server? 

I&#39;d like to get a list showing which database is using what files on the local disk.

What I tried:

* `exec sp_databases` all databases
* `select * from sys.databases` shows a lot of information about each database - but unfortunately it doesn&#39;t show the files used by each database.
* `select * from sys.database_files` shows the mdf/ldf files of the `master` database - but not the other databases

Listing information about all database files in SQL Server

How can I find all columns of a certain type (for example `NTEXT`) in all tables in a SQL Server database?

I am looking for a SQL query.

Find all columns of a certain type in all tables in a SQL Server database

After installing SQL Server 2008, I cannot find the `SQL Server Configuration Manager` in `Start / SQL Server 2008 / Configuration Tools` menu. 

What should I do to install this tool?

SQL Server Configuration Manager not found

The definition says:

&gt;When SET ANSI_NULLS is ON, a SELECT statement that uses WHERE column_name = NULL returns zero rows even if there are null values in column_name. A SELECT statement that uses WHERE column_name &lt;&gt; NULL returns zero rows even if there are non-null values in column_name.

Does this mean that no nulls will be included in this query?

    SELECT Region
    FROM employees
    WHERE Region = @region

Or do `ANSI_NULL`s concern only queries like this one (where the `WHERE` includes the specific word `NULL`)?

    SELECT Region
    FROM employees
    WHERE Region = NULL


In SQL Server, what does &quot;SET ANSI_NULLS ON&quot; mean?

As demonstrated by previous Stack Overflow questions ([https://stackoverflow.com/questions/2425550/transactionscope-and-connection-pooling][1] and [https://stackoverflow.com/questions/3759897/how-does-sqlconnection-manage-isolationlevel][2]), the transaction isolation level leaks across pooled connections with SQL Server and ADO.NET (also System.Transactions and EF, because they build on top of ADO.NET).

This means, that the following dangerous sequence of events can happen in any application:

 1. A request happens which requires an explicit transaction to ensure data consistency
 2. Any other request comes in which does not use an explicit transaction because it is only doing uncritical reads. This request will now execute as serializable, **potentially causing dangerous blocking and deadlocks**

The question: **What is the best way to prevent this scenario?** Is it really required to use explicit transactions everywhere now?

Here is a self-contained repro. You will see that the third query will have inherited the Serializable level from the second query.

    class Program
    {
        static void Main(string[] args)
        {
            RunTest(null);
            RunTest(IsolationLevel.Serializable);
            RunTest(null);
            Console.ReadKey();
        }

        static void RunTest(IsolationLevel? isolationLevel)
        {
            using (var tran = isolationLevel == null ? null : new TransactionScope(0, new TransactionOptions() { IsolationLevel = isolationLevel.Value }))
            using (var conn = new SqlConnection(&quot;Data Source=(local); Integrated Security=true; Initial Catalog=master;&quot;))
            {
                conn.Open();

                var cmd = new SqlCommand(@&quot;
    select         
            case transaction_isolation_level 
                WHEN 0 THEN &#39;Unspecified&#39; 
                WHEN 1 THEN &#39;ReadUncommitted&#39; 
                WHEN 2 THEN &#39;ReadCommitted&#39; 
                WHEN 3 THEN &#39;RepeatableRead&#39; 
                WHEN 4 THEN &#39;Serializable&#39; 
                WHEN 5 THEN &#39;Snapshot&#39; 
            end as lvl, @@SPID
         from sys.dm_exec_sessions 
        where session_id = @@SPID&quot;, conn);

                using (var reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        Console.WriteLine(&quot;Isolation Level = &quot; + reader.GetValue(0) + &quot;, SPID = &quot; + reader.GetValue(1));
                    }
                }

                if (tran != null) tran.Complete();
            }
        }
    }

Output:

    Isolation Level = ReadCommitted, SPID = 51
    Isolation Level = Serializable, SPID = 51
    Isolation Level = Serializable, SPID = 51 //leaked!


  [1]: https://stackoverflow.com/questions/2425550/transactionscope-and-connection-pooling
  [2]: https://stackoverflow.com/questions/3759897/how-does-sqlconnection-manage-isolationlevel

SQL Server: Isolation level leaks across pooled connections

I need to select a field called ProgramID from a table and if the ProgramID is NULL then I need to select the value in the InterimProgramID from the same table and alias it as ProgramID.

How can I make a conditional SELECT statement to do this?

Content Type	Original Author	Original Content on Stackoverflow
Question	Valamas	View Question on Stackoverflow
Solution 1 - Sql	Kirill Polishchuk	View Answer on Stackoverflow
Solution 2 - Sql	Gary.S	View Answer on Stackoverflow
Solution 3 - Sql	Thomas Koelle	View Answer on Stackoverflow

Is there StartsWith or Contains in t sql with variables?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Positional argument v.s. keyword argument

iOS: Access app-info.plist variables in code

Attributions