&lt;kbd&gt;Ctrl&lt;/kbd&gt; + &lt;kbd&gt;Shift&lt;/kbd&gt; + &lt;kbd&gt;R&lt;/kbd&gt; will refresh Intellisense.

If you want to do it via the menus, it&#39;s:

    Edit / IntelliSense / Refresh Local Cache

Using the keyboard, it&#39;s:
&lt;kbd&gt;CTRL&lt;/kbd&gt;-&lt;kbd&gt;SHIFT&lt;/kbd&gt;-&lt;kbd&gt;R&lt;/kbd&gt;


I am trying to convert a Go struct to JSON using the `json` package but all I get is `{}`. I am certain it is something totally obvious but I don&#39;t see it.


    package main

    import (
        &quot;fmt&quot;
        &quot;encoding/json&quot;
    )

    type User struct {
        name string
    }

    func main() {
        user := &amp;User{name:&quot;Frank&quot;}
        b, err := json.Marshal(user)
        if err != nil {
            fmt.Printf(&quot;Error: %s&quot;, err)
            return;
        }
        fmt.Println(string(b))
    }

Then when I try to run it I get this:

    $ 6g test.go &amp;&amp; 6l -o test test.6 &amp;&amp; ./test 
    {}


Converting Go struct to JSON

How can I make jQuery do something if my screen width is less than 960 pixels? The code below always fires the 2nd alert, regardless of my window size: 

    if (screen.width &lt; 960) {
        alert(&#39;Less than 960&#39;);
    }
    else {

        alert(&#39;More than 960&#39;);
    }

Do something if screen width is less than 960 px

&gt; **Possible Duplicate:**  
&gt; [Lost the IntelliSense](https://stackoverflow.com/questions/7055911/lost-the-intellisense)  
&gt; [SQL Server 2008 Intellisense problem](https://stackoverflow.com/questions/7215211/sql-server-2008-intellisense-problem)  

&lt;!-- End of automatically inserted text --&gt;

I&#39;m new to SQL Server, so this is probably an easy fix.  In SQL Server 2008 R2, I&#39;ve just imported a new data table and/or renamed fields in an existing table (it happens either way).  When I start to write some SQL, the intellisense doesn&#39;t recognize the new field names and starts underlining everything.

The only fix I&#39;ve found is to close and reopen SQL Server, but I&#39;m sure there&#39;s a simpler solution out there. Suggestions please?

(This isn&#39;t a serious problem, just a pet peeve).

SQL Server. How to refresh the intellisense?

> Possible Duplicate: 
> <a href="https://stackoverflow.com/questions/7055911/lost-the-intellisense" target="_blank" rel="noopener noreferrer">Lost the IntelliSense</a> 
> <a href="https://stackoverflow.com/questions/7215211/sql-server-2008-intellisense-problem" target="_blank" rel="noopener noreferrer">SQL Server 2008 Intellisense problem</a>

I'm new to SQL Server, so this is probably an easy fix. In SQL Server 2008 R2, I've just imported a new data table and/or renamed fields in an existing table (it happens either way). When I start to write some SQL, the intellisense doesn't recognize the new field names and starts underlining everything.
The only fix I've found is to close and reopen SQL Server, but I'm sure there's a simpler solution out there. Suggestions please?
(This isn't a serious problem, just a pet peeve).

While using the `using() {}` (sic) blocks as shown below, and assuming that `cmd1` does not live beyond the scope of the first `using() {}` block, why should the second block throw an exception with the message 

&gt; The SqlParameter is already contained by another SqlParameterCollection

Does it mean that resources and/or handles - including the parameters (`SqlParameterCollection`) - attached to `cmd1` are not released when its destroyed at the end of the block?

    using (var conn = new SqlConnection(&quot;Data Source=.;Initial Catalog=Test;Integrated Security=True&quot;))
    {
        var parameters = new SqlParameter[] { new SqlParameter(&quot;@ProductId&quot;, SqlDbType.Int ) };

        using(var cmd1 = new SqlCommand(&quot;SELECT ProductName FROM Products WHERE ProductId = @ProductId&quot;))
        {
            foreach (var parameter in parameters)
            {
                cmd1.Parameters.Add(parameter);                
            }
            // cmd1.Parameters.Clear(); // uncomment to save your skin!
        }

        using (var cmd2 = new SqlCommand(&quot;SELECT Review FROM ProductReviews WHERE ProductId = @ProductId&quot;))
        {
            foreach (var parameter in parameters)
            {
                cmd2.Parameters.Add(parameter);
            }
        }
    }


**NOTE:** Doing cmd1.Parameters.Clear() just before the last brace of the first **using() {}** block will save you from the exception (and possible embarrassment).

If you need to reproduce you can use the following scripts to create the objects:

    CREATE TABLE Products
    (
        ProductId int IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
        ProductName nvarchar(32) NOT NULL
    )
    GO

    CREATE TABLE ProductReviews
    (
        ReviewId int IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
        ProductId int NOT NULL,
        Review nvarchar(128) NOT NULL
    )
    GO


The SqlParameter is already contained by another SqlParameterCollection - Does using() {} cheat?

While researching the use of [Table Hints][1], I came across these two questions:

 - [Which lock hints should I use (T-SQL)?][2]

 - [What effect does HOLDLOCK have on UPDLOCK?][3]
 
Answers to both questions say that when using `(UPDLOCK, HOLDLOCK)`, other processes will not be able to read data on that table, but I didn&#39;t see this.  To test, I created a table and started up two SSMS windows.  From the first window, I ran a transaction that selected from the table using various table hints.  While the transaction was running, from the second window I ran various statements to see which would be blocked.

The test table:

    CREATE TABLE [dbo].[Test](
    	[ID] [int] IDENTITY(1,1) NOT NULL,
    	[Value] [nvarchar](50) NULL,
     CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED 
    (
    	[ID] ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    ) ON [PRIMARY]

From SSMS Window 1:

    BEGIN TRANSACTION
    
    SELECT * FROM dbo.Test WITH (UPDLOCK, HOLDLOCK)
    WAITFOR DELAY &#39;00:00:10&#39;
    
    COMMIT TRANSACTION

From SSMS Window 2 (ran one of the following):

    SELECT * FROM dbo.Test
    INSERT dbo.Test(Value) VALUES (&#39;bar&#39;)
    UPDATE dbo.Test SET Value = &#39;baz&#39; WHERE Value = &#39;bar&#39;
    DELETE dbo.Test WHERE Value= &#39;baz&#39;

Effect of different table hints on statements run in Window 2:

               (UPDLOCK)       (HOLDLOCK)    (UPDLOCK, HOLDLOCK)    (TABLOCKX)
    ---------------------------------------------------------------------------
    SELECT    not blocked      not blocked       not blocked         blocked
    INSERT    not blocked        blocked           blocked           blocked
    UPDATE      blocked          blocked           blocked           blocked
    DELETE      blocked          blocked           blocked           blocked

Did I misunderstand the answers given in those questions, or make a mistake in my testing?  If not, why would you use `(UPDLOCK, HOLDLOCK)` vs. `(HOLDLOCK)` alone?


---------
Further explanation of what I am trying to accomplish:

I would like to select rows from a table and prevent the data in that table from being modified while I am processing it.  I am not modifying that data, and would like to allow reads to occur.

[This answer][4] clearly says that `(UPDLOCK, HOLDLOCK)` will block reads (not what I want).  The comments on [this answer][5] imply that it is `HOLDLOCK` that prevents reads.  To try and better understand the effects of the table hints and see if `UPDLOCK` alone would do what I wanted, I did the above experiment and got results that contradict those answers.

Currently, I believe that `(HOLDLOCK)` is what I should use, but I am concerned that I may have made a mistake or overlooked something that will come back to bite me in the future, hence this question.


  [1]: http://msdn.microsoft.com/en-us/library/ms187373.aspx
  [2]: https://stackoverflow.com/questions/497049/which-lock-hints-should-i-use-t-sql
  [3]: https://stackoverflow.com/questions/1524155/what-effect-does-holdlock-have-on-updlock
  [4]: https://stackoverflow.com/questions/1524155/what-effect-does-holdlock-have-on-updlock/1524803#1524803
  [5]: https://stackoverflow.com/questions/497049/which-lock-hints-should-i-use-t-sql/497066#497066

Confused about UPDLOCK, HOLDLOCK

I&#39;ve got 3 relevant tables in my database.

    CREATE TABLE dbo.Group
    (
        ID int NOT NULL,
        Name varchar(50) NOT NULL
    )  

    CREATE TABLE dbo.User
    (
        ID int NOT NULL,
        Name varchar(50) NOT NULL
    )

    CREATE TABLE dbo.Ticket
    (
        ID int NOT NULL,
        Owner int NOT NULL,
        Subject varchar(50) NULL
    )

Users belong to multiple groups.  This is done via a many to many relationship, but irrelevant in this case.  A ticket can be owned by either a group or a user, via the dbo.Ticket.Owner field.  

What would be the *MOST CORRECT* way describe this relationship between a ticket and optionally a user or a group?

I&#39;m thinking that I should add a flag in the ticket table that says what type owns it.

Foreign Key to multiple tables

I have a code which is:

    DECLARE @Script VARCHAR(MAX)
    
    SELECT @Script = definition FROM manged.sys.all_sql_modules sq
    where sq.object_id = (SELECT object_id from managed.sys.objects 
    Where type = &#39;P&#39; and Name = &#39;usp_gen_data&#39;)
    
    Declare @Pos int
    
    SELECT  @pos=CHARINDEX(CHAR(13)+CHAR(10),@script,7500)
    
    PRINT SUBSTRING(@Script,1,@Pos)
    
    PRINT SUBSTRING(@script,@pos,8000)

The length of the Script is around 10,000 Characters and Since I am using print Statement which can hold only max of 8000. So I am using two print statements.

The problem is when I have a script which is of say 18000 characters then I used to use 3 print statements.

So Is there a way that I could set the number of print statements depending on the length of the script?


How to print VARCHAR(MAX) using Print Statement?

Is it possible in Microsoft SQL Server generate random int value from Min to Max (3-9 example, 15-99 e.t.c)

I know, I can generate from 0 to Max, but how to increase Min border?

This query generate random value from 1 to 6. Need to change it from 3 to 6.

    SELECT table_name, 1.0 + floor(6 * RAND(convert(varbinary, newid()))) magic_number 
    FROM information_schema.tables

**Added 5 sec later**:

    SELECT table_name, 3.0 + floor(4 * RAND(convert(varbinary, newid()))) magic_number 
    FROM information_schema.tables

Generate random int value from 3 to 6

I have a .sql file and I am trying to import it into SQL Server 2008. What is the proper way to do this?

How do I import a sql data file into SQL Server?

I&#39;m trying to get a the key-value back after an INSERT-statement. 
Example: 
I&#39;ve got a table with the attributes name and id. id is a generated value.

        INSERT INTO table (name) VALUES(&#39;bob&#39;);
Now I want to get the id back in the same step. How is this done?

We&#39;re using Microsoft SQL Server 2008.

SQL Server - Return value after INSERT

When I submit a batch (e.g., perform a query) in SSMS, I see the time it took to execute in the status bar. Is it possible to configure SSMS to show the query time with millisecond resolution? 

Here is the bar I am talking about with the section of interest circled in red:

![enter image description here][1]


  [1]: http://i.stack.imgur.com/RiUKi.png

SQL Server Management Studio, how to get execution time down to milliseconds

I&#39;m trying to write a script that will completely empty a SQL Server database. This is what I have so far:

    USE [dbname]
    GO
    EXEC sp_msforeachtable &#39;ALTER TABLE ? NOCHECK CONSTRAINT all&#39;
    EXEC sp_msforeachtable &#39;DELETE ?&#39;

When I run it in the Management Studio, I get:

&gt;Command(s) completed successfully.

but when I refresh the table list, they are all still there. What am I doing wrong?

How to drop all tables in a SQL Server database?

I am new to SQL Server. I am logged into my database through SQL Server Management Studio. 

I have a list of stored procedures. How do I view the stored procedure code? 

Right clicking on the stored procedure does not have any option like `view contents of stored procedure`.

Thanks.

How to view the stored procedure code in SQL Server Management Studio

In SQL Server Management Studio I would like to know what is SQLCMD mode?

In SQL Server Management Studio what is SQLCMD mode?

I installed SQL Server 2008 R2 to my local machine. But, I can&#39;t create a new database because of rights (or lack of).

&gt; &quot;CREATE DATABASE PERMISSION DENIED&quot;

So, I tried to assign the admin privileges to my current login

&gt; &quot;User does not have permission to perform this action.&quot;

I also tried to create a new login that would have admin privileges but with no luck. **How do I grant myself admin rights so that I can create a database?** I can re-install, but I prefer not to.

Content Type	Original Author	Original Content on Stackoverflow
Question	PowerUser	View Question on Stackoverflow
Solution 1 - Sql Server	user596075	View Answer on Stackoverflow
Solution 2 - Sql Server	Michael Goldshteyn	View Answer on Stackoverflow

SQL Server. How to refresh the intellisense?

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Do something if screen width is less than 960 px

Converting Go struct to JSON

Attributions