Consider this example:

declare @table table (T1 text)

insert into @table (T1)

select 'test' + char(13) + ' test2'

select * from @table

In order to 'see' the results on two lines, you must view...

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). 

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?

declare @decimal decimal(18,10)

set @decimal = 1.7325000000

SELECT SUBSTRING(CAST(@decimal as varchar),1,(CHARINDEX('.',@decimal) + 3)) AS NewUnit

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...

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...

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...

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...

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

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. 

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...

If your database is not attached to an instance, you can just delete the physical files through Windows Explorer. 

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...

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...

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...