Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 07, 2024

Hi everyone, hope you are well I need a help with C# and SQL Server I have the query which ends with ORDER BY @OrderBY

Hi everyone, hope you are well

I need a help with C# and SQL Server

I have the query which ends with

ORDER BY @OrderBY @SortBy

and I am passing two value for @OrderBy and @SortBy from C#, but I am getting this error message

SQL80001: Incorrect Syntax near '@SortBy'

does anybody can help me with this issue, please.

best regards.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

=+ (b) Let f ., be 2" times the indicator of the set of x in the unit interval for which d .. + ((x) = ... = d2(x) =0, where d, (x) is the kth dyadic digit. Show

Answered: 1 week ago

Question

★★★★★

Breeze Toothpaste Company makes tubes of toothpaste. The product is produced and then pumped into tubes and capped. The production manager is concerned whether the filling process for the tubes of...

Answered: 1 week ago

Question

★★★★★

Gross margin %: The following accounts were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for April 30, for Transition Inc... COS Dariation Tynense $ Depreciation...

Answered: 1 week ago

Question

★★★★★

Data Table Annual Net Cash Inflows Year Toy action Sandbox toy figure project project $ 312,500 $ 518,000 1 312,500 380,000 2 3 312,500 340,000 4. 312,500 240,000 50,000 312,500 5 $ 1,562,500 $...

Answered: 1 week ago

Question

★★★★★

4. Mrs. Burgess is a sixth-grade language arts teacher whose class includes Renata, a student with a significant cognitive disability. Mrs. Burgess is planning a unit in which her students will read...

Answered: 1 week ago

Question

★★★★★

Prepare the income statement and the statement of owner's equity for the month of June, and the balance sheet as of June 30. Nina Niko launched a new business, Niko's Maintenance Co., that began...

Answered: 1 week ago

Question

★★★★★

The following information was taken from the accounting records of Elliott Manufacturing Corp. Unfortunately, some of the data were destroyed by a computer malfunction. Sales Revenue Finished Goods...

Answered: 1 week ago

Question

★★★★★

M/s Suba Pharmaceuticals has imported a machinery on 1st July, 2012 for `1,60,000 paid custom duty and freight `80,000 and incurred erection charges ` 60,000. Another local machinery costing...

Answered: 1 week ago

Question

★★★★★

Question 5 a) Departments A, B, C, and D need to be assigned to four rooms 1, 2, 3, and 4. These rooms are arranged in a row, in that order, with 20 meters between each. The departmental workflows...

Answered: 1 week ago

Previous Question Next Question