|
|
|
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 Looking for Str zero padded function Posted by Craig Kenisston at 7/24/2004 11:13:13 PM
Hi,
Is there any function that works like "Str" to convert a number to a string
representation but padding the left with zeros up to the given length ?
Thanks,
...more >>
Studip Question Posted by Just D at 7/24/2004 9:39:16 PM People,
I have a strange question. When I write to .NET newsgroups everybody
recommend me to use as simple queries as possible to do something and work
with data directly in memory. They write me - write a class where you will
retrieve data using as simple query as you can and then work wit...more >>
manipulate this proc without adding cursors? Posted by Alex at 7/24/2004 8:46:02 PM Hello all;
I have the proc below, however it seems that I need to make some changes.
Basically, if a record is already found in the first select, then when inserting into the DonorDonations table I need a different value for the Country. If this is the first time that I am inserting this Donor re...more >>
Need reference for using Nulls in Database -specifically in SQL Se Posted by Novice at 7/24/2004 6:33:02 PM Hey all, I realize that this topic (using Nulls in databases) has been discussed to death and has different performance/design considerations on the various implementations of databases out there. But I would like to get access to some technical documentation on it - specifically for SQL Server and...more >>
SQL beta 2 Posted by Mark Goldin at 7/24/2004 5:42:48 PM What it's going to be released?
...more >>
using or not using VIEW Posted by Viktor Popov at 7/24/2004 5:34:05 PM Hi,
I have the following question. I join 3 tables everytime when I search
something.
Do I have to use VIEW?
Viktor
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.721 / Virus Database: 477 - Release Date: 16.7.2004 a.
...more >>
copying word documents into sqlserver Posted by Thomas Scheiderich at 7/24/2004 4:35:07 PM Is there some other way to move data into an image field in Sql Server other
that textcopy.
I have been trying to get this program working and it will copy some files
into the records and sometimes it won't. In the example I gave in my other
post, I thought maybe the problem might have been t...more >>
SP call SP Posted by Viktor Popov at 7/24/2004 3:39:04 PM Hi,
I have the folloing problem:
I've wrote a SP that returns userid:
CREATE PROC returnid
@USRNAM VARCHAR(20),
@USRPSW VARCHAR(20),
@USERID INT OUTPUT
AS
@USERID = SELECT USERID
FROM USERS U
WHERE U.USERNAME=@USRNAM AND U.USERPASS=@USRPSW
RE...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Querying multiple databases = multiple sets of sprocs? Posted by xs at 7/24/2004 1:56:29 PM Hi All,
I am going to create lots of databases. At the mean time I don't know how
many are there. In could be hundreds to thousands. I am creating an ASP.Net
application to access these database using sprocs. Should I create a set of
sprocs for each database or create only 1 set and execute it...more >>
Concatenate or calculate based on alias names? Posted by Earl at 7/24/2004 1:36:03 PM Is it possible to use the alias result of a concatenation or sum as a value
in the same sp? For example, something like this (which obviously will not
work)?
Strings:
Select Foo+", " + Foo2 as StringConcat1,
Select StringConcat1+", "+ Foo3 as StringConcat2
Math:
Select SUM(F1) + F2 ...more >>
how to insert microsoft word file content into ms sql server Posted by dfccf at 7/24/2004 12:55:02 PM If I have a micrsoft word file somewhere on the server computer. How would I be able to insert the content of the word file into a text field in a sql server database without having to open it up?...more >>
Purpose of Clustered Index Posted by Craig Kenisston at 7/24/2004 11:39:59 AM (MsSQL 2000 Enterprise, Windows 2000 OS)
Hi,
I have a table with about 30 million records, which really has not a good
candidate for clustered index, according to BOL advise.
This table has one Clustered Index based on two fields that are soo repeated
in the table that I think it would be e...more >>
help with an inner join of parent child tables Posted by les at 7/24/2004 11:24:30 AM I have three tables that i want to join: employees,
WorkedHours and Dependants.
the result i want is the info. from employees with the
hours worked and the name of the wife that is in the
dependant table, this table also include children.
Since the table of WorkedHours and Dependants hav...more >>
Help need on column reference constraint with trigger conflict Posted by gazawaymy at 7/24/2004 11:05:31 AM I have two tables with relationship
Test is parent table with testNum as a primary key and class is the child table witch contain testNum as a forgien key. If I try to update the testNum on test and update the testNum in class test, how I do it?
Actually I created a update stored procedure on...more >>
"When" not working properly Posted by Zwi2000 at 7/24/2004 8:33:59 AM Hi,
I have a query that makes a left join to one table, problem is that when I
add a "When" for that table the results displayed are only for records in
which the left join exists and all other records are left out. How can I
change it so that it displays all the other records and those in whi...more >>
Trigger Posted by AQ Mahomed at 7/24/2004 3:19:32 AM Hi
I need to record all changes to my current table automatically to a new
table.
Is this possible with a trigger.
Many Thanks in advance
AQ
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!...more >>
Repeated results in query Posted by Zwi2000 at 7/24/2004 12:14:15 AM I have the query below, problem is that sometimes results are duplicated, I
need to display unique results. In this case "a.id" is the unique Id that I
need to use not to duplicate the records, how can I modify the query to do
this ?
SELECT a.id,a.caseid, b.FirstNm, b.LastNm, e.Processcatalo...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |