|
|
|
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 Change 1299.99 to 1,299.99 Posted by Ericsson at 8/30/2003 9:36:52 PM Hi All,
Please kindly tell me how to change the number to a format with comma in
store procedure of transact sql.
Thanks in advance.
Ericsson
...more >>
Query Help Needed Posted by Larry Gibson at 8/30/2003 7:03:09 PM Well, guys and gals, here I am again with a problem I can't quite figure
out. Anyone give me a push in the right direction? I have two tables in a
database, one contains a list of services given and the other has a list of
people and their addresses. I've stripped these two down to the essenti...more >>
Updatable Cursor in T-SQL Posted by JB Casse at 8/30/2003 3:08:24 PM Hello,
I am having a problem updating a table through a cursor in
a stored procedure. I think that I am missing some syntax.
It compiles fine and runs without error but my table has
not been updated. I use the following code:
DECLARE patientCursor CURSOR
FOR
SELECT PatientName FROM Fac...more >>
Primary keys for one-to-one tables Posted by Robert at 8/30/2003 1:52:43 PM I am designing a database for storing mutliple types of information
relating to members of a particular medical group. For various reasons
I want to keep the main table with the members names narrow and
therefore need to create a number of additional tables to hold other
information that is in a...more >>
country flags Posted by Arda at 8/30/2003 1:33:53 PM Firstly hi to all,
I have collected countries short names into SQL Country column.(e.g.
US-United Sates, RO-Romania,TR-Turkey).
I want to combine them with the country's flag picture.(e.g.
US.jpg,RO.jpb,TR.jpg)
I mean I want to make a datagrid which shows the Country column with the
flag pic...more >>
2 fk constraint in 1 field Posted by Helena at 8/30/2003 11:42:11 AM I have ONE FIELD in the child refering to 2 parents. So,
for me to enter a value in this child fk field, the value
must exist in BOTH parent. Otherwise I get a fk violation
error message. OK.
However this is what I'm try to do:
If "some_other_field" in the child table = 'X' only
consid...more >>
UDF deoptimizes query Posted by JXStern at 8/30/2003 11:18:48 AM I have code like:
select whatever
from mytable1 t1 inner join mytable2 t2
on t1.x=t2.x and myudf(t2.y)=1
This replaces code that read:
select whatever
from mytable1 t1 inner join mytable2 t2
on t1.x=t2.x and t2.y in (1,3,7,11)
It should be obvious what the UDF does:
CREATE FUN...more >>
problems with simple SQL statement Posted by Branko Kaucic at 8/30/2003 11:18:21 AM Hi all!
I am using c# and MS SQL server and by performing this statement:
CREATE TABLE tabela3 (id INT(10) AUTO_INCREMENT, ARFNRA ARCHAR(2),ARARTA
VARCHAR(20),ARABZ1 VARCHAR(21),ARABZ2 VARCHAR(21),ARGLAG VARCHAR(6),
ARGBAG VARCHAR(30),ARGLLI VARCHAR(6),ARGBLI VARCHAR(30),ARGLWA
VARCHAR(6...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Number generator - how? Posted by Lars Dybdahl at 8/30/2003 10:44:58 AM I'm migrating a database from Borland Interbase and cannot find out how to
create a number generator in Microsoft SQL Server 2000.
I tried the obvious:
create generator mygenerator;
(Generator is the same as postgreSQL's sequence)
As far as I can see, the only thing that can generate un...more >>
Are StoredProcedure ad hoc queries possible? Posted by rooster575 at 8/30/2003 7:15:00 AM I have may places in my web application where a web form is used to query
the database.
I would like to take advantage of stored procedures to make results faster
and overhead lighter, but I don't see how I can use them for these "ad hoc"
style queries.
For example, if you can select:
Regi...more >>
Adding a new populated column in a table Posted by Emu at 8/30/2003 1:00:02 AM Hi,
I added a new column into a populated table and then via
INSERT INTO dbo.tblExpired
(Mod)
SELECT 'TURI'
I tried to populate it with the word TURI but I get this error:
Cannot insert the value NULL into column 'AlreadySaved', table
'Warranty.dbo.tblExpired...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |