|
|
|
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 |
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 Stored procedure, ntext output parameter Posted by Dmitry at 6/20/2004 10:09:23 PM Hello all
I have a problem that seems trivial but I can't seem to solve it. Lets say I
have a table called Notes with 2 fields:
ID - integer
Content - ntext
I would like to write a stored procedure that take an ID as input parameter
and returns the corresponding content as an output para...more >>
need help to create query Posted by Daniel at 6/20/2004 6:05:27 PM hi,
I had a table like below:
id status
----------------------------
82 N
82 N
83 N
83 Y
83 N
81 N...more >>
A silly question ... just to clarify my concepts Posted by Learner at 6/20/2004 4:15:52 PM Hi,
I have the following tables:
CREATE TABLE [tblGeography] (
[ZoneID] Int,
[ZoneName] [char] (10),
[StateID] Int,
[StateName] [char] (35),
[CityID] Int,
[CityName] [char] (50)
)
CREATE TABLE [tblCustomers] (
[CustCode] [varchar] (20) ,
[CustName] [varchar] (64),
[City...more >>
Checking "over 8060 INSERT fail" error Posted by TomTom at 6/20/2004 2:10:28 PM Hi,
I created a table that can potentially exceeds the maximum row byes of 8060.
When I created that table, the following warning is displayed in the Query
Analyzer.
Warning: The table 'EDB' has been created but its maximum row size (9875)
exceeds the maximum number of bytes per row (8060)....more >>
annual period Posted by Frank Dulk at 6/20/2004 1:34:49 PM Hi, personal!
Following: I am with a consultation in SQL and wanted to know if you can me
to say if it is possible to do the following:
I have a value and a date for this value
Valor Data
2.000,00 15/04/2004
1.500,00 15/05/2004
200,00 15/07/2004
The data are in a table. gives to gene...more >>
@@Identity e DEADLOCK Posted by Frank Dulk at 6/20/2004 1:32:25 PM Personal,
It always used the following command for the field autonumber to come back
in a base sql server:
CodAutoNum = Conex.Execute("Select @@Identity From " & Tabela).Fields(0)
However I noticed that when two routines (different users) they tried to
recover this value of the same ta...more >>
primary key or UNIQUE constraint error when trying to setup Relationship Posted by standish22 NO[at]SPAM hotmail.com at 6/20/2004 1:22:35 PM OK. I have the following tables with their primary key fields listed.
COMPANY (C) COMPANY_BENEFITS (CB) EMPLOYEES (E) DEPENDENTS
(D)
--------------------------------------------------------------------------
CompanyID CompanyID CompanyID CompanyID
...more >>
Need Update Trigger Example Posted by Ted Grier at 6/20/2004 9:24:19 AM I need help creating a super simple UPDATE TRIGEER.
The goal is to update a primary table dbo.Orders when
shipping data is appended to a table dbo.FEDEX_SHIP_DATA.
The following trigger code does not work:
CREATE TRIGGER [POST_FEDEX_INFO] ON [dbo].FEDEX_SHIP_DATA
FOR INSERT
AS
UPDATE Ord...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Constraint Question Posted by WJ at 6/20/2004 9:18:52 AM I have three tables, User, Profile, SubProfile
The User table has UserId (PK), ProfileId (FK), and SubProfileId (FK)
(others omitted for this discussion)
Profile table has ProfileId (PK), ProfileName
SubProfile table has SubProfileId (PK), ProfileId (FK), SubProfileName
For each profile, ...more >>
Invalid Object when two users with same named table Posted by Ricardo at 6/20/2004 8:27:47 AM Because I can't see my posted message I'm repeating it.
Please ignore previous one.
I need each DB user to have their own table, let's call it T1.
I use a SP to Drop if exists, Create and fill T1:
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id N'T1') AND
OBJECTPROPERTY(id, N'IsU...more >>
Please help: Case statement Posted by paulsmith5 NO[at]SPAM hotmail.com at 6/20/2004 7:21:46 AM Hi
Regarding the case statement, is it possible to include an OR in the
WHEN clause. For example rather than having to do
SELECT @Continent =
CASE @Country
WHEN 'India' THEN 'Asia'
WHEN 'Brazil' THEN 'South America'
WHEN 'Argentina' THEN 'South America'
ELSE '...more >>
Simple view with CASE Posted by Bent Lund at 6/20/2004 6:37:39 AM Hi,
I need to convert a bool value in a table to a text.
Baiscally, I want the view to show all fields in the table PROCESS_DATA,
but for the boolean field PROCESS I need the View to show that as "Yes"
or "No" as a character field.
The reason for this is that I use VB6 Data report, which...more >>
Please help: Assign results to variables Posted by paulsmith5 NO[at]SPAM hotmail.com at 6/20/2004 6:21:24 AM Hi,
Is it possible to assign the result of a select statement that returns
more than one value to individual local variables within a stored
procedure. For example
Rather then having to do
DECLARE @Firstname NVARCHAR(100)
DECLARE @Surname NVARCHAR(100)
SET @Surname = (SELECT Surname F...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |