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

Popular posts from this blog

c++ - Convert big endian to little endian when reading from a binary file -

C#: Application without a window or taskbar item (background app) that can still use Console.WriteLine() -

unicode - Are email addresses allowed to contain non-alphanumeric characters? -