Viewing 15 posts - 2,596 through 2,610 (of 3,232 total)
What you are seeing has to do with the scope of your table variable. This will work for sure if you use a global temporary table (##tempTable).
October 25, 2006 at 2:15 pm
When you say that inserting the ASCII code for a CR doesn't work, what do you mean. How are you going about verifying that it doesn't work?
October 25, 2006 at 2:13 pm
declare @decimal decimal(18,10)
set @decimal = 1.7325000000
SELECT SUBSTRING(CAST(@decimal as varchar),1,(CHARINDEX('.',@decimal) + 3)) AS NewUnit
October 25, 2006 at 12:57 pm
Did you get a backup of your registry prior to deleting keys? I would suggest restoring your registry to its previous state and attempt to re-install again. What kind of...
October 25, 2006 at 10:18 am
Query SysIndexes (look in BOL for the columns that you want to display). Join SysIndexes to SysObjects for Table names. I am not in a place where I have access...
October 24, 2006 at 2:05 pm
What happens if the 400 is down or there are network problems between the SQL box and the 400? The INSERT transaction will be held open while the DTS package...
October 24, 2006 at 1:29 pm
I'm not sure if it is possible, but if it is, why would you want to hold a transaction open while a DTS package runs? What are you trying to...
October 24, 2006 at 1:04 pm
declare @count int,
@sql nvarchar(1000),
@tablename varchar(100)
set @count = 0
set @tablename = 'person.contact'
set @sql = 'select @Count = count(*) from ' + @tableName
exec sp_executesql @sql,N'@count int OUTPUT',@count = @count OUTPUT
select @count
October 24, 2006 at 12:17 pm
You cannot use a variable in the FROM clause in a DML statement. You will need to write the SELECT COUNT(*) FROM @StrucCount as Dynamic SQL also.
October 24, 2006 at 11:46 am
You cannot reference a table name stored within a variable without using Dynamic SQL. From the error that you've posted, it appears that you are using dynamic SQL and you may have...
October 24, 2006 at 11:34 am
If your database is not attached to an instance, you can just delete the physical files through Windows Explorer.
October 23, 2006 at 12:37 pm
Thanks for agreeing Jeff, I was starting to feel a little lonely out here. Folks, when seeking new employment keep in mind that you have something to offer to the...
October 22, 2006 at 10:56 pm
Rick,
What Sergiy was getting at is that what you want to do is a poor use of a RDMS. Your main purpose here it to prevent duplicate Client_ID and Code_ID...
October 19, 2006 at 3:44 pm
So if you are currently a DBA and working exclusively on SQL Server platforms, what are you supposed to call yourself? If they feel that it is misleading, then they have...
October 19, 2006 at 3:28 pm
Check the following:
1. Total and Available disk space where your MDF and LDF reside. Also check file system type.
2. Autogrow file property on both the data and log file for...
October 19, 2006 at 2:41 pm
Viewing 15 posts - 2,596 through 2,610 (of 3,232 total)