|
|
|
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 Multiple data files Posted by Venkat at 6/12/2005 10:01:29 PM Hi folks,
I have a database which has multiple data files and logfiles. I need to
put all of them in one data file and logfile with different name.
What is the best approach to do this task.
Thanks in advance.
-----
*** Sent via Developersdex http://www.developersdex.com ***...more >>
SQL Server 2000 SP4 Posted by Zinzan at 6/12/2005 9:21:29 PM Hi there
Is there a location that I can order Service Pack 4 for SQL Server 2000 on
CD.
Thanks
...more >>
NOT IN query with more than 1 field Posted by wrytat at 6/12/2005 7:22:03 PM I have a Customer table located in 2 different database (say db1 and db2).
The Customer table at db1 has 1 additional field, although the records stored
are the same.
To keep the records stored in the table at the 2 database consistent, I
compare the tables and do updates daily.
During ...more >>
current user Posted by jaylou at 6/12/2005 6:44:01 PM Hi All,
I am trying to create a trigger on a table to insert a record into another
table based on the current users name that is logged on. I tried all the
user_name and user_ID functions in BOL, but all I would get is DBO for user
name.
I am logged on as SSmith but all I get is DBO.
T...more >>
Extract data from a website Posted by Steve Lewis - Website Nation at 6/12/2005 2:46:55 PM I have a customer that needs to extract data from a website. The data is
a very simple listing of leads. When you enter your criteria and click
search, you will get a master list of data that would have Name,
Address, etc. then when you click "More Info" you will get the details
for that par...more >>
DECLARING vars in QA Posted by scott at 6/12/2005 11:42:28 AM I have a SPROC listd bnelow that runs fine in QA if I hard code the
variables like
SELECT_WITH_PAGING 'CustomerID,
ShipName','OrderID','Orders','1','0','1','','OrderDate',''
If I create variables in QA like LISTING 1, and run my SPROC in QA supplying
variables like below, I get errors. I...more >>
Trigger and datatype problem Posted by Henry at 6/12/2005 10:45:03 AM I have been using a trigger for some years to copy data from on table to
another when data were changed - but now the field types of the "source"
table has been changed and now contains fieldtypes "ntext" - as a
consequence the trigger failes.
Does anyone konw how to solve that?
This the...more >>
Stored procedure: returning results for an array of inputs Posted by taras.tielkes NO[at]SPAM gmail.com at 6/12/2005 10:35:41 AM
I'd like to build a sproc that performs some calculations for an array of
input values.
For instance, given the input sequence {1, 2, 3}, i'd like to return a resultset
of the following shape:
input result
1 1
2 4
3 9
The version of Sql Server used is 2000 (8.0).
My quesions...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Time Question Posted by Fab at 6/12/2005 9:16:47 AM I have a time question.
I want to round down the current Date/time by One hour. I.e.
SELECT GETDATE()
SELECT DATEADD(hour, -1, Getdate())
The above returns the following.
2005-06-12 13:55:55.177
2005-06-12 12:55:55.177
What i really want it to always round down to the hour.
s...more >>
How to find out row size Posted by Sharad2005 at 6/12/2005 4:33:01 AM Dear Friends
I would like to know what is the current size of the row. I have a database
in the replication and some of the columns which are updated in the
Subscriber are not showing the values but showing the values of publisher.
Hence i want to know if the page size for row so that i ca...more >>
How to sort rows in the same order they were inserted? Posted by Ahmed at 6/12/2005 3:05:01 AM This's related to my last question
If I didn't specify an order clause in my cursor's select statement, then
how will the returned rows be ordered?
will they be ordered by primary key? or insertion date? or clustered index?
or what?...more >>
how to identify the newly inserted rows in a table? Posted by Ahmed at 6/12/2005 2:41:01 AM hi all,
I have a table without auto-generated ID nor time stamp.
I want to identify the newly inserted rows in a table.
I can't make any modifications to the table....more >>
send sql command to an Oracle linked server Posted by what is the syntax for sending an sql command to execute on an Oracle linked
server, when using the four-part naming convention. The following syntax
doesn't seem to work:
exec LINKEDSERVERNAME..MySchema.sp_executesql N'drop table MySchema.MyTable'
...more >>
Trimming control characters Posted by ggeshev at 6/12/2005 12:00:00 AM Hello!
Suppose the contents of a field from a table is stored in e variable of type
VARCHAR(10).
DECLARE @A VARCHAR(10)
SELECT @A = Field1 FROM :
Lets suppose the contents of @A now is just two control characters :
CHAR(13) + CHAR(10).
If I trim @A using LTRIM or RTR...more >>
Large Database Development Considerations Posted by Anubis at 6/12/2005 12:00:00 AM Hello All,
I'm currently in the process of developing a large database platform (both
software and hardware wise). I have several distinct departments each that
have their own set of data, however each department must be able to
intrgrate seamlessly with one another.
I have thought ab...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |