Viewing 15 posts - 31 through 45 (of 514 total)
Chirag (5/26/2008)
Hicreate procedure PositionInsert_sp
as
begin
select 'd'
end
Just for fun, have you tried to alter?
alter procedure PositionInsert_sp
as
begin
select 'd'
end
May 27, 2008 at 11:27 am
Why do we keep talking about scripts. There is no need for one. Go to
Control-Panel -> Administrative tools -> Services...
Find the "SQL Server *" services. the...
May 27, 2008 at 11:23 am
Jeff Moden (5/26/2008)
One thing that you should be made aware of... Unless you're installing the Developer's Edition of SQL Server, it must run on a Windows Server.
Express edition is can...
May 27, 2008 at 11:15 am
I think you misunderstood the comments made by theSQLGuru. No disrepect was directed towards you. You are not the problem here. You are just doing what you...
May 22, 2008 at 8:07 am
I have a question. Are you using 2000, or 2005?
The reason is that the http://support.microsoft.com/kb/902388 matches your issue exactly.
Can you send us exactly what you type when you are...
May 20, 2008 at 6:24 am
Jeff Moden (4/28/2008)[/bIt really would help if the OP would post exactly what output is expected from the input in the original post, though.
I agree with all your points, I...
April 28, 2008 at 7:02 am
Jeff Moden (4/25/2008)
rbarryyoung (4/16/2008)
I am confused. Why isn't robert's answer sufficient?
I agree... why is everyone still looking for an aggegate function and passing columns of data when Robert's very...
April 27, 2008 at 4:48 pm
So here is your "it's the weekend and there are no important games on" assignment.
Sorry, but being from Pittsburgh and a hockey fan, I disagree with that comment. In...
April 25, 2008 at 1:00 pm
Steve,
You asked for a "Good" reason to allow duplicate indexes.
Oracle doesn't allow them. 🙂
April 25, 2008 at 8:57 am
1) ColA,ColB and ColA are not the same, and should be allowed (although this is rare situation)
a) This only makes sense when ColB impacts the size of the...
April 25, 2008 at 5:57 am
"Is it possible...", "How would you change the default...", etc.
There were many ways that this question could have been worded to make this a valid question, but "By Default" is...
April 24, 2008 at 5:53 am
BEGIN TRANSACTION
;WITH tblDesc AS (
SELECT proj_id,
[desc] FROM tblTest
WHERE proj_id NOT LIKE '%.%'
)
UPDATE tblTest
SET [desc] = tblDesc.[desc]
FROM tblTest
INNER JOIN tblDesc
ON SUBSTRING(tblTest.proj_id,1,LEN(tblDesc.proj_id)) = tblDesc.proj_id
WHERE...
April 21, 2008 at 7:30 am
The issue here is a bad design.
Basically what you are calling the top level project should be a table of it's own.
In fact you should have at least...
April 21, 2008 at 6:05 am
Of course I found another bug 🙁 Big Floats can't have more that 15 digits precision, however obviously 1E40 won't fit in a bigint. oops. Sorry, going...
April 18, 2008 at 2:46 pm
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [BigMoney]
(
@value float
)
RETURNS VARCHAR(500)
AS
BEGIN
DECLARE @numreal BIGINT, @num BIGINT,
@Result VARCHAR(200)
...
April 18, 2008 at 2:13 pm
Viewing 15 posts - 31 through 45 (of 514 total)