|
|
|
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 help me with this Stored Proc Posted by Duong Nguyen at 9/23/2006 10:54:19 PM Hello, I have table Inventory (id, inventoryID, productID) and table
Product (productID, parentID, productName) - parentID is the ID of product
group.
.. Now I must create a stored procedure SP_INSERT to do this work:
- parameters to pass: @parentID, @inventoryID
-task: the SP must fill int...more >>
IF EXISTS? Posted by RON at 9/23/2006 9:10:40 PM Consider the following procedure that expects a username & password
(the DB table named Users has 3 columns - UserID which is an IDENTITY
column, UserName varchar(50) & Password varchar(50)):
ALTER PROCEDURE dbo.LoginUser
@UserName varchar(50),
@Password varchar(50)
AS
DECLARE
...more >>
Sql Server Professional Magazine Posted by Tim Zych at 9/23/2006 9:01:28 PM Does anyone here read the magazine "SQL Server Professional" by Pinnacle? I
got a sample copy and it seems really informative and well written. It's
expensive though, but if the whole subscription is as good as the trial
copy, I think it would be worth it.
What do developers think? Is it worth...more >>
When to use scripting tools and when to manually code the script Posted by lmarvitz at 9/23/2006 8:27:00 PM I was wondering when is it best to use tools, such as MS Enterprise
Manager for generating scripts and when are you better off generating
your own scripts? I do like usinf the tools, but I was told that
sometimes these tools can reek havoc.
...more >>
how to get this resultset... Posted by ibiza at 9/23/2006 6:46:00 PM Hi,
I have 3 tables as follow :
Kanji :
kanji_id
....
References :
ref_id
....
KanjiRefs
kref_idkanji
kref_idref
kref_value
....
So, there is a many-to-many relationship between Kanjis and References
(one kanji may have more than one reference type, and a reference type
may ...more >>
sql editor for 2005 Posted by jamesd at 9/23/2006 6:37:48 PM I am looking for a free or shareware program for writing procs and
stuff. I cannot believe that sql 2005 does not come with a good editor
like Query Analyzer. The editor in Studio is severly lacking!
What are serious sql server hackers using to write their queries with
2005??
...more >>
Looking for an optimum way to get 2 result sets Posted by Bogdan at 9/23/2006 5:30:40 PM Let's assume that there are two tables: A and B. Table A contains a column
cb which is a foreign key to table B. There is a many-to-one relationship
between table A and B. I need to select rows from table A based on
[condition] and then select unique rows from table B whose primary keys are...more >>
Can't Drop a Primary Index using SMO Posted by Larry Rebich at 9/23/2006 3:15:49 PM Seems that a Primary Key index creates a constraint. I don't know how to
delete a constraint using SMO.
So you know how to drop a primary key constraint using SMO?
Please don't reply to this posting unless you can provide the SMO code. I
posted this message earlier and someone told me how ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
What Service account to use in this situation? Posted by Mike9900 at 9/23/2006 2:00:02 PM Hello,
I want to install SQL Server 2005 on a computer that does not have network
access, but any user coul log on to the system and use the SQL Server from
the application. Is Loca System account good enough? If so what is the
command to pass to sql setup to do it automatically?
--
Mik...more >>
Setting Windows Service "Local System Account" on Setup Posted by Mike9900 at 9/23/2006 1:47:01 PM Hello,
I need a command which sets windows service log on account as "Local System
Account" when we install SQL Server Express. Is there a command which tell
the installer to set this account and is good for any local?
Unfortunately, setup does not set "Local System Account" by default, a...more >>
wat are temporary tables Posted by santiago at 9/23/2006 11:07:38 AM wat are temporary tables. and why they are used.
...more >>
how can the output from a stored proc be used in a calling stored Posted by WebBuilder451 at 9/23/2006 10:12:01 AM given the system sp sp_columns. can i join the result set of this sp to
another table. Or is it necessary to recreate the query(s) in sp_columns and
join that to the new table.
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes...more >>
Cross-database proc Posted by Greg Pasquariello at 9/23/2006 7:46:00 AM Is it possible to create a stored procedure that exists in one database, but
runs in the context of the database from which I call it?
For example, I want my proc (A.dbo.MyProc) to create table Foo in my new
database X, but I don't know that the database is called X when I create
A.dbo.MyPr...more >>
2005: procedure for concurrent use Posted by RAM at 9/23/2006 12:00:00 AM Hello,
I am learning SQL Server 2005 and I have written a procedure that generates
sequence numer for some documents. I know that the procedure is not correct
because it is used in concurrent transactions. Here is the code:
ALTER PROCEDURE [dbo].[NextDocumentNumer]
@NextNumber decimal(1...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |