T-SQL Remove trailing zeros from left

T-SQL - Removing trailing zeroes

There are some cases when we have a value with trailing zeors to the left like '00089' but actually we want to consider only '89'.

The one solution to above problem is we can CAST it as INT. But since the value can be non-numeric also like '00089 MM:NN'. In this case CAST to INT will not work.

We will try to solve this problem using PATINDEX.

Below is the Code:


What Is an XML Web Service?

XML Web service

XML Web services are the fundamental building blocks in the move to distributed computing on the Internet. Open standards and the focus on communication and collaboration among people and applications have created an environment where XML Web services are becoming the platform for application integration. Applications are constructed using multiple XML Web services from various sources that work together regardless of where they reside or how they were implemented.

There are probably as many definitions of XML Web Service as there are companies building them, but almost all definitions have these things in common:

XML Web Services expose useful functionality to Web users through a standard Web protocol. In most cases, the protocol used is SOAP.

XML Web services provide a way to describe their interfaces in enough detail to allow a user to build a client application to talk to them. This description is usually provided in an XML document called a Web Services Description Language (WSDL) document.

XML Web services are registered so that potential users can find them easily. This is done with Universal Discovery Description and Integration (UDDI).


Cracking Technical Interview - Must Watch

Coding Interview - How to Crack

Going for technical interview, you must watch to know what can be asked and how should you answer/take over the interviewer. Watch this video and know what are the common mistakes that candidates can make in their technical interviews.


Posts By Month