Viewing 15 posts - 16,171 through 16,185 (of 18,926 total)
Whereas Celko seems to be more Standard oriented
.
June 27, 2005 at 1:28 pm
are all those files in the same directory??
are the list of files to check for all on the server, or easily transferable?
June 27, 2005 at 1:22 pm
A self join as you said will do it :
Create table X
(
Name varchar(25) not null,
Ident int null
)
GO
Insert into dbo.X (name, ident)
Select 'a', 3
UNION ALL
Select 'b', null
UNION ALL
Select 'd',...
June 27, 2005 at 1:20 pm
Why waste time when a good rant is already out...
So what about your opinion Noeld?
June 27, 2005 at 12:55 pm
Here's one of many :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=152846
June 27, 2005 at 12:45 pm
What will the new column data mean?
Whyuse a random number in there (seems wrong from a design perspective)?
June 27, 2005 at 12:23 pm
That's one way of doing this... What problem r u trying to solve with this??
June 27, 2005 at 12:06 pm
just drop the column with all the nulls in it then recode this script :
ALTER TABLE YourTableName
ADD attribute_id int identity (1,1)
June 27, 2005 at 11:48 am
Happy we could help. Did the query came back to the previous speed, or it just leveled at an in-between speed?
June 27, 2005 at 11:42 am
Use the function whereever you need it like so :
Select id, dbo.ListTableColumns(id) as LinearColumns from dbo.SysObjects where XType = 'U'
June 27, 2005 at 11:39 am
Unless you're planning to go international, I don't see why.
However the programmer has a good point. If at some stage, you need to store japanese text, you'll have to...
June 27, 2005 at 11:38 am
Create table X
(
Name varchar(25) not null
)
GO
Insert into dbo.X (name)
Select 'a'
UNION ALL
Select 'b'
UNION ALL
Select 'd'
UNION ALL
Select 'e'
UNION ALL
Select 'c'
UNION ALL
Select 'g'
GO
Select * from dbo.X
GO
ALTER TABLE X
ADD Ident int identity (1,1)
GO
Select...
June 27, 2005 at 11:34 am
Viewing 15 posts - 16,171 through 16,185 (of 18,926 total)