sql server joining two set of data

I have the following simple (i think) requirement:

Have one value lets say '1', then I have a table with one column which has more than one row.

What is the SQL required so that I return two columns, the first column having all values of '1', the second column being the values from the table.

Thanks, Bruce

Answers


select 1 as yourValue, yourField from yourTable

that ?

edit:

Even more, if it's a value coming as parameter (in a variable) you could do the same

select @yourVariable as yourValue, yourField from yourTable

Need Your Help

TCP Timeout using poll

unix network-programming

I am currently trying to add a timeout to a method which opens up a tcp connection. I am roughly using the guide found here except that I am trying to use poll() instead of select. However my call to

Adding custom items to stackpanel

c# visual-studio-2012 windows-phone-8 custom-controls itemscontrol

I'm working on a project (for Windows Phone 8 with Visual Studio 2012 with C#) where I want to display some items that each have:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.