|
|
|
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 Giive me examples Posted by Bpk. Adi Wira Kusuma at 10/1/2005 11:11:36 PM I use Ms. Access 2000.
Can you give me examples, how to export 123 to Access use DTS? I
...more >>
Table names as a join parameter Posted by laskowski NO[at]SPAM gmail.com at 10/1/2005 6:18:02 PM I am importing old DBF's into SQL, however I have an issue. There
are 400 tables, but the primary keys are table names. For example,
there is one main table "a" which has a column named Book, the rows
in this column link to other tables by their table name. So, the book
column has a row with ...more >>
Column size Posted by Michel at 10/1/2005 4:57:41 PM Hello World,
If Len (Expression) return the length of Expression
What will return the size of column ?
Thank's in advance.
ML
...more >>
EXECUTE AS in SQL 2005 - does it always work? Posted by Dweller at 10/1/2005 4:23:01 PM Hi,
Looks like "EXECUTE AS" is not always works as expected after reading help.
Lets try next steps for demonstration:
1. Create SQL login ( lets say "MASTER" ) with "processadmin" Server Role and
use it to connect to any database (with 'dbo').
2. Execute "SELECT * from master.dbo.syspr...more >>
SQL code passed with a parameter Posted by Howard at 10/1/2005 2:46:05 PM Hi everybody
My application calls a stored procedure that runs a select statement. The
procedure accepts an input parameter (varchar) named @OrderBy. User chooses a
sort order from a combo-box and the application supplies the order by clause
to the stored procedure with the @OrderBy paramet...more >>
Question Posted by Bpk. Adi Wira Kusuma at 10/1/2005 12:12:23 PM Sorry, If I'am wrong in posting my question at here. I ask, If I export data
to text, so I can write like this:
INSERT INTO T1 IN 'C:\'[Text;]
FROM T2
Now, How to export data (LOTUS 123) with Sql in Ms. Access?
Second, is There setup program to install ISAM only?
Third, How to instal...more >>
Large TempDB Posted by rikesh patel at 10/1/2005 11:37:00 AM Hi
I have many reports running from a SQL Server DB, from Crystal Enterprise
reporting system. However I have noticed some performance degradation, and
I noticed that my TempDB had ballooned in size. Is there a way to reset
this? I tried Shrink, but this did not reduce the size of the DB?
...more >>
dtproperties system table changed to user table in sysobjects? Posted by Paul B at 10/1/2005 10:04:06 AM Hi Gurus,
I occasionally use some T-SQL to add a column or trigger to all =
usertables tables within a database.
It has always worked before but on one database I am having a problem =
because the "dtproperties" system table appears to have been changed to =
a user table in the "sysobjects"...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Windows Server 2003 Posted by Sandy at 10/1/2005 9:56:01 AM Hello -
I know this isn't the proper forum for these questions, but I couldn't find
the appropriate group. (Can anyone point me to the Server 2003 group?)
I purchased Windows Server 2003. I had been using a trial version on one of
my computers and it expired.
1. Can I just pop the di...more >>
design help Posted by rodchar at 10/1/2005 8:29:03 AM hey all,
you know in an invoice sometimes you have past due amounts and credited
amounts. are these items normally stored or are they calculated on the fly?
thanks,
rodchar...more >>
Get value of parameters passed in stored procedure in a trigger Posted by manK at 10/1/2005 4:00:01 AM In updating my tables (insert/update), i use stored procedures.
Some of the values passed as parameters to the stored procedures
are only necessary for audit trail only and not for updating the tables.
How can i get hold of these parameter values while inside a trigger?
...more >>
Adding Column to table Posted by Stephen K. Miyasato at 10/1/2005 3:24:43 AM I'm writing a procedure to add column to the database but need to check if
the column already exist.
How does one check to see if it exist. The reason is that if I have multiple
statements adding columns then it seem that the procedure will error out
and not go to the second statement. So ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |