Skip to main content
A
Anonymous
March 18, 2009
解決済み

sql add blank row to result

  • March 18, 2009
  • 返信数 2.
  • 24647 ビュー
Hi,

I currently use a temporary table to add a blank row to the top/beginning of my query results. I'm moving to MS SQL stored procedures and wanted to know if it's possible to add a blank row right into my SQL so I can eliminate the temporary table solution.

Any thoughts on this are appreciated!

cfwild
このトピックへの返信は締め切られました。
解決に役立った回答
Hi,

Thanks for the insight. It worked perfectly! For anyone looking for just a blank row insert "above" the query results, here was the final code:

SELECT Category
FROM Syndicated
UNION
SELECT ''
ORDER BY Category

Again, thanks for the help!

返信数 2

-
-__cfSearching__-
Inspiring
March 18, 2009
You have to use SELECT with the string literal

SELECT Category
FROM Syndicated
UNION
SELECT '<HI>'
ORDER BY Category
A
Anonymous
解決！
March 18, 2009
Hi,

Thanks for the insight. It worked perfectly! For anyone looking for just a blank row insert "above" the query results, here was the final code:

SELECT Category
FROM Syndicated
UNION
SELECT ''
ORDER BY Category

Again, thanks for the help!
-
-__cfSearching__-
Inspiring
March 18, 2009
> wanted to know if it's possible to add a blank row right into my SQL so I can eliminate
> the temporary table solution

You could use a union to merge your blank row with your other results and order it so the blank sorts on top. But why do you need a blank row? It sounds like mixing user interface code with database code ..
A
Anonymous
March 18, 2009
Hi,

Thanks for responding.

I fashioned this up, but I'm throwing an error:

SELECT S.Category
FROM Syndicated S
UNION '<HI>'
ORDER BY S.Category

Thoughts on getting this to work in tsql?

cfwild

My problem is that I'm binding this to the cfselect, the bind doesn't allow the queryposition above|below functionality to work. So I'm forced to a). temp table (which is working fine) or b). investigate adding into the sql. Thanks!
契約条件Accessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices