|
|
|
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 August 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 select statment with wrong sytnax Posted by Agnes at 7/25/2004 11:34:52 PM select (sealno + trim(unit) ) as key from myTable
I need to have my key , however, i need remove the space in "unit" field and
i can't use trim..
What should I do , thanks
From agnes
...more >>
Business Rules Posted by Eddie Pazz at 7/25/2004 11:23:16 PM I have some business rules that I need to enforce before committing data.
Normally I do this in my business objects. The analyst wants to implement
the rules through sprocs. I have created a sproc for insert and one for
update. My problem is that some rules apply when inserting and when
updating...more >>
SQL Query to link three tables Posted by Justin at 7/25/2004 10:22:39 PM I have three tables, in which all tables have a common column. This column
value is unique only on first table. Second and third table does not have
any other common column.
I want to link all three tables using outer join, as shown below
table1.columnA = table2.coulmnA AND table1.columnA = ...more >>
How to return all view names that begin with "vwX" Posted by rob at 7/25/2004 7:16:22 PM What is the SQL to return the name of all the views in a database that begin
with "vwX" ?
Thanks
...more >>
Reference Question Posted by Eddie Pazz at 7/25/2004 4:20:14 PM I have a database that I use for the company's employees. As we develop more
applications, we're finding that we're referencing these tables from other
databases. In those new databases, I maintain RI using triggers (check to
see if the employeeId exists in the employees table). This works great ...more >>
Newbie: Deploying vb.net Console Application Posted by Bari at 7/25/2004 3:19:07 PM I have just created my first console application, and wish to deploy it.
I would like to have it scheduled as a task to run from a SQL server 2000
job. What is required for this?
The app. consists of 3 simple modules: There are data connections to SQL
server, as well as data readers in the...more >>
MCDBA question Posted by Mike at 7/25/2004 2:04:38 PM Hi all,
I just passed 70-228 and 70-229,
I think there are one more core exam and one elective exam I need to take,
right?
Is there an exam that can use one stone to kill two birds? meaning that
take 3 exam instead of 4 exam to get
MCDBA certification.
...more >>
Delete from 2 tables and search Posted by Viktor Popov at 7/25/2004 12:43:35 PM Hi,
I have the following problem.I have 3 tables:
User
-------
userid username pass addr
Offer
----------
offerid userid(FK) estateid(FK) price rooms
Estate
-----------
estateid city phone addr date ...
When I delete a user I would like to delete ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
bulk insert Posted by ori at 7/25/2004 3:07:47 AM Hi all,
I'm trying to do bulk insert to text file I have.
I have a problem with the raw terminator that is wrong.
In DTS the raw terminator is {LF}. what is its character
in TSQL . I tried almost all : \n,\r,\r\n,\0 but still
not working. For your help..
Thanks in advance,
Ori
here is ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |