Examples A. Split comma-separated value string Parse a comma-separated list of values and return all non-empty tokens. STRING_SPLIT will return empty string if there is nothing between separator. Condition RTRIM(value) <> ” will remove empty tokens. B. Split comma-separated value string in a column Product table has a column with comma-separate list of tags shown... » read more
Gmail Admin https://admin.google.com Add an email alias for a G Suite user You can add up to 30 aliases for each user. Sign in to your Google Admin console. From the Admin console Home page, go to Users. In the Users list, find the user. If you need help, see Find a user account. Click the user’s name to open their account page. Click User information Email... » read more
Sources: https://docs.microsoft.com/en-us/visualstudio/debugger/just-my-code?view=vs-2019
WCF Endpoint http://localhost:57945/Service1.svc Use the following to generate a service reference in your Connected Services client application… http://localhost:57945/Service1.svc?singleWsdl After you have generated the service reference objects, you can call the service directly from within your client application. If you have more that one end points, you will need to specify which end point to use.
When you create a WCF application in Visual Studio. The project creates 2 classes for you. It also link it to the WCF Test Client. Interface and Data Contract class (.cs) Both Interface and Data Contact. The Data Contact can be its own separate class. Service Class (.svc) Implements IService1 Interface. WCF Test Client
WCF is a service layer that allows you to build applications that can communicate using a variety of communication mechanisms. With it, you can communicate using Peer to Peer, Named Pipes, Web Services and so on. You can’t compare them because WCF is a framework for building interoperable applications. If you like, you can think... » read more
Service-oriented architecture (SOA) is a style of software design where services are provided to the other components by application components, through a communication protocol over a network. The basic principles of service-oriented architecture are independent of vendors, products and technologies. A service is a discrete unit of functionality that can be accessed remotely and acted upon... » read more
A data contract is a formal agreement between a service and a client that abstractly describes the data to be exchanged. That is, to communicate, the client and the service do not have to share the same types, only the same data contracts. A data contract precisely defines, for each parameter or return type, what data... » read more
DATETIME to DATE and TIME Should I use CAST or Convert? Unless you have some specific formatting requirements you’re trying to address during the conversion, I would stick with using the CAST function. There are several reason I can think of: CAST is ANSI-SQL compliant; therefore, more apt to be used in other database implementation.... » read more
INT to VARCHAR DATETIME to DATE and TIME Should I use CAST or Convert? Unless you have some specific formatting requirements you’re trying to address during the conversion, I would stick with using the CAST function. There are several reason I can think of: CAST is ANSI-SQL compliant; therefore, more apt to be used in... » read more