|
|
|
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 What's happen with SQL Server Service Manager? Posted by ReTF at 11/13/2005 9:52:19 PM Hi all
What's happen with SQL Server Service Manager in SQL 2005?
Where I can find this?
Thanks
...more >>
Check error question. Posted by ReTF at 11/13/2005 9:45:21 PM Hi All,
I need check if one of thise SP had error.
EXEC gerar_dnum_sp @dnum OUTPUT
EXEC gerar_auto_sp @auto OUTPUT
EXEC gerar_aute_sp @dnum, @auto, @aute OUTPUT
Then I did this:
EXEC gerar_dnum_sp @dnum OUTPUT
IF @@ERROR <> 0
BEGIN
....
END
EXEC gerar_auto_sp @auto OUTPUT
IF @@...more >>
comparing two varchar variable Posted by mtv at 11/13/2005 9:36:02 PM Table One has for column id = 'AAA-BBB-CCC' , 'AAA-BBB-DDD'
Table Two has column id = 'AAA-BBB-CCCI' , 'AAA-BBB-DDDI'
I want to return all Table One.id which appear in table Two.id by comparing
the varchar column e.g
select One.id from One, Two
where One.id like (Two.id + '%')
Can s...more >>
help with transactiions Posted by Keith G Hicks at 11/13/2005 9:03:45 PM I've read quite a bit about this in BOL and find that it's quite a bit
different from what I'm used to in MS Access. Can someone tell me what the
best way would be to handle the following simple example code in a stored
procedure? I'm transferring $100 from savings to checking and want to be
sur...more >>
stored procedure & Fetch Function study Posted by Thomas at 11/13/2005 8:52:05 PM very apprciate for anykind information (books, website, documentation) to
learn/study stored procedure & fetch from basic to advance level.
Thanks
...more >>
Date Format in SQL (MSDE) Posted by harrys NO[at]SPAM gmail.com at 11/13/2005 5:00:09 PM Hi,
Can anyone help with the following:
I am importing a XML file into a SQL (MSDE) database table, and one
field is set as follows:
01/11/2005 00:03:33.18
01/11/2005 00:04:31.12
01/11/2005 00:10:06.32
01/11/2005 00:12:20.59
01/11/2005 00:00:56.66
I am using access to manage MSDE, and...more >>
Table and Index Hints Posted by Steve'o at 11/13/2005 4:38:02 PM SQL Server 2000 SP3a
I'm hoping to speed up some of my SQL statements by specifying the index's
to use and that no locking is needed. The statements run against static data
which is used just for reporting.
My question is, do I have to specify the hints against every table, or can I
sim...more >>
semicolumn in sqlserver 2005 Posted by Yaniv at 11/13/2005 4:18:50 PM Hi,
Is a semicolumn (;) going to be mandatory in the next release?
Thanks,
Yaniv
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
query to select substring of field? Posted by msnews.microsoft.com at 11/13/2005 3:28:12 PM If I want to do something like:
select substr(Field1,1,2), <other fields>
from Table
group by substr(Field1,1,2)
where Field1 is a 4-character text field, is my syntax above even close to
what I need? What I want to replicate is the situation where I'd have, say,
Field2 whic...more >>
Redistributing OSQL.EXE for SQL Server 2005? Posted by dhbayne NO[at]SPAM ihug.co.nz at 11/13/2005 2:21:35 PM Hi All,
I am currently expanding our product's installer to support SQL Server
2005.
Currently, we redistribute OSQL.EXE within our installer, as we're
registered to redistribute MSDE, and the REDIST.TXT file clearly allows
us to redistribute OSQL.EXE in that case.
However, I've been try...more >>
Zoo Database Posted by Jordan R. at 11/13/2005 11:54:22 AM We're designing a master "animals tracking" (not hunting!) database for a
medium-sized city zoo. We currently plan to have one master "animals" table
that includes all species - and not separate tables for each species. We
want to use a natural key to uniquely identify each animal (from Elepha...more >>
Trigger After still rolls back the insert Posted by Masa Ito at 11/13/2005 11:41:39 AM I am using an After trigger on an insert. When reading the
documentation (and few SQL books I have), this trigger happens AFTER the
row has been added to the table. This is perfect, since I don't want
any errors in the trigger to cause the row not to get inserted. Well,
errors are causin...more >>
Count Having > 1 Posted by shank at 11/13/2005 9:31:44 AM I couldn't get this right in SQL, so I tried Access GUI for help and didn't
get much farther.
In the end, I need to return a "1" or "0".
I need to Count the number of duped artists in DODSongs. If the total of any
one artist > 50% of the total artists Then "1" Else "0"
For example: Assu...more >>
[OT] Been away for a few weeks... Posted by Mike Labosh at 11/13/2005 5:18:53 AM I have REALLY missed this forum.
I rode my bicycle (yeah, non-motorized) two blocks away to the gas station
to buy a pack of cigarettes. It was very late at night, and raining. On
the way back, as I was riding past their Diesel pumps, I either hit
something I couldn't see, or slipped on some...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |