|
|
|
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 Type name is Invalid Posted by Manish Sinha at 8/28/2004 5:22:10 PM Hi!
When I try to run a stored procedure from a ASP page it gives me an error:
Microsoft OLE DB Provider for sql server (0X80040E30)
Type name is Invalid
How ever this code with the same database is running fine in the development
server.
Please help.
Regards,
Manish
...more >>
paging problem Posted by Savas Ates at 8/28/2004 3:09:22 PM Current Recordset does not support updating. This may be a limitation of the
provider, or of the selected locktype.
my connection string
Set baglantim=Server.Createobject("ADODB.Connection")
Outpost="PROVIDER=SQLOledb;Initial Catalog=friends;User Id=sa
;password=;Data Source=localhost" (it ...more >>
triiger fires stored procedure Posted by Viktor Popov at 8/28/2004 2:35:38 PM Hi,
Is it possible a trigger to pass parameters and to start Stored Procedure?
Thanks,
Viktor
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.744 / Virus Database: 496 - Release Date: 24.8.2004 a.
...more >>
2 NULLs violate Uniqueness? Posted by A Traveler at 8/28/2004 2:13:31 PM Hello,
As im exploring SQL Server, ive run into something that seems quite odd, so
i just wanted to ask the experts, and find out if this is correct.
I have a table with a field F which is set to Allow Null = True. I then put
a Unique Index on F. Now if i try to put in two records with a N...more >>
DateTime format problem Posted by Diego F. at 8/28/2004 1:39:56 PM Hi. I have a table with a SmallDateTime field, with spanish format
(28/04/2004).
I'm testing some queries with query analizer, but when I show all fields the
date appears as '2004-07-28 00:00:00'
I can't find the correct query to get results based on a specific date. I
only get results if I...more >>
@@getrow Posted by Savas Ates at 8/28/2004 11:18:17 AM im using asp and stored..
im execute a query in stored
exec (@sorgu) like this method and it must be.. no other ways offer me....
there return lots of records...
how can i learn the getrows with Tsql and how do i call it from asp..
i dont want to open a recordset.. i want it with tSql ..
...more >>
Script to output to text files Posted by Laurel at 8/28/2004 9:42:04 AM Without using dts, I am trying to create a script that
will output the contents of tables that have the text CUST
in its object name to tab-delimited text files, with
headers, the filenames named
TEST_TABLE_NAME_WITH_CUST_IN_IT.txt. Obviously, I am
looking for something dynamic. The loc...more >>
Run a program from a trigger ? Posted by rob at 8/28/2004 6:39:10 AM Is there any good way to run execute an Access program from a SQL trigger ?
If so, any books / articles that may demonstrate how ?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
complex query Posted by alf at 8/28/2004 12:23:17 AM I have this table
qt y
1/01/2003 10
1/02/2003 2
1/03/2003 -5
I would like get
qty sum
1/01/2003 10 10
1/02/2003 2 12
1/03/2003 -3 9
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |