|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 August 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 stored procedure syntax help Posted by anjelina at 7/13/2003 10:27:47 PM When I run the following stored procedure I'm getting the
following error return:
Server: Msg 201, Level 16, State 4, Procedure
ldman_proc1, Line 0
Procedure 'ldman_proc1' expects parameter '@em_date',
which was not supplied.
CREATE PROCEDURE dbo.ldman_proc1
@em_date nvarchar(10)
...more >>
Replace Spaces in field data with underscores Posted by dmontgomery NO[at]SPAM datatown.com at 7/13/2003 9:56:44 PM I need to replaces all occurances of spaces between words with
underscores for all text data in a database field called company_name.
Can this be done inside access using an SQL statement?...more >>
SQL statement to replace spaces between words with underscore Posted by dmontgomery NO[at]SPAM datatown.com at 7/13/2003 9:34:11 PM Is there an SQL statement that will replace spaces between data in a
text field. The field name is company_name and I need to replace all
occurances of spaces in the company names with underscores....more >>
Single quote (') problem in SQL Server query Posted by Ben at 7/13/2003 7:41:33 PM I am trying to run a simple select query but it bombs out
because one of the fields may contain a single quote
character. The field is a street name field and streets
starting with "O'" bomb out. When there is no single
quote, the query works fine.
Here is my query:
Set tmpRSet2 = ...more >>
Cannot trap error returned by stored procedure in SQL Server 2000: Suggestions? Posted by drdeadpan NO[at]SPAM yahoo.com at 7/13/2003 7:30:31 PM I created two procs in Query analyzer as follows.
DROP PROCEDURE insjobs
GO
CREATE PROCEDURE insjobs
AS
INSERT INTO venkatpk values (1,'joe')
IF @@error <> 0
RETURN 88
GO
DROP PROCEDURE insjobsparent
GO
CREATE PROCEDURE insjobsparent
AS
DECLARE @err INT
BEGIN ...more >>
UserDefined Fuctions and SQL Posted by Trent at 7/13/2003 5:53:32 PM Does anyone know how to insert or update inside a user-
defined function, or have any advice on ways around this?
Trent...more >>
SQL Server 7.0 & Enterprise Manager Posted by Darren at 7/13/2003 4:07:51 PM I am a newbie to SQL Server and am embarking on a project to create a
database.
Whilst I am still to learns the ways of Transact-SQL (learning courses
pending), I decided to create the relvant tables via the Enterprise Manager.
One problem I do have is how can I set the default value of a Da...more >>
How to combine date strings with text Posted by hk4ac NO[at]SPAM hotmail.com at 7/13/2003 3:27:31 PM I am transferring an Access database to SQL Server 2000 and running
into trouble creating the same 'combination' fields in the SELECT
statement. The Access database calculates the number of days from an
order start date and then adds the static text "days" to the end. The
output should include t...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Is it possible to query a prior query? Posted by Peter Olcott at 7/13/2003 3:05:34 PM Is there some way to save a selection set in SQL
so that another SQL query can further refine the
prior query?
...more >>
Windows 2003 WEB Edition? Posted by Jason Davis at 7/13/2003 9:54:24 AM Hi there,
I'm about to install a new MS server and I'm still unsure wheter to go with
the Web or Std. edition of 2003.
The server includes both mssql server 2k (standard) AND IIS. I also need
DNS/FTP services and terminal server access.
There are 2 cpu, and 1gb of ram.
Any considerations...more >>
Select the rows which are implicated in an not committed update command Posted by Lucian Secara at 7/13/2003 7:21:41 AM Table Test(id bigint,
name varchar(55)) and contains:
1 Linda
2 Tom
User A:
set transaction ISOLATION LEVEL READ COMMITTED
begin tran
insert into Test(name) values('John')
User B:
set transaction ISOLATION LEVEL READ COMMITTED
begin tran
update Test set name='Mary' where ...more >>
@@error is driving me nuts. Please help me gurus! Posted by drdeadpan NO[at]SPAM yahoo.com at 7/13/2003 7:01:01 AM Hi,
I have a stored procedure (SQL Server 2000) that has the following
form.
CREATE PROCEDURE ins
AS
INSERT INTO TABLE A VALUES (...)
IF @@error = 2627
PRINT 'OOPS'
GO
Now when I insert duplicate recs, I should just get the message OOPS.
This does not seem to happen, though...more >>
@@error not trapping errors? Posted by drdeadpan NO[at]SPAM yahoo.com at 7/13/2003 7:00:47 AM Hi,
I have a stored procedure (SQL Server 2000) that has the following
form.
CREATE PROCEDURE ins
AS
INSERT INTO TABLE A VALUES (...)
IF @@error = 2627
PRINT 'OOPS'
GO
Now when I insert duplicate recs, I should just get the message OOPS.
This does not seem to happen, though...more >>
SP returned recordsets Posted by Saul Bryan at 7/13/2003 6:43:32 AM Hi all,
I have a stored procedure which has a number of select and insert statements
in it. It is used to insert records in a number of tables. The last select
statement returns a single row, which I want to use as a kind of returned
parameter. I call this stored procedure from some ASP code u...more >>
SP_OACreate Posted by Venugopal Vemuri at 7/13/2003 6:14:49 AM Hi,
We have a web server say "server1" and a database server
say "server2". I have installed a DLL say "test.dll" as
a COM+ component on server1. The test.dll has also been
registered on server2. test.dll is a vb6 dll. How do I
use SP_OACreate to instantiate test.dll from server1 from
...more >>
Summing time...... Posted by Paul Aspinall at 7/13/2003 12:52:34 AM Hi
I have a field which is a Date/Time field....
It actually only makes use of the Time portion, and this holds a duration of
an activity....
However, I want to have a query which returns the total duration of all the
times in the records.
Is there an easy way, to SUM date/time fields (or ju...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |