How to use SQL Parameter in this situation

My query is this: "SELECT TOP 5 * FROM [TableName] ORDER By NEWID()"

But I want to use a SQL Parameter so it could be something like this: "SELECT TOP @ParameterName * FROM [TableName] ORDER By NEWID()"

The normal way dosen't work:

Ct.Command.CommandText = "SELECT TOP @ParameterName * FROM [TableName] ORDER By NEWID()"
Ct.Command.Parameters.AddWithValue("@ParameterName", Some开发者_高级运维Value)

How can I add a Parameter in this situation?

---

Simply put parenthesis around the parameter. Supported since SQL Server 2005

Ct.Command.CommandText = "SELECT TOP (@ParameterName) * FROM [TableName] ORDER By NEWID()"

Note: TOP without parenthesis is for backwards compatibility; they should always be used

For backward compatibility, TOP expression without parentheses in SELECT statements is supported, but we do not recommend this.

---

Is it necessary to use the parameter this way? May be you will do something like this:

Ct.Command.CommandText = string.Format("SELECT TOP {0} * FROM [TableName] ORDER By NEWID()", 5);

---

Using dynamic T-SQL

EXEC('SELECT TOP ' + CAST(@ParameterName AS VARCHAR(5)) + ' * FROM [TableName] ORDER By NEWID()')

---

You have to create dynamic SQL here.

Ct.Command.CommandText = 
    String.Format("SELECT TOP {0} * FROM [TableName] ORDER By NEWID()",SomeValue)