Viewing 15 posts - 18,151 through 18,165 (of 18,926 total)
run this in Query analyser and you'll see the problem
Select top 1 * from dbo.SysObjects
Print @@Rowcount
--1
print @@Rowcount
--0
The rowcount variable is reupdated after the print statement. The 2nd time you...
April 12, 2005 at 1:21 pm
Thank god... I was hopping he was wrong cause a few of my backups would have been wrong :-).
April 12, 2005 at 12:10 pm
The table is created then dropped within the exec () statement
try :
set @sql = 'select * into #mytemp from ;
SELECT * FROM #mytemp'
exec (@sql)
April 12, 2005 at 12:09 pm
We're gonna say this one more time. There's no point in mixing both technologies, you either work from sql server or from access, whereever the data is. There's no...
April 12, 2005 at 11:21 am
, SUM(CASE WHEN ConnectTime > 0 and CRC 'ANS' THEN 1 ELSE 0 END) as AnswerCount
April 12, 2005 at 10:08 am
why don't you modify the values with an update statement?
April 12, 2005 at 10:07 am
WHERE work_ord_num LIKE @work_ord_num + '%' AND
April 12, 2005 at 8:50 am
actually it might be the other way around...
In my case I had the id in char because of presentation, once I moved the id to the int column I create...
April 12, 2005 at 7:55 am
I'm no expert in this but you can use the import wizard to find out how :
Right click on the db in which you want to import the data
--...
April 12, 2005 at 7:29 am
exactly... also you should convert it to int (unless it's impossible with the data).
Also even some have disagreed about this I've seen a huge speed improvement in changing my primary...
April 12, 2005 at 7:16 am
name is sysname(128) = 128
number and colid are smallint = 4
Text is nvarchar(4000) = 8000
So you can definitly bust the 8094 limit there. But as John suggested, you can...
April 12, 2005 at 7:10 am
Yes this is prtty much what you had posted a few weeks back... that's what made me realize how much of a killer it can be.
April 12, 2005 at 6:57 am
DTS the tables to sql server and do the work there. Looks like you'r trying to dig a big hole with a spoon instead of using a shovel... ...
April 12, 2005 at 6:53 am
Deterministic udf aren't so bad to use Frank... but I'd agree that some function uses can be devastating on performance.
April 12, 2005 at 6:45 am
Hey Frank, why did you change your avatar??
April 12, 2005 at 6:27 am
Viewing 15 posts - 18,151 through 18,165 (of 18,926 total)