|
|
|
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 Deleting across tables Posted by -sakkie69- at 1/8/2005 10:24:58 PM Hi there,
If I have to delete from a table which has FK's from other tables, I just
want to confirm the syntax to
delete the table from the "sub" tables first before I can delete from the
main table
ie
I want to delete customers, but they have FK's on the table from orders (who
has an F...more >>
Extrating the Time from DateTime Posted by JT at 1/8/2005 9:33:01 PM Hi,
I am trying to run a sproc that includes the following in the WHERE clause:
AND (ApptTime BETWEEN @StartTime AND @EndTime)
ApptTime is a datetime data type, as are the two variables. When I run the
sproc by explicitly setting the variables, I get the desired results. I
explicitly se...more >>
'SystemObject' property on Login object (SQL DMO) Posted by Ajey Dudhe at 1/8/2005 6:06:49 PM hi,
I am using 'SystemObject' property on Login object (SQL DMO). The
documentation for this property states that 'If TRUE, the database object is
defined by Microsoft as part of an instance of SQL Server.' However, this
property returns true for logins which are member of 'System Administra...more >>
XML Posted by Khurram Chaudhary at 1/8/2005 5:17:46 PM Hi,
Can someone refer me to some articles on how to parse XML data retreived
from a website which then gets input into a SQL stored proc? I'm using SQL
2000 SP3.
Thanks.
Khurram
...more >>
Best Practice Question (Dates and Times) Posted by Brad M. at 1/8/2005 12:54:39 PM I am wondering what is best practice for storing dates and times. Is it
best to store the date in one column, and the time in another? Or is it
best to store them as one column? I ask because I'm designing an
application where they will be querying data based on timeframes for the
same da...more >>
Notavable retrive the data in QA Posted by S Kaliyan at 1/8/2005 11:57:19 AM HI
We are using MS-SQL2000, we used to view the record by using the Auery
Analyser , but today we try to view one record its not able to view in the
QA but its there in the database and to run the Query its take lot of time.
this is my query:
Select * from waybill where waybill_no='31102...more >>
drop multiple columns...then what? Posted by sriehl NO[at]SPAM removethis.insightbb.com at 1/8/2005 11:41:45 AM My team is finally tackling the process of removing some no longer used
fields in one of our main DB tables that has over 4 M rows. The table
currently has about 71 columns in it, we are going to remove about 15
columns of various types from ints to nvarchar.
My question is the following: Wh...more >>
Case and Cast statements Posted by Susan at 1/8/2005 10:33:01 AM Hi,
I have a table. There are three fields, LNID, LNAmt, LNDATE
SELECT CASE LNDATE when'2002-8-20' THEN 'FY2004' Else 'Nothing ' End,
LNAMT
FROM Database.table
What I want to do is enter a range, a between statement for a range of dates
to equal FY2004 and then another ran...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
why i can't debug store procedure Posted by ElaineD at 1/8/2005 5:10:05 AM I programmed a store procedure about 1000 lines,but I
can't debug it .someone may tell how to debug store
procedure.Thanks a lot.
Best wish....more >>
alter table Posted by Ed at 1/8/2005 3:05:11 AM Hi,
I tried the following syntax
alter table tablename add constraint IX_custid nonclustered custid
of course it said error since i may need
alter table tablename add constraint IX_custid unique nonclustered custid
since the custid is not unique, what is the correct syntax to add the ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |