|
|
|
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 query not possible??? Posted by antonio catalano at 1/4/2004 11:35:49 PM After declared a variable launch the query
"select (@dec_var=@dec_var + 1 ) as mia , t.* from
nome_table t"
The query not run.
How come ???
Thanks...more >>
probs in Assigning more then 128 characters to a variable in SQL2000 Posted by manoj at 1/4/2004 11:21:05 PM Sir,
I have created a stored procedure in which a variable @statement is declared of varchar type and size is 5000 ,I have assigned a long query to that variable with about 2000 characters, it worked fine in SQLserver7.0 but creating probs in SQLserver2000 gives error Max length is 128 char...more >>
MS SQL Server Limit Posted by Maziar Aflatoun at 1/4/2004 10:36:09 PM Hi everyone,
I want to query a table and only display 10 records at a time.
SELECT top n * FROM Table only displays the top n records. Is there a way
to display only the records from n to m in your result? Similar to MySQL
Limit 10, 20
Thank you
Maz.
...more >>
Why is the sp_reset_connection running every 3 seconds? Posted by candelaboy NO[at]SPAM hotmail.com at 1/4/2004 10:36:04 PM Why is the sp_reset_connection running every 3 seconds?
when i open my sqlserver's Profiler,i find the system'proc
sp_reset_connection is running every three seconds.Info below:
SP:CacheHit Microsoft(R) Windows (R) 2000 Operating
System sa 1108 52 2004-01-05 10:45:00.213
RPC:Starting...more >>
how to get OUTPUT value when proc1 calls proc2 ? Posted by Timo at 1/4/2004 9:49:49 PM I would like one stored procedure to call a second stored procedure and
get back some values from the OUTPUT parameters. What is the proper way
for a stored proc to get back OUTPUT values from another proc it has
called (i.e. executed)? The example in SQL Server Books Online does not
seem t...more >>
identity Posted by id at 1/4/2004 7:55:52 PM I want to find all my table having identity column in one
of my database.
Any idea?
...more >>
newbee crystal report question Posted by nb at 1/4/2004 7:54:15 PM I know this is not crystal user group, but I know there
are lots of crystal guru here.
I have a text object on report, when I right click on
this and set object size and position. It moves minimum
10 pixels , I want to move this in set of 5. (say I am
changing it from 110 to 105 either...more >>
sp_columns vs sp_columns_ex?? Posted by Jack Black at 1/4/2004 4:42:09 PM Using SQL2000 (latest patches and such)...
Why does sp_columns_ex fail to identify IDENTITY columns when run against
tables on a linked server?? Since sp_helpconstraint doesn't yield IDENTITY
info either, how can I determine IDENTITY info (seed, increment, column,
etc) from a table on a linke...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Stored Proc dependencies and performance Posted by go559 NO[at]SPAM hotmail.com at 1/4/2004 4:11:48 PM From my reading of the newsgroups, I've noticed that stored proc
dependency information can bcome out of date in the sysdepends table,
either by db creation scripts, adding or dropping procs by hand etc.
How will this affect performance in SQL Server 2000?...more >>
Output parameter not returning value? Posted by Dave Veeneman at 1/4/2004 3:20:52 PM I'm having problems getting an MSDE stored procedure to return a value.
Here's the procedure:
----------------------------------------------------------------------------
----
ALTER PROCEDURE CreateLedgerAccount
(
@ledgerAccountName varchar(50),
@ledgerAccountType int,
@parentLedg...more >>
Help, Locked out after failed DTS Posted by graham at 1/4/2004 2:40:20 PM Help! I'm locked out of my Databases! After "killing" a
DTS task that ran for over 24 hours, I can no longer even
get in to any databses on this server.
By killing, I mean that I hit cancel on the DTS status
window, then after 2 hours of no activity, I opened Task
Manager and ended the p...more >>
Need Help with 1 table query Posted by Redeem at 1/4/2004 2:33:35 PM hi there
I have a table called Training with the following field
id , staffid , name , jobtitle , status, software
example data
1, 23, Jeremy Lang, support, 1, MS Access
2, 12, Bob hart, prog, 2, Excel
3, 23, Jeremy Lang, support, 3, MS Word
4, 01, pete jones, support, 2, MS Access
...more >>
short for terabyte. Posted by patni at 1/4/2004 2:10:15 PM Does anybody know what do we call terabytes(TB) in short
as we call GIgabytes(GB) gigs.
say my database is 500 gigs.
Thanks a lot.
...more >>
Help w/ DTS import / transform Posted by Ken Bass at 1/4/2004 5:16:05 AM Here is the task that I am trying to accomplish:
From an old legacy system, I am trying to import data from flat files
into a database. There are two basic file types: 1) Lists, which are
CSV files; and 2) ListDirs, which contain an ID and filename for each
list file. So the process is:
rea...more >>
duplicate record Posted by kuya789 NO[at]SPAM yahoo.com at 1/4/2004 12:53:18 AM I need a query that select duplicate record (all values in all columns
are the same except for the id column, different id number)
Thanks
Aaron...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |