• Post Reply Bookmark Topic Watch Topic
  • New Topic

Query of Oracle to SQL Server

 
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
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!