|
|
|
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 DTS book... Posted by Sender at 9/14/2003 11:36:31 PM Could anyone please suggest me a good book on SQL DTS (for beginners /
advanced users).
Thanks.
...more >>
Differing results for same query using sp_executesql Posted by Brandon Lilly at 9/14/2003 10:07:35 PM I have the following query that returns the value 6:
DECLARE @RangeStart int
DECLARE @RangeEnd int
DECLARE @DocTypes varchar(4000)
DECLARE @DocGroups varchar(4000)
SET @RangeStart = NULL
SET @RangeEnd = NULL
SET @DocTypes = ISNULL('2', '0')
SET @DocGroups = ISNULL('0', '0')
SELECT COU...more >>
Group by distinct? Posted by Pejo at 9/14/2003 7:25:50 PM OK I'm having a brain fart...I've been off the SQL too long and doing stupid
flash programming.
Anyways here's kind of what I want to do.
Select Item, count(distinct item) group by item.
this should be so easy.
but I my brain is jelly today.
...more >>
managing log size in SQL Posted by LIN at 9/14/2003 4:15:35 PM hi,
I have written an application which runs as a service on the server and has
1000s of transaction (select, update, delete etc.) every day. I just noticed
the log recording these transaction has grown to 11 GB.
Is there a way I can manage or avoid this? or is it the SQL administrators
job...more >>
Strange problem with views Posted by NiitMalad at 9/14/2003 3:11:35 PM Dear Friends
I am working one function for the commission calculation
which is based on the view XYZ which is exact replica of
the table XYZ form the database 'A'
In the View XYZ there is one column Num which can have
value 1 or less say 0.5 as for commision i need the
records which ar...more >>
The FREE .Net Framework means NOTHING IF SQL SERVER........... Posted by nospam at 9/14/2003 2:14:53 PM SQL Server is easy to use....
Yet, "Easy-to-Use" is NOT IMPORTANT if it's not "Easy to AFFORD".....
Moreover, those who need it to be easy to use (those who don't have a
Fortune 500 IT staff)...need it to be easy to AFFORD.
***THE CATCH 22 ***
What good is a Free .NET Framework and a lo...more >>
forget the name of the sp which automatically starts other procs Posted by kamla at 9/14/2003 1:29:54 PM ...more >>
select query Posted by teena at 9/14/2003 1:20:41 PM Hi ,
here is what I need.
create table xx( ---f1,f2,f3 forms the PK.
f1 char(10),
f2 char(10),
f3 char(10))
insert xx values('a','s','z')
insert xx values('a','s','p')
insert xx values('a','p','s')
insert xx values('b','s','z')
insert xx values('b','s','p')
insert xx values('b','...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Getting the output of a stored procedure in a VBScript Posted by fouad me at 9/14/2003 12:21:37 PM I am running a stored procedure that needs parameters through a VBScript and
I need to know to get the output from that procedure to a variable in the
script.
Here is how am I calling the stored procedure:
Dim cnn
Set cnn = CreateObject("ADODB.Connection")
cnn.Open "Provider=SQLOLEDB;Data So...more >>
SQL DMO in .NET Posted by LIN at 9/14/2003 10:44:30 AM is there an .NET equivalent of SQLDMO ?
ideas please.
thanks!
LIN
...more >>
printing the relationship diagram Posted by Ran BD at 9/14/2003 10:42:45 AM how can i do that ?
...more >>
How to set up server login and database user to allow a user to connect. Posted by mariah at 9/14/2003 10:05:55 AM I create a new server login in Enterprise Manager and
added that login to be a user of his default database. I
tried to connect as this user to a server and his default
database within a C# program. HOwever the
SqlConnection.Open always created a "xxx user login
failed" SqlException. did I...more >>
Help: Drop Column-Default Objects Named by MSS Posted by bonzo at 9/14/2003 8:21:57 AM I have an MSS 6.5 design where I have explicitly named all DB objects
(tables, triggers, checks, etc) except for some column defaults. These dozen
or so column defaults were all implemented with Alter Table commands such
as:
ALTER TABLE tbl_name ADD DEFAULT 'N' FOR col_name
I know that MSS ...more >>
Identifying Values Used in Foreign Keys Posted by Wayne Wengert at 9/14/2003 7:16:38 AM Is there a way to determine if the PK in a master table is used as a Foreign
Key in any related tables? I have a set of ASP pages in which the user can
Delete rows in the master table. If the row the user is trying to Delete is
used as a FK in a related table I want to catch that, and if possible...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |