|
|
|
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 check constraint for phone number and email Posted by Hassan at 10/14/2007 11:23:13 PM As part of the create table for say customers that include phone number and
email address, how can i add a contraint to ensure that phone numbers have
the following constraint met xxx-xxx-xxxx and emails have a @ and a .(dot)
or whatever ways are out there to ensure it follows a particular typ...more >>
help with data model Posted by Hassan at 10/14/2007 9:36:58 PM I am trying to learn data modelling and thought id build one along the lines
of say an audio catalog for example
So what will the logical model look like from a high level between a user
and the audio collection..
I can think of a user table and an Audio table that lists user names and
s...more >>
Duplicate a record in the same table Posted by if at 10/14/2007 8:28:00 PM Hello,
Please I need advice.
SQL Server 2005. I have a table consisting of 200 fields with a primary
key(auto-increment). I need to be able to duplicate via a stored procedure a
specific row in the table identified by primary key value i.e. insert a
record form that table into the SAME table...more >>
running a stored procedure through different databases Posted by TG at 10/14/2007 8:09:55 PM Hi!
I need to run my stored procedure on a monthly basis through all the
databases and spit out a report in Excel.
Here is my stored procedure for the report:
CREATE PROCEDURE usp_DR_Billing (@StartDate datetime,@EndDate
datetime,@PreviousDateEnd datetime)
AS
--insert all th...more >>
Help for a one year fresher to enter the software industry Posted by mrnagrajan NO[at]SPAM yahoo.co.in at 10/14/2007 10:58:47 AM Dear Freinds,
I am hoping a postive answer from this group. I have done my
graduation currently and looking for a break in programming in C# or
VB.NET with SQL Server. After graduation i joined a computer institute
and did a one year course there. For first six months i was nearly
taught noth...more >>
error in my sql server.(sp_config error) Posted by raj kan at 10/14/2007 4:03:10 AM hi i got this error" generating user instances in sql server is disable. use sp_configure'user instances enable. to generate user instance'
how i generate that. any one help me pls
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com...more >>
INSERT any rows Posted by Bpk. Adi Wira Kusuma at 10/14/2007 1:22:49 AM INSERT INTO TB1(a,b,c)
Values ('a',7,9)
if I want to insert the data to 3000 rows, So i must loop the statement
300x. Any other way to do it with more good performances?
...more >>
SELECT TOP n........ Posted by Bpk. Adi Wira Kusuma at 10/14/2007 1:13:25 AM About "SELECT TOP n...". Can "n" be instead with a variable?
eg:
Set @RowsCount=10
SELECT TOP @RowsCount *
FROM TB1
If I can't do like as above, So must I use EXEC Statement? Any other way?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
how to add a field into view Posted by hui at 10/14/2007 12:00:00 AM I made a view as
select a.id,a.field1,a.field2,b.field3,b.field4 from a inner join b on
a.id=b.id
After I change Table A structure, I need to change the view structure. Such
as Add or Remove some fields from Table A.
How can I do it? thank you
hui
...more >>
How do I get rows with a specific number of occurrences of values in a field? Posted by M Shafaat at 10/14/2007 12:00:00 AM Hi,
I want to make a query in SQL where I want to get the rows where values in
the field of MyField occure more than once. Any idea how to do it?
Regards
M Shafaat
...more >>
Problem with Insert Posted by Bpk. Adi Wira Kusuma at 10/14/2007 12:00:00 AM I have data like it
NOID ChildName
-------------------------
1 Adu
1 Bini
2 iko
3 yUki
2 huki
2 ilo
I want to insert it to a table, but the rule is
NOID FNO ChildName
-------------------------
1 1...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |