|
|
|
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 31 Getting record identity Posted by Larry Bird at 7/11/2004 10:57:02 PM I am trying to retrieve the identity of a previous inserted record. I’m using the Scope_Identity in my stored procecedure as follows:
CREATE PROCEDURE dbo.InsertEventCriteria @VehicleMinNum char(10), @AlertCategory char, @ReportingFrequency int, @ConfirmRFStartDate char(10), @ConfirmRFStart...more >>
MS Access to SQL Posted by Claudiney at 7/11/2004 10:45:43 PM Hi folks, I've been trying to transfer some ms access projects to SQL SERVER
2000 and I'm facing some challenges.
In ms access I have one vba code where I open one recordset with thousands
of records and loop until the EOF is found.
Each Item in the recordset is used as a paramter to insert data...more >>
Store Procedure learning Posted by Thomas Mulja at 7/11/2004 8:26:18 PM Hi guys,
Did you guys know where I can get / find the sources to
learn the store procedure programming in sql ? from the
basic one to advance
thanks guys,
...more >>
Query performance Posted by Claudiney at 7/11/2004 7:27:44 PM Hy folks I'm looking for a fast way to run one query to return the Top 3
Months for each item in one table.
Lat's say I have one table like the bellow one:
HRREFM HRPRIT
200406 H0000134900
200405 H0000134900
200404 H0000134900
200403 H0000134900
200403 H0000144164
200402 H0000144164
200312...more >>
SQL Newbie - defaults for a date field Posted by Karl Middleton at 7/11/2004 6:54:39 PM Hello NG,
I am a newbie to SQL so forgive me for asking a dumb question.
Have created a table via SQL Enterprise Manager that has a date field with
data type datetime, field length 8, and nulls ticked.
In design view we are trying to set the default to today's date. How do we
do this?
...more >>
Identifying SP Returned Fields Posted by Wayne Wengert at 7/11/2004 5:50:24 PM I have a SP which Selects the data for a requested user from our main table
of members as well as the data from several OUTER JOIN tables. These other
table have a nameid field (basis for the join) and two bit fields indication
the type of involvement for the user ("A" and/or "B"). (see sample be...more >>
How to backup EM configuration? Posted by Willianto at 7/11/2004 5:30:09 PM Hi all,
I am planning to format my laptop. In my laptop, I have SQL Server
Developer Edition, and I use to utilize the Enterprise Manager to
connect to my client's SQL Server instance. Thus, in my laptop's EM,
there are lots of SQL Server registration (about 20 registrations).
QUESTION:
Ho...more >>
dynamic sql statement build error Posted by Rea Peleg at 7/11/2004 3:39:13 PM Hi all
I would greatly appriciate your help in resolving the following error:
In t-sql procedure I am building a simple dynamic sql statement using
parametes.
Here is the code:
===========
step 0 - declare local variables:
-------------------------------
declare @localParam as datetime
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How do I put =, >, <, etc. in a variables so I can change from one to another based on criteria? Posted by Dave Rognlie at 7/11/2004 11:23:05 AM
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!...more >>
How do I put =, >, <, etc." Posted by Dave Rognlie at 7/11/2004 11:23:00 AM
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!...more >>
[Newbie] Extracting a Distinct Record Based on Several (But Not All) Fields of a Record Posted by Don at 7/11/2004 11:17:30 AM I am trying to compensate for a weak DB design (it WILL be fixed! -- later)
with this one:
My table has a UserID, EMailAddress, AddressStatus ('Work', 'Home', or
'School'). For any given UserID, there should be only one e-mail of given
address status (e.g. only one 'Work' address). Unfortuna...more >>
Auto-inc question Posted by Steve at 7/11/2004 8:20:26 AM Hi all,
I have discovered that when using an auto-inc field in a
table, the value will increment even if a new record
insertion is unsuccessful.
Say for instance the last value of the auto-inc field was
10. The user tries to insert a new record and it is
rejected by the server (for in...more >>
Meta data of query? Posted by lxc NO[at]SPAM eosys.ie at 7/11/2004 4:14:42 AM Hi,
Take a typical query...
SELECT col1 as "my_first_name"
,col2 as "my_second_name"
,col3 as "my_telephone_no"
FROM personal_details
WHERE col2 = 'Caffrey'
When this is run in Query Analyzer or the SQL Window of EE, the column
headers are automatically given in the resu...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |