|
|
|
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 changing ordinal position of a field Posted by rameshsaive NO[at]SPAM gmail.com at 2/23/2006 4:55:43 AM Does anyone have the idea of how to change the ordinal position of a
field using DDL statements in access 97? I know i'm posting it in
incorrect group, as this is the only active group i've visited till
now.
thanks in advance
...more >>
Server management Studio Posted by zoran at 2/23/2006 4:43:27 AM Hello,
I wanted to ask you just a opinion
What do you think about the new Ms Server Management Studio?
In my opinion MS did a really slow and less "user friendly" product than we
had before. Maybe I am wrong but I am using it almost every day.
I would prefer an enhanced version of Query...more >>
Help on Query Posted by Wayne Wengert at 2/23/2006 4:26:40 AM I have a table that has a field "Judge Name" that may contain names in the
format "J Jones" or "M Smith". I need to change that format to "Jones J" and
"Smith M". I am trying the following query thinking I can use that in an
Update query but I am getting the error:
"Subquery returned more t...more >>
suggest on sub query improvement. Posted by guoqi zheng at 2/23/2006 4:12:36 AM Hi,
I have a SQL statement which myself think might be a little tricky. any
suggestion on improvement?
SELECT * FROM tblMsg
WHERE DateAdded <
(SELECT MIN(DateAdded) FROM
(SELECT TOP 140 DateAdded FROM tblMsg Order by DateAdded DESC)
as sss))
Any suggestion on th...more >>
Varchar Local Variable Question Posted by S Chapman at 2/23/2006 3:24:59 AM
I have a local variable nvarchar(4000) which I use to set the @sql that
I execute in a stored procedure. Sometimes the sql string gets bigger
than 4K and consequently the whole stored procedure fails. How do I get
around this problem of 4K limit?
I have tried using text as a local variable t...more >>
Comma seperated IDS in SELECT query with IN. Posted by Adarsh at 2/23/2006 2:25:53 AM How can I use list of comma separated IDS in SELECT query with IN.
DECLARE @TaskID varchar(200)
SET @TaskID = '(30,32)'
SELECT DISTINCT UserID
FROM tbl_UserTask
WHERE TaskID IN @TaskID
...more >>
sql server 2005 error handler Posted by farshad at 2/23/2006 2:01:54 AM At present There is a stored procedure with several sql statements. Each one
has a standard sql 2000 error handler. i.e. after each statement there is a
if @@error > 0 ...
does this mean that I have to place a begin catch instead of each present
(if @@error > 0)?
Or, how can I use the begi...more >>
create trigger based on value of 2 fields Posted by Lee at 2/23/2006 12:02:26 AM Hello, first of all I have no clue how to set up a trigger, nor do I
understand its code, yet! :)... (But I am willing to learn).
The following tables are to be used:
tblTC (list of training centers... trigger fields & record selection
fields--from other table-- are in this table).
tblGovO...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
transaction problem Posted by Kasper Birch Olsen at 2/23/2006 12:00:00 AM hi NG
Im stuck in a really annoying situation.
To transpose a table I have to execute sqlcode from a variable. This
variable has grown way above 8000 chars, so to solve the problem I write to
a file instead and use the osql utility to run the script. Its far from
perfect, but it works, a...more >>
Optimize the query performance? Posted by Pushkar at 2/23/2006 12:00:00 AM Hi,
I want to improve performance of my query to ensure that my query does not
timeout.
Scenario:
Table : EmpCheckInCheckOut
Felds: RowNumber,TokenID,CheckinTime,CheckoutTime,Action,EmpName
Query : Select TokenID,CheckinTime,CheckoutTime,EmpName,RowNumber from
EmpCheckInCheckOut EC
...more >>
UPDATE failed because the following SET options have incorrect settings: 'ARITHABORT' Posted by Newbie at 2/23/2006 12:00:00 AM good day pros!
im having trouble regarding updating my table trough my vb6 program, and it
displays error message as stated in this post's subject line.
my vb6 program runs the SProc to update my table..
i've search into microsoft KB and didn't found any articles regarding this
aside from I...more >>
How to use regular expressions on T-SQL? Posted by ABC at 2/23/2006 12:00:00 AM as subject
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |