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 to Expert-Tailored 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

Recommended Textbook for

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

9th Edition

B01JXPZ7AK, 9780805360479

More Books

Students also viewed these Databases questions

Question

★★★★★

The bent rod ABCD rotates about a line joining points A and D with a constant angular velocity of 75 rad/s. Knowing that at the instant considered the velocity of corner C is upward, determine the...

Answered: 1 week ago

Question

★★★★★

What translation method should be used for a subsidiary that operates in a highly inflationary environment? Why?

Answered: 1 week ago

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

Question

★★★★★

evaluate and draft recruitment and selection policies and procedures

Answered: 1 week ago

Question

★★★★★

understand the role of human resource managers and line managers in the recruitment and selection process

Answered: 1 week ago

Question

★★★★★

2. Why are there so few female engineers compared to male engineers and what can the engineering sector do to encourage females to take up a career in engineering?

Answered: 1 week ago

Previous Question Next Question