Viewing 15 posts - 121 through 135 (of 229 total)
Thank you for your speedy reply.
OK, I got the value/label business - that's in Visual Studio when editing the dimension.
(value would be the month number and the label the month...
November 13, 2015 at 1:35 pm
The constraints are just default values for the columns, I explicitly named them like that rather than just saying default(xyz) because it's a good habit to get into or you...
November 9, 2015 at 7:20 am
Yes, I should have known to look at books on line for the syntax, I just assumed I knew all there was to know about the INSERT statement I have...
November 6, 2015 at 1:48 pm
mister.magoo (11/2/2015)
.../* create a sample stored procedure to demonstrate the logging */
create proc testProc
as
-- log access to the SP
[highlight="#ffff11"]insert logSP default values;[/highlight]
-- Do some work
go
/* execute the test */
exec testProc;
[/code]
Would...
November 6, 2015 at 1:31 pm
-> J. Drew Allen
Composable DML [/url]lifts some of those restrictions. For our team, being able to augment the OUTPUT columns with other data and then filter before inserting into another...
November 6, 2015 at 1:16 pm
As an additional complication, consider that a course may have pre-requisite course(s) which must be completed successfully. This should be a business rule to enforced as well.
October 21, 2015 at 11:33 am
I make extensive use of TRY...CATCH constructs wrapped around explicit transactions and call an error logging sp in the catch block.
Yes, this is what I meant by "complicated". Some programmers...
September 25, 2015 at 8:26 am
Logging might get complicated during the execution a multi-statement in a stored procedure when the various steps are within a transaction.
Has anyone considered the possibility of writing to a file...
September 25, 2015 at 7:48 am
I am curious as to why T-SQL is being used for this kind of application. I have difficulty envisaging a child connecting to SSMS and interactively typing-in an expression in...
September 25, 2015 at 7:43 am
aziznet (8/20/2015)
sorry for my language, in fact I am not Sufficiently well in english especialy in the forum so I ask if I can write in french may be sommebody...
August 21, 2015 at 2:02 pm
[font="Arial"]On the other hand although recompiles are cpu-intensive, as you point out Grant there are far more significant issues to deal with here.
[/font]
[font="Comic Sans MS"]Yes - I stated right...
August 7, 2015 at 8:43 am
[font="Comic Sans MS"]OK, I though it was something that was well known and that someone would clarify. Given your level of experience I have to take your comment seriously and...
August 7, 2015 at 7:57 am
[font="Comic Sans MS"]One simple improvement would be to avoid DDL in the middle of DML statements.
Move to the top, before any DML the following:[/font]
[font="Courier New"]CREATE TABLE #results(...[/font]
[font="Comic Sans MS"]No,...
August 7, 2015 at 6:29 am
Viewing 15 posts - 121 through 135 (of 229 total)