Viewing 15 posts - 631 through 645 (of 662 total)
Doing a bit of side tracking! Where can one buy a hardcopy of SQL 2000 manual, like the 6.5 Programmers reference (name maybe wrong).
I find the official book references do...
October 23, 2002 at 11:16 pm
Agree strongly on the readability of TSQL.
One can spend a lot of time just dechipering code.
Suggest you look at the potential use of case then enable/disable a check inside one...
October 23, 2002 at 2:51 pm
Exec (@A1+@A2..) works since 6.5 with 255 character limit.
Generate command strings, as needed, inserting into a table.
Get proc to run the whole lot one after the other(limit round tripping).
What about...
October 23, 2002 at 2:20 pm
This may help a bit. Warning, do not set count limit to low!!
-- Event/Evidence Table
CREATE TABLE [dbo].[CaptureEvent] (
[EventType] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Parameters] [int] NULL ,
[EventInfo] [nvarchar] (255) COLLATE...
October 22, 2002 at 9:28 pm
To get a bit of discipline going, goes hand in hand with screaming and kicking from the undisciplined. Once established it is to everyones advantage!
October 21, 2002 at 2:37 pm
How many rows, bytes per row is returned?
October 17, 2002 at 11:00 pm
I'll look at statistics, sp_recompile, Profiler, query plans, dbbc indexdefrag, etc.
October 15, 2002 at 2:24 pm
Declare @ReturnDate Datetime
Select @ReturnDate = fn_SomeFunc(@SomeArg)
If (@ReturnDate = '1 Jan 1900')
-- Error Returned, Rollback etc.
Else
-- Commit Transaction
October 15, 2002 at 1:58 pm
Sounds like plan B will have come into play then? Error trapping via the insert with a constraint / trigger, if the udf can return an "invalid" date. Example...
October 15, 2002 at 1:21 pm
Simulate Visual Basic 6's StrConv(string, vbProperCase) as a function in TSQL.
October 10, 2002 at 7:12 pm
BOL: Search for "New and Enhanced Features in Transact-SQL"
List include some other enhancements and new features, for replication, DTS, etc.
October 7, 2002 at 10:07 pm
Following may help a bit. http://www.asapsoftware.com/microsoft/sql2000/ for
"What’s New in SQL Server 2000 ",
"SQL Server 2000 Upgrade Guide " and
"SQL 2000 Upgrade Calculator".
October 7, 2002 at 10:00 pm
Interesting subject.
Search BOL for "Using decimal, float, and real Data".
Things start to go wrong when you multiply/divide a small number with a big value(exponent ,mantissa, loss of accuracy).
BOL = "Because...
October 2, 2002 at 3:01 pm
How about
select * from [sqlserver2\test].db1.dbo.orders ?
October 1, 2002 at 6:42 pm
Viewing 15 posts - 631 through 645 (of 662 total)