tag:blogger.com,1999:blog-6538321000057298497.post7619161873986512775..comments2023-05-20T03:26:37.996-07:00Comments on SQL Server tips ,SQL Server tutorials, database tips- Indiandotnet: An interesting way of aliasing TIP#107Anonymoushttp://www.blogger.com/profile/10272758489608834274noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6538321000057298497.post-41825880190581025402015-08-11T18:46:05.507-07:002015-08-11T18:46:05.507-07:00Well that's handy! Cheers mate.Well that's handy! Cheers mate.Mike250https://www.blogger.com/profile/15059914322995754694noreply@blogger.comtag:blogger.com,1999:blog-6538321000057298497.post-91661372713580366672015-08-06T16:50:15.654-07:002015-08-06T16:50:15.654-07:00Nice!
Beats having something like
SELECT 'R...Nice! <br /><br />Beats having something like<br /><br />SELECT 'Rajat' as Name, 30 as Runs<br />UNION ALL<br />SELECT 'Sandeep', 40<br />UNION ALL<br />SELECT 'Sunil', 35<br />UNION ALL<br />SELECT 'Shreya', 50<br />UNION ALL<br />SELECT 'Virendra', 45<br /><br /><br /><br />Available since SQL Server 2008, documentation available here:<br /><br />https://msdn.microsoft.com/en-us/library/dd776382.aspxAnonymoushttps://www.blogger.com/profile/00514930851227707019noreply@blogger.com