Press Ctrl-Shift-R to refresh the intellisense.

If you prefer, you can use the menu to refresh the cache: 

Edit&gt;Intellisense&gt;Refresh Local Cache

The good thing using the menu, is that you will learn some new Intellisense hot-keys...

[SQL Server Management Studio Intellisense doesn’t work after schema changes][1]


  [1]: http://blog.robertolopes.com/2011/01/17/sql-server-management-studio-intellisense-doesnt-work-after-schema-changes/

You probably did what I always do. I often create a table while connected to the wrong database, or the default database. For me, the default database is &#39;master&#39; so I have a lot of garbage in my master DB :)

Randy

I right-click on the Tables and Select Refresh from the context-sensitive menu (Ctrl-R works too)

All I want is for bool(myInstance) to return False (and for myInstance to evaluate to False when in a conditional like if/or/and. I know how to override &gt;, &lt;, =)

I&#39;ve tried this:

    class test:
        def __bool__(self):
            return False
    
    myInst = test()
    print bool(myInst) #prints &quot;True&quot;
    print myInst.__bool__() #prints &quot;False&quot;

Any suggestions?

(I am using Python 2.6)

overriding bool() for custom class

So I ran into a situation today where some production code was failing precisely because a method performed exactly as [documented in MSDN][1].  Shame on me for not reading the documentation.  However, I&#39;m still scratching my head as to *why* it behaves this way, even if &quot;by design&quot;, since this behavior is exactly opposite what I would have expected (and other, known behaviors) and therefore seems to violate the principle of least surprise.

The &lt;code&gt;All()&lt;/code&gt; method allows you to supply a predicate (such as a lambda expression) to test an &lt;code&gt;IQueryable&lt;/code&gt;, returning a Boolean value that indicates whether all collection members match the test.  So far so good.  Here&#39;s where it gets weird.  &lt;code&gt;All()&lt;/code&gt; also returns &lt;code&gt;true&lt;/code&gt; if the collection is empty.  This seems completely backwards to me, for the following reasons:

 * If the collection is empty, a test like this is, at best, undefined.  If my driveway is empty, I cannot assert that all cars parked there are red.  With this behavior, on an empty driveway all cars parked there are red AND blue AND checkerboard - all of these expressions would return true.
 * For anyone familiar with the SQL notion that NULL != NULL, this is unexpected behavior.
 * The &lt;code&gt;Any()&lt;/code&gt; method behaves as expected, and (correctly) returns false because it does not have any members that match the predicate.

So my question is, why does &lt;code&gt;All()&lt;/code&gt; behave this way?  What problem does it solve?  Does this violate the principle of least surprise?

I tagged this question as .NET 3.5, though the behavior also applies to .NET 4.0 as well.

**EDIT**  Ok, so I grasp the logic aspect to this, as so excellently laid out by Jason and the rest of you.  Admittedly, an empty collection is something of an edge case.  I guess my question is rooted in the struggle that, just because something is *logical* doesn&#39;t mean it necessarily makes *sense* if you&#39;re not in the correct frame of mind.

  [1]: http://msdn.microsoft.com/en-us/library/bb534754.aspx

Why does IQueryable.All() return true on an empty collection?

So if I create a new table in the query editor in SQL Management Studio after hitting refresh on the DB I can see and work with that table. However if I want to run another query referencign that table from withen the query editor it doesn&#39;t reconize that table exists. I&#39;ve tried hitting refresh at the DB level, and the table level but it makes no difference. However if I quit the management studio then reopen it shows up fine.

    USE [DataBaseName]
    GO
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[States](
    	[StateAbbreviation] [nchar](2) NOT NULL,
    	[StateFullName] [nchar](30) NULL,
    GO


So I run that and then run this.

    INSERT INTO States
    SELECT *
    FROM ExistingStatesTable

This fails saying that States doesn&#39;t exist. Also States doesn&#39;t show up in the intelisense. What should I do to 




SQL Management Studio won&#39;t recognize a table exists after scripted create

So if I create a new table in the query editor in SQL Management Studio after hitting refresh on the DB I can see and work with that table. However if I want to run another query referencign that table from withen the query editor it doesn't reconize that table exists. I've tried hitting refresh at the DB level, and the table level but it makes no difference. However if I quit the management studio then reopen it shows up fine.
<pre><code class="hljs language-css">USE [DataBaseName]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[States](
	[StateAbbreviation] [nchar](2) NOT NULL,
	[StateFullName] [nchar](30) NULL,
GO
</code></pre>
So I run that and then run this.
<pre><code class="hljs language-sql">INSERT INTO States
SELECT *
FROM ExistingStatesTable
</code></pre>
This fails saying that States doesn't exist. Also States doesn't show up in the intelisense. What should I do to

Selecting constants without referring to a table is perfectly legal in an SQL statement:

    SELECT 1, 2, 3

The result set that the latter returns is a single row containing the values. I was wondering if there is a way to select multiple rows at once using a constant expression, something kind of:

    SELECT ((1, 2, 3), (4, 5, 6), (7, 8, 9))

I would want something like the above that works and returns a result set with 3 rows and 3 columns.

How to select multiple rows filled with constants?

List columns with indexes in PostgreSQL

Our software currently runs on MySQL. The data of all tenants is stored in the same schema. Since we are using Ruby on Rails we can easily determine which data belongs to which tenant. However there are some companies of course who fear that their data might be compromised, so we are evaluating other solutions.

So far I have seen three options:

* Multi-Database (each tenant gets its own - nearly the same as 1 server per customer)
* Multi-Schema (not available in MySQL, each tenant gets its own schema in a shared database)
* Shared Schema (our current approach, maybe with additional identifying record on each column)

Multi-Schema is my favourite (considering costs). However creating a new account and doing migrations seems to be quite painful, because I would have to iterate over all schemas and change their tables/columns/definitions.

**Q:** Multi-Schema seems to be designed to have slightly different tables for each tenant - I don&#39;t want this. Is there any RDBMS which allows me to use a multi-schema multi-tenant solution, where the table structure is shared between all tenants?

P.S. By multi I mean something like ultra-multi (10.000+ tenants).

How to create a multi-tenant database with shared table structures?

I have a MySQL table with a primary key field that has AUTO_INCREMENT on.
After reading other posts on here I&#39;ve noticed people with the same problem and with varied answers. Some recommend not using this feature, others state it can&#39;t be &#39;fixed&#39;.

I have:

    table: course
    fields: courseID, courseName

Example: number of records in the table: 18. If I delete records 16, 17 and 18 - I would expect the next record entered to have the courseID of 16, however it will be 19 because the last entered courseID was 18.

My SQL knowledge isn&#39;t amazing but is there anyway to refresh or update this count with a query (or a setting in the phpMyAdmin interface)?

This table will relate to others in a database.

---

Given all the advice, I have decided to ignore this &#39;problem&#39;. I will simply delete and add records whilst letting the auto increment do it&#39;s job. I guess it doesn&#39;t really matter what the number is since it&#39;s only being used as a unique identifier and doesn&#39;t have a (as mentioned above) *business* meaning.

For those who I may have confused with my original post: I do not wish to use this field to know how many records I have. I just wanted the database to look neat and have a bit more consistency.


Auto Increment after delete in MySQL

I am searching for a SQL Script that can be used to determine if there is any data (i.e. row count) in any of the tables of a given database. 

The idea is to re-incarnate the database in case there are any rows existing (in any of the database).

The database being spoken of is `Microsoft SQL SERVER`.

Could someone suggest a sample script?



How to fetch the row count for all tables in a SQL SERVER database

In MS SQL-Server, I can do:

   `SELECT ISNULL(Field,&#39;Empty&#39;) from Table`

But in PostgreSQL I get a syntax error. How do I emulate the `ISNULL()` functionality ?

What is the PostgreSQL equivalent for ISNULL()

In SQL Server, what is the difference between a @ table, a # table and a ## table?

SQL Server tables: what is the difference between @, # and ##?

    @Column(name=&quot;open&quot;)

Using sqlserver dialect with hibernate.

    [SchemaUpdate] Unsuccessful: create table auth_session (id numeric(19,0) identity not null, active tinyint null, creation_date datetime not null, last_modified datetime not null, maxidle int null, maxlive int null, open tinyint null, sessionid varchar(255) not null, user_id numeric(19,0) not null, primary key (id), unique (sessionid))
    [SchemaUpdate] Incorrect syntax near the keyword &#39;open&#39;.

I would have expected hibernate to use quoted identifier when creating the table.

Any ideas on how to handle this... other than renaming the field?

How to map an entity field whose name is a reserved word in JPA

Under SQL Server, is there an easy way to filter the output of sp_who2? Say I wanted to just show rows for a certain database, for example.

SQL Server: Filter output of sp_who2

SQL Server Management Studio always inserts a GO command when I create a query using the right click &quot;Script As&quot; menu.  Why?  What does GO actually do?

What is the use of GO in SQL Server Management Studio &amp; Transact SQL?

Is there a way to specify, for example 4 distinct values for a varchar column in MS SQL Server 2008?

For example, I need a column called Frequency (varchar) that only accepts &#39;Daily&#39;, &#39;Weekly&#39;, &#39;Monthly&#39;, &#39;Yearly&#39; as possible values

Is this possible to set within the SQL Server Management Studio when creating the table?

Restrict varchar() column to specific values?

When I have a result set in the grid like:

    SELECT &#39;line 1
    line 2
    line 3&#39;

or

    SELECT &#39;line 1&#39; + CHAR(13) + CHAR(10) + &#39;line 2&#39; + CHAR(13) + CHAR(10) + &#39;line 3&#39;

With embedded CRLF, the display in the grid appears to replace them with spaces (I guess so that they will display all the data).

The problem is that if I am code-generating a script, I cannot simply cut and paste this.  I have to convert the code to open a cursor and print the relevant columns so that I can copy and paste them from the text results.

Is there any simpler workaround to preserve the CRLF in a copy/paste operation from the results grid?

The reason that the grid is helpful is that I am currently generating a number of scripts for the same object in different columns - a bcp out in one column, an xml format file in another, a table create script in another, etc...

SSMS Results to Grid - CRLF not preserved in copy/paste - any better techniques?

In this live SQL Server 2008 (build 10.0.1600) database, there&#39;s an `Events` table, which contains a `text` column named `Details`. (Yes, I realize this should actually be a `varchar(MAX)` column, but whoever set this database up did not do it that way.) 

This column contains very large logs of exceptions and associated JSON data that I&#39;m trying to access through SQL Server Management Studio, but whenever I copy the results from the grid to a text editor, it truncates it at 43679 characters.

I&#39;ve read on various locations on the Internet that you can set your Maximum Characters Retrieved for XML Data in `Tools &gt; Options &gt; Query Results &gt; SQL Server &gt; Results To Grid` to Unlimited, and then perform a query such as this:

    select Convert(xml, Details) from Events
    where EventID = 13920

(Note that the data is column is not XML at all. `CONVERT`ing the column to XML is merely a workaround I found from Googling that someone else has used to get around the limit SSMS has from retrieving data from a `text` or `varchar(MAX)` column.)

However, after setting the option above, running the query, and clicking on the link in the result, I still get the following error:

&gt;Unable to show XML. The following error happened:
Unexpected end of file has occurred. Line 5, position 220160.

&gt;One solution is to increase the number of characters retrieved from the server for XML data. To change this setting, on the Tools menu, click Options.

So, **any idea on how to access this data?** Would converting the column to `varchar(MAX)` fix my woes?

How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?

Using Sql Express Management Studio 2008 GUI (not with coding), how can I make a primary key auto-incremented?

Let me explain: there is a table which has a column named &quot;id&quot; and the items of this column are set to be primary keys. I want to make this column auto-incremented, but how?

Cheers

Content Type	Original Author	Original Content on Stackoverflow
Question	jamone	View Question on Stackoverflow
Solution 1 - Sql	user121301	View Answer on Stackoverflow
Solution 2 - Sql	Roberto	View Answer on Stackoverflow
Solution 3 - Sql	Randy Minder	View Answer on Stackoverflow
Solution 4 - Sql	Terry	View Answer on Stackoverflow

SQL Management Studio won't recognize a table exists after scripted create

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Solution 4 - Sql

Why does IQueryable.All() return true on an empty collection?

overriding bool() for custom class

Attributions