CELKO (9/10/2012)
I need to insert empty row in a temp table within a stored procedure.
Where is the DDL? There is no such concept in RDBMS.
...
What kind of concept is missing here?
Why is it a problem to have a temp table with empty rows?
It can be used to build cartesian products, and it's quite easy to populate it, for example:
-- create temp table and populate it with 10 empty rows
SELECT TOP 10 CAST(null AS CHAR(1)) c INTO #t
FROM sys.columns
-- Select each row from MyTable as many times (10) as many empty rows found in #t
SELECT t.*
FROM dbo.MyTable
CROSS JOIN #t
See? A bit of creativity and concept flies. :hehe:
However, I am sure it's not what OP does need it for...