sql server - Including initial value in a select Statement -
i have select query returns following o/p.. 1 arun, 2 kumar, 3 babu, 4 ram,
is possible add intial value o/p without inserting value table, in other means hardcoding intial value. can o/p as
0 select, 1 arun, 2 kumar, 3 babu, 4 ram
try this:
select 0, 'select' union <your query>
Comments
Post a Comment