Forum Replies Created
Viewing 15 posts - 286 through 300 (of 5,356 total)
-
RE: Alter table, Add column in PK
Something along these lines
use tempdb
create table comp
(
c1 int not null
, c2 int not null
constraint pkcomp primary key(c1,c2)
)
insert into comp values(1,1)
alter table comp
drop constraint pkcomp
go
alter table comp
add c3 int null
go
update comp...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: TEXT Entries Into Separate Fields
I would do this in some front end scripting language. That's much easier.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Using CREATE ALIAS and SELECT together
No, I just thought that it might be AS related, because I am not aware of CREATE ALIAS in T-SQL.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: INNER JOIN versus JOIN
Farrell, you did nothing wrong. That's exactly what I meant with little annoaynce. Not that one should specify JOINs hints as normal way of doing business, but when you specify...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Using CREATE ALIAS and SELECT together
Aah, I see. I thought that it might be Analysis Services related, but then I saw you've posted it in the T-SQL section.
Sorry, i have no experience with RS...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Question of the Day for 23 May 2005
"Should you install SP4 on your production servers that use AWE?"
Do you intend to use AWE after installing SP4 or not?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Using CREATE ALIAS and SELECT together
CREATE ALIAS in SQL Server?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: INNER JOIN versus JOIN
Farrell,
AJ already mentioned that INNER JOIN is the default JOIN type. Try this
USE PUBS
SELECT
r.royalty
, t.title
, t.type
, t.price
FROM
roysched r
INNER JOIN
titles t
ON
r.title_id = t.title_id
ORDER BY
r.royalty
SELECT
r.royalty
, t.title
, t.type
, t.price
FROM
roysched r
JOIN
titles t
ON
r.title_id =...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Learning and Understanding SQL
Ken Henderson's books are probably the one's I've learned the most from. And, yes, I confess, I really, really like "SQL for Smarties" by Joe Celko.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: About IMPORT and EXPORTS
See if this helps: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: How to script Indexes on SQL server DB?
Can you post it here?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Moving SQL Server!
See if this helps: http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: SPROC execution very slow
Run Profiler to see what going on there.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Goodbye Microsoft, Hello Oracle
http://www.orafaq.com might be a start. At least they have an active mailing list, that helped me getting started.
Good luck!
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: SQL CHAR field question
http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 286 through 300 (of 5,356 total)