• Post Reply Bookmark Topic Watch Topic
  • New Topic

Query of Oracle to SQL Server  RSS feed

 
Muhammad Saifuddin
Ranch Hand
Posts: 1325
Android Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SELECT firstName || ' ' || lastName from usertable;

How to do it in SQL Server?
 
Muhammad Saifuddin
Ranch Hand
Posts: 1325
Android Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No problems. Solved it. Found it in SQL Server Help.

The query in SQL Server would be


if any one have a short solution for that so please share with me..

thanks
[ August 04, 2006: Message edited by: saif uddin ]
 
Scott Johnson
Ranch Hand
Posts: 518
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!