Forum Replies Created
Viewing 4 posts - 31 through 34 (of 34 total)
-
RE: How to check if a field contains unicode data
Before I populate a VARCHAR field from a NVARCHAR field, I want to check if it is possible to do without raising an error.
-
RE: Need some assistance with Fuzzy Lookup
Yes, precisely what I was after!
Many thanks!
-
RE: Determining if a substring is a number...with variable substring lengths
How about this?
DECLARE @SubStringLength AS INT
SELECT STRING
FROM STUFF
WHERE ISNUMERIC(SUBSTRING(STRING,1,@SubStringLength)) = 1 -- Checks the substring is numeric
AND SUBSTRING(STRING,1,@SubStringLength) NOT LIKE '%.%' ...
-
RE: How to give a login read-only access to an SQL server?
Hi Andrew, thanks for the reply.
That's what I did in the end. I created 6 NT security groups, as follows:
G_SQL_PROD_SYSADMIN G_SQL_PROD_READONLY
G_SQL_DEV_SYSADMIN ...
Viewing 4 posts - 31 through 34 (of 34 total)