Viewing 15 posts - 61 through 75 (of 330 total)
Jeff Moden (10/3/2009)
Most people don't know about it, but you can also create temporary stored procedures that begin with #.
A dark hand waves in the mist...
'Your SQL skill has just...
October 4, 2009 at 1:29 pm
Barry, I've learnt such a lot from your posts over the time that I've spent on this forum, I'm glad I could just go a small way to repaying the...
October 4, 2009 at 1:26 pm
laughingskeptic (10/4/2009)
Clearly you did not understand the code. COUNT returns one row. My code returns the vector 0..N-1 based on the size of the target table.
I've got to...
October 4, 2009 at 1:04 pm
Jeff Moden (10/4/2009)
October 4, 2009 at 8:58 am
When you create an assembly with CREATE ASSEMBLY, it's actually stored internally, and loaded from there from that point on. The DLL on disk doesn't have any bearing on what...
October 4, 2009 at 8:25 am
Jeff Moden (10/3/2009)
Garadin (10/2/2009)
These will compile fine if the entire table does not exist. They will not compile if the table exists but the column you're referencing does not....
October 4, 2009 at 3:49 am
Jan Van der Eecken (10/2/2009)
October 2, 2009 at 4:50 pm
Yeah, but you said you didn't know why the OP would want to do that, and he clarified:
...The reason I want this is because I need to run an import...
October 2, 2009 at 4:49 pm
Aside from the discussion about how to create stored procs that reference non-existent objects - isn't the best solution for the OP to keep the views, but drop the indexes...
October 2, 2009 at 4:37 pm
Jan Van der Eecken (10/2/2009)
Is this fair use of the forums by the way?
I don't have a problem with it, personally. I know I'm probably not the best person to...
October 2, 2009 at 4:20 pm
Bob Hovious 24601 (10/2/2009)
October 2, 2009 at 3:51 pm
TheSQLGuru (10/2/2009)
October 2, 2009 at 2:39 pm
When I was at school there used to be a game called 'Betrayal at Krondor' - where you would meet people as you travelled around. They might have a certain...
October 2, 2009 at 1:11 pm
If you wanted to extend it for VB / VB.NET / C# - then you might want to consider ActiPro CodeHighlighter - @ http://www.actiprosoftware.com/Products/DotNet/ASPNET/CodeHighlighter/Default.aspx.
Not sure if it's...
October 2, 2009 at 1:03 pm
Lynn Pettis (10/2/2009)
On my dev system master.sys.all_parameters returns 6776 rows. In the context of the particular database I tested it, sys.all_parameters, returned 6841.
Yeah I think that's about on the...
October 2, 2009 at 12:57 pm
Viewing 15 posts - 61 through 75 (of 330 total)