Viewing 7 posts - 61 through 67 (of 67 total)
Aaron N. Cutshall (4/3/2009)
But, done properly,
make the query rather self documenting.
No. NO!!! NO!!!! The table name itself is the most accurate representation of what's...
April 3, 2009 at 3:26 pm
Hope I don't misattribute anything here...
Heh... in which cases are [table-valued functions] better? They typically are the cause of performance problems in the face of any scalability
I meant...
April 3, 2009 at 2:50 pm
YES, T-SQL is a strange and somewhat poor programming language. I tend to think in terms of sets, not in terms of procedural programming, and yet there are still...
April 3, 2009 at 1:16 pm
Instead of changing the system catalogs, the procedure should generate a call to the SP_Rename proc to do the same thing in a standard way.
May 8, 2008 at 1:45 pm
I have the same kind of data also. Personally, I think it is very common. Currently I have a small .NET (VB) program that reads the text file, creates the...
July 27, 2007 at 1:12 pm
I *wish* that UDTs could be changed (redefined). I once wanted to redefine a UDT, and was really surprised that the type definition couldn't be changed. That would SEEM to be...
July 23, 2007 at 9:07 am
You mean IsNull(field,'') rather than NullIf(field,'').
NullIf(Field1,Field2) returns Null if the fields are equal. IsNull(Field1, Field2) returns the second parameter if the first is null.
June 25, 2007 at 10:06 am
Viewing 7 posts - 61 through 67 (of 67 total)