Sql

Search

sql like variable

ALTER PROCEDURE <Name>
(
    @PartialName VARCHAR(50) = NULL
)

SELECT Name 
    FROM <table>
    WHERE Name LIKE '%' + LTRIM(RTRIM(@PartialName)) + '%'

Comment

PREVIOUS	NEXT

Code Example
Sql :: extract month from date sql two digits
Sql :: show structure of table in sql
Sql :: upload database mysql command line
Sql :: mssql reset auto increment
Sql :: having count greater than 1 mysql
Sql :: alter sequence restart with postgresql
Sql :: mssql remove column
Sql :: how to check database size mysql
Sql :: restart identity cascade
Sql :: psql count where not null
Sql :: starting mysql service from mac
Sql :: execution plan oracle
Sql :: query any digits record
Sql :: setVal pgsql
Sql :: host is not allow to connect to this mysql server
Sql :: oracle set date format
Sql :: hw to delete a procedure in pl sql
Sql :: how to check mysql version in xampp
Sql :: oracle view source
Sql :: display total number of tables in mysql
Sql :: mysql copy table1 to table2
Sql :: truncate table
Sql :: oracle stop
Sql :: sql query length of string the longest
Sql :: Oracle NLS_CHARACTERSET
Sql :: select first rows postgresql
Sql :: mysql sysdate - 1 day
Sql :: how to rename column in sql
Sql :: mysql remove user privileges
Sql :: cmd to rename a collumn name in sql

Search

SQL

sql like variable

ADD CONTENT