Viewing 15 posts - 196 through 210 (of 237 total)
thanks Lowell for getting back to me on this
May 25, 2006 at 6:44 am
thanks for answering the question, the only thing is, I've never had SQL Server on the pc in the first place, so there's nothing to uninstall, but I still get...
May 25, 2006 at 1:55 am
Thanks John, it works
May 22, 2006 at 6:26 am
I've tried that Keith, unfortunatly it won't work in the query I've posted below
declare @TmpName as varchar (2000)
DECLARE CUR1 CURSOR FAST_FORWARD FOR
select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'TI_Work_Test'
OPEN CUR1
FETCH...
May 22, 2006 at 4:42 am
Thanks Terry, I've managed to do just that
May 15, 2006 at 2:26 am
that's great, thanks people, I've actually managed to achieve what I need now
May 5, 2006 at 2:14 am
that's exactly what I wanted, thank you Rodney
March 24, 2006 at 4:32 am
many thanks Rama, that's helped a great deal
March 7, 2006 at 2:52 am
I've found this by searching this forum,
exec sp_rename 'dbo.TableName.newcol','OldCol','COLUMN'
what I'd like to do is make a Stored procedure that I can pass in TableName, oldcolumn, newColumn. So it needs...
March 6, 2006 at 5:30 am
Excellant, thanks Karl
January 24, 2006 at 3:57 am
how would that be used with a variable? or am I being thick here?
January 24, 2006 at 2:26 am
Greg, you've actually found out the problem, I've tested the variable and it seems to be growing in length, it has a lot of spaces adding to the end of...
January 23, 2006 at 9:43 am
that you put in your reply is exactly how I've done it
January 23, 2006 at 8:47 am
Many thanks people, it looks like I need to get my head around Joins
January 19, 2006 at 4:07 am
Viewing 15 posts - 196 through 210 (of 237 total)