In [SQL Server 2005 and above][1], you can do this:

    SELECT TOP (@topparam) * from table1


  [1]: https://web.archive.org/web/20150520123828/http://sqlserver2000.databases.aspfaq.com:80/how-do-i-use-a-variable-in-a-top-clause-in-sql-server.html

You need to have at least SQL Server 2005.  This code works fine in 2005/8 for example ...

    DECLARE @iNum INT
    SET @iNum = 10
    SELECT TOP (@iNum) TableColumnID
    FROM TableName

If you have SQL Server 2000, give this a try ...

    CREATE PROCEDURE TopNRecords
    @intTop INTEGER
    AS
    SET ROWCOUNT @intTop
    
    SELECT * FROM SomeTable
    
    SET ROWCOUNT 0
    GO

You could write an inline query:

EXEC &#39;SELECT TOP &#39; + @topparam + &#39; * FROM ... &#39;

Parse it as an int and that will prevent a SQL injection attack.


What&#39;s the easiest way to save a `UIColor` into `NSUserDefaults` and then get it back out?

Saving UIColor to and loading from NSUserDefaults

I am trying to connect to a remote tomcat JMX instance using jConsole. But can&#39;t connect successfully. Any Idea?

I included the following option in remote tomcat `catalina.sh`:

    JAVA_OPTS=&quot;$JAVA_OPTS -Dcom.sun.management.jmxremote \
        -Dcom.sun.management.jmxremote.port=9004 \
        -Dcom.sun.management.jmxremote.ssl=false \
        -Dcom.sun.management.jmxremote.authenticate=false&quot;


Connecting remote tomcat JMX instance using jConsole

Trying to parameterize the value of TOP in my sql statement. 

    SELECT TOP @topparam * from table1

    command.Parameters.Add(&quot;@topparam&quot;,SqlDbType.VarChar, 10).Value = somevalue.ToString();

This doesn&#39;t seem to work. Anyone have any suggestions?  
Just to clarify, I don&#39;t want to use stored procedures. 

C# SQL Top as parameter

Trying to parameterize the value of TOP in my sql statement.
<pre><code class="hljs language-scss">SELECT TOP @topparam * from table1

command.Parameters.Add("@topparam",SqlDbType.VarChar, 10).Value = somevalue.ToString();
</code></pre>
This doesn't seem to work. Anyone have any suggestions? 
Just to clarify, I don't want to use stored procedures.

When do you use which in general? Examples are highly encouraged!


I am referring so MySql, but can&#39;t imagine the concept being different on another DBMS

what is the difference between GROUP BY and ORDER BY in sql

When and Why does some one decide that they need to create a View in their database?  Why not just run a normal stored procedure or select?

Why do you create a View in a database?

How do you combine multiple select count(*) from different table into one return?

I have a similar sitiuation as this [post][1]


  [1]: https://stackoverflow.com/questions/606234/select-count-from-multiple-tables

but I want one return.

I tried Union all but it spit back 3 separate rows of count. How do you combine them into one?

    
    select count(*) from foo1 where ID = &#39;00123244552000258&#39;
    union all 
    select count(*) from foo2 where ID = &#39;00123244552000258&#39;
    union all
    select count(*) from foo3 where ID = &#39;00123244552000258&#39;

edit: I&#39;m on MS SQL 2005




SQL: Combine Select count(*) from multiple tables

I cannot understand the syntax error in creating a composite key. It may be a logic error, because I have tested many varieties.

**How do you create composite keys in Postgres?**


    CREATE TABLE tags
         (
                  (question_id, tag_id) NOT NULL,
                  question_id INTEGER NOT NULL,
                  tag_id SERIAL NOT NULL,
                  tag1 VARCHAR(20),
                  tag2 VARCHAR(20),
                  tag3 VARCHAR(20),
                  PRIMARY KEY(question_id, tag_id),
                  CONSTRAINT no_duplicate_tag UNIQUE (question_id, tag_id)
         );
        ERROR:  syntax error at or near &quot;(&quot;
        LINE 3:               (question_id, tag_id) NOT NULL,
                              ^

Postgres: How to do Composite keys?

If I had a table like this:

    jobId, jobName, Priority

Whereby Priority can be an integer between 1 to 5.

Since I would need this query for generating a chart on report, I would need to display the jobid, jobname and 5 fields called Priority1, Priority2, Priority3, Priority4. Priority5.  

Priority1 should count the amount of rows where priority field has the value of 1.

Priority2 should count the amount of rows where priority field has the value of 2.

Priority3 should count the amount of rows where priority field has the value of 3.

etc

How would I do that in a quick and performant manner?

Conditional Count on a field

I have a table `Orders` with the following fields:

&gt; Id | SubTotal | Tax | Shipping | DateCreated

The `Id` column is set to `autoincrement(1,1)`.

This is to be used in an E-commerce storefront. Sometimes a current E-commerce store is migrated to my platform and they already have orders - which could mean that their current `Order.Id` is, for example, `9586`.

I want to have the `autoincrement` field start from that value.

How can I do this?

Set start value for column with autoincrement

I need to update this table in **SQL Server** with data from its &#39;parent&#39; table, see below:

**Table: sale**

    id (int)
    udid (int)
    assid (int)
    
**Table: ud**

    id  (int)
    assid  (int)

`sale.assid` contains the correct value to update `ud.assid`. 

What query will do this? I&#39;m thinking of a `join` but I&#39;m not sure if it&#39;s possible.

How can I do an UPDATE statement with JOIN in SQL Server?

I want to save an object (of any type) into a field in a database in SQL Server 2005. Is it possible? Do I have to convert the object into something, like a byte array for example and cast it back when retrieving it?

Can I save an &#39;Object&#39; in a SQL Server database?

I know enough about SQL to get my job done but reading different articles I see T-SQL, SQL Server  and SQL. Are they all the same? What are the major differences between the three?

I know SQL is an ANSI standard. What about the other two?

What are the differences between T-SQL, SQL Server and SQL

If you wanted to generate a pseudorandom alphanumeric string using T-SQL, how would you do it?  How would you exclude characters like dollar signs, dashes, and slashes from it?

Generating random strings with T-SQL

I&#39;m just getting started using ADO.NET and DataSets and DataTables. One problem I&#39;m having is it seems pretty hard to tell what values are in the data table when trying to debug.

What are some of the easiest ways of quickly seeing what values have been saved in a DataTable? Is there someway to see the contents in Visual Studio while debugging or is the only option to write the data out to a file?

I&#39;ve created a little utility function that will write a DataTable out to a CSV file. Yet the the resulting CSV file created was cut off. About 3 lines from what should have been the last line in the middle of writing out a System.Guid the file just stops. I can&#39;t tell if this is an issue with my CSV conversion method, or the original population of the DataTable.

**Update**

Forget the last part I just forgot to flush my stream writer.



How to view a DataTable while debugging

I have a `DataTable` that is filled in from an SQL query to a local database, but I don&#39;t know how to extract data from it.
Main method (in test program):

&lt;!-- language: csharp --&gt;

    static void Main(string[] args)
    {
        const string connectionString = &quot;server=localhost\\SQLExpress;database=master;integrated Security=SSPI;&quot;;
        DataTable table = new DataTable(&quot;allPrograms&quot;);

        using (var conn = new SqlConnection(connectionString))
        {
            Console.WriteLine(&quot;connection created successfuly&quot;);

            string command = &quot;SELECT * FROM Programs&quot;;

            using (var cmd = new SqlCommand(command, conn))
            {
                Console.WriteLine(&quot;command created successfuly&quot;);

                SqlDataAdapter adapt = new SqlDataAdapter(cmd);

                conn.Open(); 
                Console.WriteLine(&quot;connection opened successfuly&quot;);
                adapt.Fill(table);
                conn.Close();
                Console.WriteLine(&quot;connection closed successfuly&quot;);
            }
        }

        Console.Read();
    }

The command I used to create the tables in my database:

&lt;!-- language: sql --&gt;

    create table programs
    (
    	progid int primary key identity(1,1),
    	name nvarchar(255),
    	description nvarchar(500),
    	iconFile nvarchar(255),
    	installScript nvarchar(255)
    )

How can I extract data from the `DataTable` into a form meaningful to use?

How do I extract data from a DataTable?

In AppConfig it is possible to use  `|DataDirectory|` but I can&#39;t find any doc ?


ADO.NET  |DataDirectory| where is this documented?

How do I view the SQL generated by entity framework ?

(In my particular case I&#39;m using the mysql provider - if it matters)

Content Type	Original Author	Original Content on Stackoverflow
Question	muhan	View Question on Stackoverflow
Solution 1 - Sql	Cade Roux	View Answer on Stackoverflow
Solution 2 - Sql	JP Alioto	View Answer on Stackoverflow
Solution 3 - Sql	Russell	View Answer on Stackoverflow

C# SQL Top as parameter

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Connecting remote tomcat JMX instance using jConsole

Saving UIColor to and loading from NSUserDefaults

Attributions