Here's a good reference link with sample query to search SQL-Server for TEXT.
- Click Here for Link -
Modified the code slightly:
DECLARE @StringToSearch varchar(100)
SET @StringToSearch = 'TRU'
SET @StringToSearch = '%' + UPPER(@StringToSearch) + '%'
SELECT DISTINCT SO.NAME
FROM SYSOBJECTS SO (NOLOCK)
WHERE SO.TYPE = 'P'
AND UPPER(SO.NAME) LIKE @StringToSearch
I signed up for the Hortonworks Certified Associate exam last Thursday. Figured if I sign up, I'd have to take the test. And if I tak...
Saw a post today on Twitter, " Microsoft releases CNTK, its open source deep learning toolkit, on GitHub " This is big news. Be...
It seems like open source applications are the mainstream today. So many new products delivered through Aache foundation. Some do this. S...