|
|
|
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 How to concat select results in SP Posted by David Scemama at 12/18/2004 9:49:24 PM Hi,
I would like to write a stored procedure that select all the values of
one column and concatenate them to produce an output string.
something like
select %names = ConcatAllTheValues(name+";") from myTable where age=3
I'm sorry if the question may seem stupid, but I'm not an expert ...more >>
How to GET The Name of the Default? Posted by Prabhat at 12/18/2004 7:50:01 PM Hi All,
Is there any way we could find out the NAME of the default that is binded to
a column on a table?
Ex: -
Create Table EMP
(
EmpID int identity(100, 1),
ename varchar(25),
sal decimal(18,2) default 0
)
So Here How Do I find the Name of the...more >>
GUI principals - design forms for add new record, modify record Posted by SÁRINGER Zoltán at 12/18/2004 6:54:55 PM Hello,
When you want to create/modify master-detail records, what are the most
practical ways? (For example: having partners, and each partner has some
sites, contacts, discount prices.. etc)
I know two methods, please complete the variatons of yours:
1) press "new": read and edit all dat...more >>
Subtotal Posted by Rick at 12/18/2004 5:20:35 PM I have what I am sure is not too hard but for the life of me I cannot think
of how to do it or I am not sure if it can be done with a single SQL stament
any help would be most apreshated.
In the invoice header table it has a field called Subtotal and I need to
update this field from a sum of t...more >>
SQL Server 2005 Service Broker, transactions & scalability Posted by Klaus Aschenbrenner at 12/18/2004 4:31:22 PM Hi!
I'm currently reading through some whitepapers of SQL Server 2005 Service
Broker. It seems that this will be a very great technology to build
scalable, robust and asynchronous database applications. Currently I've one
questions that concerns me a little bit:
As far as I have read a new ...more >>
2 tier vs 3 tier Posted by Murphy at 12/18/2004 4:16:47 PM I am currently in the early stages of developing my 1st web app and have
noticed some discussion about the advantages of a 2 tier approach as opposed
to 3 tier.
I see an obvious advantage of 2 tier being that one could change db engine
with minimal fuss however you forfeit the advantages of st...more >>
Self-join question Posted by TomTom at 12/18/2004 11:38:19 AM Hi,
I have a "employee" table that has the employee ID column and the manager ID
column. I need to show a table that shows all the employee names and all the
managers names up to the president of the company in one row. Each row shows
one employee's personal information and the managers' na...more >>
ALTER TABLE ADD ... Posted by bill_morgan_3333 at 12/18/2004 10:31:03 AM Friends,
I am adding a column to a table in SQL Server 2000, and I prefer working
through Query Analyzer whenever I can.
QUESTION: Is there a way, in the TS_SQL "ALTER TABLE ADD" syntax, to define
where (what position) in the table I want this new column to appear? Or do I
have to do th...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
dif backup** Posted by maryam rezvani at 12/18/2004 9:17:43 AM Hi
I've a database called db1(full recovery model) which is a large database ,I
backed up a complete backup and then (when some activities happened there) I
backed up a differential type,
now I imagine there's a crash and I want to restore my db,I guess I should
restore the full one at first ...more >>
Restoring DB** Posted by maryam rezvani at 12/18/2004 9:00:33 AM Hi
I restore my db backup in different station by following the same steps .but
in some of
them it restores successfully and in the others folowing error appearred.
(my db is in
full recovery model and it's backup size is about 450mg and it's .mdf and
..ldf files
are about 450mg and 6gig in...more >>
Query Question Posted by AGB at 12/18/2004 8:31:38 AM I have a table that has a column of paths that look like:
\\developmentserv\mapped\share
I am trying to run a query that will just return the \share portion
when I select that row. Not sure how to get SUBSTR to recognize the
last instance of the \ character.
Thanks
...more >>
Which Approch is Better ??? Posted by AM NO[at]SPAM Yahoo.com at 12/18/2004 7:39:22 AM Dear Guys
I have tables like customer, supplier, item, salesman etc (master files) on
my invoice entry form (VB) which approch is best (using ADO 2.6)
1. when client enter a invoice the current customer/supplier/salesman/item
etc I should use recordset of tabes & use find method (all records...more >>
Performance trouble with insert-select, any suggestions? Posted by versteijn NO[at]SPAM 538mail.nl at 12/18/2004 5:10:49 AM Dear all,
I am having enormous performance trouble with an insert-select from a
large table. I am trying to merge data from two tables from another
(old) database into this one:
1. I copy all customers from old database to new
2. I delete all duplicates from it
3. I copy related data for non...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |