|
|
|
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 Storing word docs in sql2000 Posted by vishal at 8/31/2003 10:43:05 PM Hi
Can you please tell me how to store the word documents in
a table using SQL 2000. I also want to search with in teh
documents.
I will be very thankfull if you can provide some code for
doing this.
thanks
Vishal...more >>
CURSOR FOR statement Posted by Ragu at 8/31/2003 8:23:59 PM Hi All,
Can i use the cursor to join the Query statement like a
table.
Please see the following codes
DECLARE XYZ_cursor CURSOR FOR
SELECT ID, Lname, FName FROM XYZ
OPEN XYZ_cursor
SELECT A.Company, B.LName, B.FName
From ABC A, XYZ_Cursor B
WHERE A.ID = B.ID
After run the codes, i...more >>
How about adding an identity column for each table? Posted by Edward Yang at 8/31/2003 8:08:14 PM We are developing a database project using ASP.NET/VS.NET.
The database ends up with more than 200 tables!!!
We have a headache here. In many cases we have to modify
the values of primary keys (the customers ask for this)!
The original design did not include an identity column for
each ta...more >>
newbie backup question II Posted by mark bixby at 8/31/2003 7:40:23 PM I've been trying to configure a method to backup a single
filegroup within our database but cannot get it to
restore properly (db lands in 'loading' mode after a
restore). The backup appears to work fine:
BACKUP DATABASE mydb
FILEGROUP = 'USERINFO'
TO backupUserInfo
BACKUP LOG Asy...more >>
ConvertSeconds to HH:MM:SS format Posted by Anand at 8/31/2003 7:23:55 PM Hi all
Is there a built-in function to convert the seconds to
HH:MM:SS format?
Any sample script to do this???
Thanks in advance.
Anand.
...more >>
select query with group by Posted by priti at 8/31/2003 6:49:38 PM Hi ,
I want to do something like this, i.e. select all the
rows based on this criteria.
select * from contract_selection
group by lastname,fname
having count(*) =3
Thanks for the help.
...more >>
Reset id Posted by Arjen at 8/31/2003 6:24:36 PM Hello,
I can't remember the command any more. ;-(
I have a table with an id field. The next record id will be 233.
Now I want to reset this to null.
How can I do that?
Thanks!
...more >>
Converting varchar to float Posted by vansick NO[at]SPAM gmx.net at 8/31/2003 5:10:23 PM Hi!
I'm using the following code in a stored procedure:
'A' = CASE
WHEN B > 0 THEN B
WHEN C is not null AND ISNUMERIC(C) = 1 THEN Cast(C as float(1))
END
The procedure results in the error: 'Error coverting data type varchar to float'
I used isnumeric(C) to ensure that only numeric va...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Assignment in dynamic queries Posted by LIN at 8/31/2003 3:51:51 PM Hi
I have a problem
actually i want to assign a value to a variable using a dynamic query.
How can i do this.
Declare @SqlString as nVarchar(3000)
Declare @Tot as Float
Declare @CompanyId as Varchar(3)
Select @CompanyId = 1
Select @SqlString = 'Select Sum(ReceivedAmt) from Receivables...more >>
Day of the week Posted by Davef at 8/31/2003 2:37:39 PM How do you pull the day of the week out of a smalldatetime field
--
______________________
David Fetrow
HelixPoint LLC.
http://www.helixpoint.com
davef@helixpoint.com
Interested in Affordable Email Marketing?
Check out the HelixMailer at http://www.helixpoint.com/helixmailer.asp
If y...more >>
getdate Posted by Aurelio at 8/31/2003 2:01:42 PM hello!!
thank you for your answer but I couldn't get that...
I know that I'm giving back both date and time through a SQL function called
"getdate()"
ex: date() 2003-8-31 data type (datetime)
time() 14:30:00 data type (datetime)
my question is: how can I have both date and time t...more >>
question Posted by u50415039 NO[at]SPAM spawnkill.ip-mobilphone.net at 8/31/2003 5:27:59 AM #temptable got order,fname and age.
trying to find two high maxes per each order.
query returns (1) but (2) is correct answer.
supposedly, max(age2) < max(age1).
****
select d.order,case d.t when 1 then s.fname else null end as fname,
case d.t when 1 then s.age else null end as age1,
case d....more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |