Viewing 15 posts - 1 through 15 (of 109 total)
BWAA-HAAAA!!!! So does any decent word processor!
I don't think you'd let any word processor enter any scheduled, unattended process inside production environments... My example was to show that in order...
October 24, 2009 at 1:26 am
Good luck there!
Just don't forget that besides good naming convention for your procedures, T-SQL itself has undergone a long way and is very different than 5 years before, so have...
October 23, 2009 at 4:54 am
Just like folks say that not everything should be done in T-SQL, not everything has to be done in something other than T-SQL. (Jeff)
True, but in order to be able...
October 23, 2009 at 2:16 am
My DBs usually contain 2 kinds of objects:
1. Product objects - they are copied from one project to another - are prefixed according to their logical job: pACL_ for permissions,...
October 23, 2009 at 2:09 am
Yay or Nay?
I'll say definitely Yay!!!
In my experience (15 yr) of recruiting, I've interviewed somewhere between 500-600 people and went over thousands of CVs to pick those top 500....
October 22, 2009 at 11:02 pm
Hi there...
You were almost there... I just fixed your WITH (NOLOCK) issue and concatenated the names...
(I also cahnged it from temp table to table variable, for readers convenience)
DECLARE @tblCategory ...
October 22, 2009 at 10:45 pm
Hi
Please post some sample data and table creation script so we can help you with that...
declare @Tmp TABLE (.....)
INSERT @Tmp (...) VALUES (...) etc...
I'd love...
October 22, 2009 at 10:30 pm
Hi there
- schema and user are the same. which one does the [SchemaOrUser] refer to?
It refers to the schema
- what does that 'prefix' do? is it required? (same thing...
October 22, 2009 at 10:23 pm
Great solution!!!
October 21, 2009 at 5:38 am
Well...BLOB is an old term, back from the SQL 6.5/ACESS era...
Your data is probably placed inside a varbinary column.
Have a look at this:
October 15, 2009 at 12:15 pm
OK... let's try this one:
EXEC xp_cmdshell 'dir *.*';
and se what is returned.
just remember to put the proper path instead of *.*
October 15, 2009 at 10:06 am
Yes.
Patindex and LIKE are able to treat TEXT columns. Other string functions aren't.
October 15, 2009 at 10:03 am
http://msdn.microsoft.com/en-us/library/aa197123(SQL.80).aspx
systasks contained one row for every scheduled task. Removed; replaced by sysjobs, sysjobsteps, and sysjobservers. Remove all references to systasks and replace with references to sysjobs, sysjobsteps, and sysjobservers...
October 15, 2009 at 9:57 am
Possible outputs are 1,2,3,4 which are parsed as INT, and 'N/A' which is a string.
Try using '1' instead of 1, '2' instead of 2, etc...
October 15, 2009 at 9:45 am
Viewing 15 posts - 1 through 15 (of 109 total)