Viewing 15 posts - 541 through 555 (of 789 total)
I created temp table, 1 row for testing and the code to show you that you can do the update with larg data if you using NVARCHAR(MAX)!
Maybe you should post...
December 28, 2008 at 9:37 am
Steve I think you need more moderators to clean the posts in wrong sections!
December 28, 2008 at 9:33 am
You can test here!
CREATE TABLE #TESTING
(
ID INT,
TEXTING NVARCHAR(MAX)
);
GO
INSERT INTO #TESTING
SELECT 1, 'YOUR LONG TEXT MAYBE HERE!';
DECLARE @TEXT AS NVARCHAR(MAX)
DECLARE @ID AS INT
SET @ID = 1
SET @TEXT = ' bLLA BLLA...
December 28, 2008 at 6:50 am
ok ... try declaration as NVARCHAR(MAX)!
December 28, 2008 at 6:40 am
GilaMonster (12/28/2008)
Dugi (12/27/2008)
...do we have any other possibility such as DBCC checkident isn't it!?Does your copy of Books Online say that CheckIdent is deprecated?
Simple ...NO! - I don't have...
December 28, 2008 at 6:34 am
I agree with you Lynn Petis ...but better will be like this:
SQL Server 2000
Administration
General
...
December 28, 2008 at 6:23 am
amarnath_sk (12/27/2008)
ya i hav done that.can i see that instance in my admin system,if possible how can i ?
Did you install indivitualy in 3 machines or just in one ...so...
December 28, 2008 at 3:36 am
Why not to see the forum more simple organized...I agree...not bad idea!?
😉
December 27, 2008 at 7:18 pm
hmmm interesting info here ... what about Identity columns if you want to reseed ... or check the identity value ...do we have any other possibility such as DBCC checkident...
December 27, 2008 at 6:35 pm
:hehe: I told you ganeshmuthuvelu
that someone will do like magic man ...now here is Jeff amazing code generator!
:w00t:
December 27, 2008 at 10:35 am
Jeff Moden (12/27/2008)
;WITH
cteTally AS
(
SELECT ROW_NUMBER() OVER (ORDER BY ID)-1 AS N
FROM Master.sys.SysColumns
)
SELECT DATEADD(dd,(t.n)*14,'20090102') AS BiFriday
...
December 27, 2008 at 9:38 am
kha_ang (12/27/2008)
Thanks for your response. Please bear with me as I am new to this.
1) what service(s) to leave it ON and how?
2) input a "." as the...
December 27, 2008 at 6:55 am
interesting variable value ...at first when I saw your sample data it shows me the logic that max_value - min_value = allowed_value but the last record doesn't have this logic!
we...
December 27, 2008 at 1:45 am
Make sure that your services are running or just put the dot as servernamen ( . ) and try!
let me know what next!?
December 27, 2008 at 1:29 am
Viewing 15 posts - 541 through 555 (of 789 total)