Database

sonal dadhania1 wrote:

It's looking like the CAST is treating the string as numeric and converting a really large int to binary

DECLARE @hex AS VARBINARY(10)
SET @hex = 0x89504e
SELECT @hex

SELECT oi.CustomerID
FROM OrderItems oi
	JOIN Products p
WHERE p.ProductID IN ('Product1', 'Product2')
GROUP BY oi.CustomerID
HAVING COUNT(*) = 2

DECLARE @NumberOfProducts int
SET @NumberOfProducts = 2

SELECT
	c.*
FROM Customer c
	JOIN
	(
		SELECT oi.CustomerID
		FROM OrderItems oi
			JOIN Products p
		WHERE p.ProductID IN ('Product1', 'Product2')
		GROUP BY oi.CustomerID
		HAVING COUNT(*) = @NumberOfProducts
	) AS t
		ON t.CustomerID = c.CustomerID

zmskerem wrote:

"*'";

rohitsrivastava wrote:

right
string strSQL = "select FilmName from films where FilmName like '" & cmbContent.Text & "%'" ;

rohitsrivastava wrote:

wrong this is your
"select FilmName from films where FilmName like" + "'" + cmbContent.Text + "*'";