Go offline

    USE master
    GO
    ALTER DATABASE YourDatabaseName
    SET OFFLINE WITH ROLLBACK IMMEDIATE
    GO

Go online

    USE master
    GO
    ALTER DATABASE YourDatabaseName
    SET ONLINE
    GO

You need to use `WITH ROLLBACK IMMEDIATE` to boot other conections out with no regards to what or who is is already using it.

Or use `WITH NO_WAIT` to not hang and not kill existing connections. See http://www.blackwasp.co.uk/SQLOffline.aspx for details

I am looking for color space converter from RGB to HSV, specifically for the range 0 to 255 for both color spaces.

Algorithm to convert RGB to HSV and HSV to RGB in range 0-255 for both

I noticed that when using `SimpleXMLElement` on a document that contains those CDATA tags, the content is always `NULL`. How do I fix this?

Also, sorry for spamming about XML here. I have been trying to get an XML based script to work for several hours now...

    &lt;content&gt;&lt;![CDATA[Hello, world!]]&gt;&lt;/content&gt;

I tried the first hit on Google if you search for &quot;SimpleXMLElement cdata&quot;, but that didn&#39;t work.

PHP: How to handle &lt;![CDATA[ with SimpleXMLElement?

How do I force my Database to go Offline, without regard to what or who is already using it?

I tried:

    ALTER DATABASE database-name SET OFFLINE;

But it&#39;s still hanging after 7 min.

I want this because I need to test the scenario.

If it&#39;s even possible?

How to force a SQL Server 2008 database to go Offline

How do I force my Database to go Offline, without regard to what or who is already using it?
I tried:
<pre><code class="hljs language-sql">ALTER DATABASE database-name SET OFFLINE;
</code></pre>
But it's still hanging after 7 min.
I want this because I need to test the scenario.
If it's even possible?

In SQL I (sadly) often have to use &quot;`LIKE`&quot; conditions due to databases that violate nearly every rule of normalization. I can&#39;t change that right now. But that&#39;s irrelevant to the question.

Further, I often use conditions like `WHERE something in (1,1,2,3,5,8,13,21)` for better readability and flexibility of my SQL statements.

Is there any possible way to combine these two things without writing complicated sub-selects?

I want something as easy as `WHERE something LIKE (&#39;bla%&#39;, &#39;%foo%&#39;, &#39;batz%&#39;)` instead of this:

    WHERE something LIKE &#39;bla%&#39;
    OR something LIKE &#39;%foo%&#39;
    OR something LIKE &#39;batz%&#39;

I&#39;m working with SQl Server and Oracle here but I&#39;m interested if this is possible in any RDBMS at all.

Is there a combination of &quot;LIKE&quot; and &quot;IN&quot; in SQL?

What is the difference between a `FULL JOIN` and an `INNER JOIN`?

When I do a `FULL JOIN`, I get 832 records and with an `INNER JOIN`, I get 830 records.

Difference between FULL JOIN &amp; INNER JOIN

I asked PostgreSQL to explain my query. Part of the explanation was:

    table_name --&gt; Materialize

What does materialize do? I&#39;m joining two tables, not views or anything like that. 

SQL explain plan: what is Materialize?

I was hoping to find an easy way to get a parameter list of a stored procedures parameters. If the procedure has 3 paramaters, I want a list like this:


**param1&lt;br&gt;
param2&lt;br&gt;
param3**

It would be best to be able to do this in C# Code, but SQL would suffice as well. Ideas?



Get stored procedure parameters by either C# or SQL?

Say that I have a long, expensive query, packed with conditions, searching a large number of rows. I also have one particular condition, like a company id, that will limit the number of rows that need to be searched considerably, narrowing it down to dozens from hundreds of thousands.

Does it make any difference to MySQL performance whether I do this:

     SELECT * FROM clients WHERE 
           (firstname LIKE :foo OR lastname LIKE :foo OR phone LIKE :foo) AND 
           (firstname LIKE :bar OR lastname LIKE :bar OR phone LIKE :bar) AND 
           company = :ugh

or this:


     SELECT * FROM clients WHERE 
           company = :ugh AND
           (firstname LIKE :foo OR lastname LIKE :foo OR phone LIKE :foo) AND 
           (firstname LIKE :bar OR lastname LIKE :bar OR phone LIKE :bar) 


Does the order of conditions in a WHERE clause affect MySQL performance?


I have &#39;Service&#39; table and the following column description as below &lt;Br/&gt;

 1. Is User Verification Required for service ?
 2. Is User&#39;s Email Activation Required for the service ?
 3. Is User&#39;s Mobile Activation required for the service ?

I Hesitate in naming these columns as below &lt;br/&gt;

    IsVerificationRequired
    IsEmailActivationRequired
    IsMobileActivationRequired

or

    RequireVerification
    RequireEmailActivation
    RequireMobileActivation


**I can&#39;t determined which way is the best  .So, Is one of the above suggested name is the best or is there other better ones ?**


Naming of boolean column in database table

If I have two columns, one with very high cardinality and one with very low cardinality (unique # of values), does it matter in which order I group by?

Here&#39;s an example:

    select 
         dimensionName, 
         dimensionCategory, 
         sum(someFact)
    from SomeFact f
    join SomeDim d on f.dimensionKey = d.dimensionKey
    group by 
        d.dimensionName,  -- large number of unique values
        d.dimensionCategory -- small number of unique values


Are there situations where it matters?

Does the order of columns matter in a group by clause?

I have a website that does inserts into this table below.  I need to do some manual inserts but I wasn&#39;t sure how do pass in the equivalent of DateTime.Now in C#.  

I am running this below from the query editor in SQL server mgmt studio.  Is there any way to pass in the current date time in this query below.


    INSERT INTO [Business]
               ([IsDeleted]
               ,[FirstName]
               ,[LastName]
               ,[LastUpdated]
               ,[LastUpdatedBy])
         VALUES
               (0, &#39;Joe&#39;, &#39;Thomas&#39;, 
               ,&lt;LastUpdated, datetime,&gt;
               ,&lt;LastUpdatedBy, nvarchar(50),&gt;)



How do I do an insert with DATETIME now inside of SQL server mgmt studio

I&#39;m curious what the difference between the token &quot;Trusted_Connection&quot; and &quot;Integrated Security&quot; in SQL Server connection strings (I believe other databases/drivers don&#39;t support these). I understand that they are equivilent.

What is the difference between Trusted_Connection and Integrated Security in a connection string?

I&#39;m trying to make my integration tests more idempotent.  One idea was to execute rollback after every test, the other idea was to some how programatically parse the text, similar to the green check box in Query Analyzer or SSMS.

How do I get SQL Server to parse my command without running it using ADO.NET?

**UPDATE:** 
This is what finally worked as desired:

    using (DbCommand executeOnly = Factory.DbCommand())
    {
        executeOnly.Connection = command.Connection;
        executeOnly.CommandType = CommandType.Text;
        executeOnly.CommandText = &quot;SET NOEXEC ON;&quot; + sqlCommand;
        executeOnly.Connection.Open();
        executeOnly.ExecuteNonQuery();
    }
    //set more properties of command.
    command.Execute();

For inexplicable reasons, &quot;`SET PARSEONLY ON`&quot; only worked in Query Analyzer.  I couldn&#39;t set this on an ADO.NET connection.  It is just as well because `PARSEONLY` seems to catch only syntax errors, which isn&#39;t a common error.  `SET NOEXEC ON` will catch a wider varieties of errors, such as a view that references a missing table or column or a missing parameter in a stored procedure.

How can I programmatically check (parse) the validity of a TSQL statement?

Here&#39;s my user-defined table type...

    CREATE TYPE [dbo].[FooType] AS TABLE(
     [Bar] [INT],
    )

This is what ive had to do in my table-valued function to return the type:

    CREATE FUNCTION [dbo].[GetFoos]
    RETURN @FooTypes TABLE ([Bar] [INT])
    INSERT INTO @FooTypes (1)
    RETURN

Basically, im having to re-declare my type definition in the RETURN statement of the function. Isnt there a way i can simply declare the type in the RETURN statement?

I would have thought this would work:

    CREATE FUNCTION [dbo].[GetFoos]
    RETURN @FooTypes [FooType]
    INSERT INTO @FooTypes (1)
    RETURN

Cannot find any help on MSDN/Google regarding this....anyone?

**EDIT**

I unmarked my answer, and bumping this question - as i am encountering the same scenario 6 months later.

Does anyone have any idea if it&#39;s possible to return a user defined table type from a table valued function? If not, is there a better workaround other than what i have done? (re-declare the type again).



SQL Server 2008 - How do i return a User-Defined Table Type from a Table-Valued Function?

How do I check if an argument in a stored procedure is an empty GUID or not?

Check for empty GUID in SQL

I want to be able to programmatically (in T-SQL) check if a specific linked server already exists for my current server and database (so that if the link doesn&#39;t exist yet, I can create it). I tried stuff like this:

    IF OBJECT_ID(&#39;myserver\devdb_1&#39;) IS NULL
    BEGIN
      PRINT &#39;Does not exist, need to create link&#39;
      EXEC master.dbo.sp_addlinkedserver @server = N&#39;myserver\devdb_1&#39;, 
                                         @srvproduct=N&#39;SQL Server&#39;
    END
    ELSE
      PRINT &#39;Link already exists&#39;

But the OBJECT_ID test always returns null, even if the link already exists.  Any way to do this check in T-SQL, so that the rest of my code can assume the link always exists?

Is there an &quot;IF EXISTS&quot; test for a linked server?

I can see how to turn off row level and page level locking in SQL Server, but I cannot find a way to force SQL Server to use row level locking. Is there a way to force SQL Server to use row level locking and NOT use page level locking?

Is it possible to force row level locking in SQL Server?

How can I export a query result to a .csv file in SQL Server 2008?

Export query result to .csv file in SQL Server 2008

Could someone give me a quick overview of the pros and cons of using the following two statements:

    TRUNCATE TABLE dbo.MyTable

vs

    DELETE FROM dbo.MyTable

It seems like they both do the same thing when all is said and done; but are there must be differences between the two.



Content Type	Original Author	Original Content on Stackoverflow
Question	radbyx	View Question on Stackoverflow
Solution 1 - Sql	abatishchev	View Answer on Stackoverflow
Solution 2 - Sql	Martin Smith	View Answer on Stackoverflow

How to force a SQL Server 2008 database to go Offline

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

PHP: How to handle <![CDATA[ with SimpleXMLElement?

Algorithm to convert RGB to HSV and HSV to RGB in range 0-255 for both

Attributions