|
|
|
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 why? Posted by pam at 1/10/2004 8:11:53 PM why can't i see my request....more >>
Get an alias back in order to use it in the same SELECT Posted by Lapin at 1/10/2004 6:18:34 PM Hi,
I need to do something like this:
SELECT Field1 AS Toto, Toto FROM Table1
But i have a "Toto incorrect column name".
Is there a way to do this (It works in Access) ?
Thanks.
...more >>
Number keys vs. String keys? Posted by Dave Veeneman at 1/10/2004 5:52:19 PM I am creating a table on which I can't use IDENTITY values as the primary
key. Rather than using an incremental number (which the program would have
to maintain and persost), I am considering using random numbers or random
character strings as the primary key. There are few enough records that
c...more >>
dtspackage Posted by pam at 1/10/2004 5:37:32 PM what are the diff. ways a dts package can be executed.
...more >>
Unique ID in two tables Posted by CSharp ( ILM ) at 1/10/2004 5:36:43 PM Hello,
I am looking for the best way to have two tables with a unique Some_column
ID
Thanks
...more >>
Disable Trigger Posted by Michael Tissington at 1/10/2004 3:24:13 PM How can a temporarily disable a trigger while and update query is running?
Thanks.
--
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com
...more >>
Stored Procedure -- Building a query Posted by Dave Veeneman at 1/10/2004 3:23:04 PM I seem to recall that there is a way for an SQL stored procedure to build a
query (like a SELECT) on the fly. For example, If I have an input parameter
@TableName, I get an error if I write:
SELECT COUNT (*) from @TableName
How would I write this query in a stored procedure? In general, isn'...more >>
User Question Posted by Ryan at 1/10/2004 2:36:12 PM I have a user set up on a SQL 200 server, which I am using to connect to a
database from an ASP.NET application I am making.
When I run the application from the same system as the database is on, the
connection works correctly ( my connection string is:
user id=BlueMaster;data source=BLUE;init...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
error executed at OleDbConnection, ok at SqlConnection Posted by Mullin Yu at 1/10/2004 2:20:04 PM my following sp got strange behaviour when running by OleDbConnection that
no records returned, but have records at SqlConnection
Any Ideas?
Thanks!
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROC GetJobItems @Machine as varchar(20), @OutboundType as int as
decla...more >>
Strange results of Execution plan Posted by Stijn Verrept at 1/10/2004 2:11:07 PM I'm testing a few things, I got 2 calendar tables which have all the
dates of a couple of years in it. The data in them is the same.
Calendar table doesn't have any PK (and no indexes). Calendar2 has a
PK on the date. When I do my query:
select caldate from calendar inner join Inout on ((ca...more >>
Database Design Questions... Posted by Gary Smith at 1/10/2004 1:45:57 PM I am using SQL Server 2000.
I got two tables.
Table1:- PriceList
Column are ProductId(Primary Key) and rest of the column.
Table2:- PriceListHistory
Column are same columns as "PriceList" plus one more column to keep track of
change history.
I can add one more column to keep track of pric...more >>
Automatically modify table structure Posted by Paul at 1/10/2004 12:23:34 PM Hi all
Is there any software / tools / best practices out there to modify a
databases table structure to match that of another database. I have a
continually evolving application, and once i have developed the application
further i.e. adding / modifying tables and columns I have to upgrade all...more >>
INSERT from one db into another Posted by Michael Tissington at 1/10/2004 11:40:01 AM How can I do an INSERT from a table in another database to a table in the
current database?
Both databases are on the same server.
--
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com
...more >>
How can i set the number format for german language?. Posted by Chellammal at 1/10/2004 9:02:54 AM Hi All,
We are working on German Language. I want to store comma (,) for
decimal place. How can i set the number format for german language?.
--
Thank you,
With Regards,
A.chellammal
Developer
...more >>
Add new column Posted by Remesh S at 1/10/2004 8:45:54 AM How to add a new column to a table in a production
environment ? ...more >>
sp_start_job Posted by Randy at 1/10/2004 5:52:45 AM I have been attempting to use the stored procedure
SP_Start_Job, but the system says it doesn't exist. The
older Run Task is not found either. Where can I find
these system processes?...more >>
converting rows to column Posted by poojaahirrao NO[at]SPAM hotmail.com at 1/10/2004 5:22:46 AM have a urgent requirement. Please somebody help me.
I have a table departinfo with following records
begin_time end_time Name Pieces
10:00 10:15 PopCorn 3
10:15 10:30 Biscuits 5
10:30 10:45 PopCorn ...more >>
SQL TO_CHAR Posted by Wes S. at 1/10/2004 4:13:12 AM Ok...this doesn't directly relate to the subject, but does anyone know
if the to_char function works in the INSERT INTO table VALUES command
works with the Microsoft Access 2000 (*.mdb) driver? I'm trying to use
TO_CHAR to format the date and it's telling me that it's expecting a
different ...more >>
sql parser-table name Posted by Arrun S at 1/10/2004 3:06:05 AM H
I need to get the table name(s) and the column name(s) present in a query before it is executed against the database. Are there any built-in functions (in SQL Server or in C#)? I came to know about "ODBC minimum SQL Grammar" from MSDN. Anyone knows whether it'll serve my problem
TIA
Arrun S...more >>
Execute SP with output? Posted by Lasse Edsvik at 1/10/2004 1:06:44 AM Hello
I have a stored procedure that has @SomeShit int output in the
parameterlist in the procedure.
but when i try EXEC MyProc @SomeOtherShit='A'
i get an error:
Server: Msg 201, Level 16, State 4, Procedure TourAdd, Line 0
Procedure 'MyProc' expects parameter '@SomeShit', which w...more >>
multi user environment application Posted by Ganesh at 1/10/2004 12:09:09 AM i've a to create a multi user application, so at a time there are 10 users
they can enter a new new record, but the customerid shold be unique, it's a
integer field only
after insert they may cancel, so i've to use the missing number also to the
next user
and same also go to editing custome...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |