Search
 
SCRIPT & CODE EXAMPLE
 

SQL

create function in microsoft sql server

CREATE FUNCTION dbo.StripWWWandCom (@input VARCHAR(250))
RETURNS VARCHAR(250)
AS BEGIN
    DECLARE @Work VARCHAR(250)

    SET @Work = @Input

    SET @Work = REPLACE(@Work, 'www.', '')
    SET @Work = REPLACE(@Work, '.com', '')

    RETURN @work
END
Comment

PREVIOUS NEXT
Code Example
Sql :: convert to hexadecimal sql 
Sql :: mysql data types 
Sql :: sql server select where date 
Sql :: add auto increment column mysql 
Sql :: sql ends with string 
Sql :: org.h2.jdbc.JdbcSQLSyntaxErrorException 
Sql :: can you use a where clause for a child query 
Sql :: sql rename column 
Sql :: how to reset table in sql server 
Sql :: mysql incrementation 
Sql :: oracle sysdate - 1 month 
Sql :: cast to float with .2 sql 
Sql :: alter table add column and foreign key mysql 
Sql :: sql syntax create timestamp column 
Sql :: job for postgresql.service failed because the control process exited with error code. see "systemctl status postgresql.service" and "journalctl -xe" for details. 
Sql :: postgresql list users 
Sql :: create unique index postgres 
Sql :: drop foreign key mysql 
Sql :: postgresql today - 1 year 
Sql :: create index concurrently postgres 
Sql :: sql server substring 
Sql :: mysql date time string format python 
Sql :: insert query return id mysql 
Sql :: postgresql extract hour and minutes from timestamp 
Sql :: limit sqlserver 
Sql :: how to import large sql file in phpmyadmin in ubuntu 
Sql :: oracle sql merge 
Sql :: use concat in group_concat 
Sql :: get current month last date in sql server 
Sql :: oracle nextval 
ADD CONTENT
Topic
Content
Source link
Name
4+3 =