All done!!!
We can use Case and CHARINDEX to split column with delimiter into two columns in SQL Server
select
case when CHARINDEX('_',name)>0
then SUBSTRING(name,1,CHARINDEX('_',name)-1)
else name end firstname,
CASE WHEN CHARINDEX('_',name)>0
THEN SUBSTRING(name,CHARINDEX('_',name)+1,len(name))
ELSE NULL END as lastname
from emp
you can use CASE command to control is last name available.
MS SQL Server:
Query 1:
declare @t table (id int, name varchar(50))
insert into @t (id,name) values( 1 ,'abc_rao')
insert into @t (id,name) values( 2 ,'nani')
insert into @t (id,name) values( 3 ,'hari_babu')
insert into @t (id,name) values( 4 ,'kalibabu')
insert into @t (id,name) values( 5 ,'ab_tan')
select
case when CHARINDEX('_',name)>0
then SUBSTRING(name,1,CHARINDEX('_',name)-1)
else name end firstname,
CASE WHEN CHARINDEX('_',name)>0
THEN SUBSTRING(name,CHARINDEX('_',name)+1,len(name))
ELSE NULL END as lastname
from @t
| FIRSTNAME | LASTNAME |
|-----------|----------|
| abc | rao |
| nani | (null) |
| hari | babu |
| kalibabu | (null) |
| ab | tan |
In order to force a secure connection on our website, it is necessary to set up a certain HTTP/HTTPS redirection rule. This way, anyone who enters your site using a link like “domain.com” will be redirected to “https://domain.com” or “https://www.domain.com” (depending on your choice) making the traffic encrypted between the server and the client side.
Steps to setup an IIS HTTPS redirect:
Add password protection to your online store
You can
add password protection to your online store.
Steps:
Edit your password page settings
You can edit the content that shows on your password page, such as the text, colors, and typography.
In a web service, while converting a Base64 string to file, it is sometimes giving error - "A generic error occurred in GDI+ while creating image from Base64 string".
Solution:
I have used the below code and problem resolved.
When we upload the SVG file, we recieve the notification “Sorry, this file type is not permitted for security reasons.”To Resolve this issue, we need to add the below function in the functions.php files
function cc_mime_types($mimes) {
$mimes['svg'] = 'image/svg+xml';
return $mimes;
}
add_filter('upload_mimes', 'cc_mime_types');