[SQL Server] Replace

---

• Replace
• Select top, how to get the rest?
• why used WITH XMLNAMESPACES in tsql ?

Replace Posted: 22 Mar 2010 10:34 PM PDT Hi Consider this tableMan_name ModelMotorola MotoQMotorola RAZR2Nokia N73Nokia 6100Samsung C118I have used Distinct Statement to retrieve the value. Now I want to replace if the Man_Name comes 2nd time then I need to replace that value with "Blank". Is it possible to do this?

Select top, how to get the rest? Posted: 23 Mar 2010 07:14 AM PDT HiI want to use paging and I don't want to get so many records.But if I use select top (100) for example, how will I get the rest of the records, split in 100 per each select query. I have seen example like this [quote]SELECT TOP (100) OrderDate, ShipName FROM orders WHERE orderID NOT IN (SELECT TOP OFFSET OrderID FROM orders)[/quote]. But I have read and tried that Offset doesn't work in SQL Server. Is there anything else I can do?ThanksFia

why used WITH XMLNAMESPACES in tsql ? Posted: 02 Oct 2013 06:38 PM PDT What is the used WITH XMLNAMESPACES in tsql. Does it provide some functionality ? What would break if do not used WITH XMLNAMESPACES.

You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server Newbies To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610