Viewing 8 posts - 1 through 8 (of 8 total)
I experienced this error, I now make sure I make nvarchar types with 4000 rather than using the max function.
Also just a note on BCP. Ensure it's always on one...
September 10, 2012 at 4:33 am
You may be better off holding the parameter values in a declared variable(s) then passing it into the command.
September 10, 2012 at 4:29 am
GROUP BY
(MAT),
[DVD] WITH ROLLUP
September 6, 2012 at 8:48 am
A windowed function won't be slower than a two step function if you nest the conditions correctly. My last example is a two step using a temp table, but you...
September 6, 2012 at 8:03 am
Hi,
Firstly always name your columns:
CREATE TABLE DEMO ([COLUMN1] NVARCHAR(20))
Then insert your values:
INSERT INTO DEMO VALUES ('ABC')
INSERT INTO DEMO VALUES ('ABC')
INSERT INTO DEMO VALUES ('ABC')
INSERT INTO DEMO VALUES ('DEF')
INSERT INTO...
September 6, 2012 at 5:41 am
Why have '^' as a delimiter for a start?
Anyway, the problem is probably the encoding of the txt file, make sure it's Unicode. Make sure your type is 'varchar' and...
September 6, 2012 at 3:27 am
As it stands, SS2k8 doesn't have any native support for JSON.
September 6, 2012 at 2:39 am
Rather than trying to execute code in the aggregation of results, you'd be better off controlling the flow of your query with an IF EXISTS statement.
September 6, 2012 at 2:23 am
Viewing 8 posts - 1 through 8 (of 8 total)