Viewing 15 posts - 46 through 60 (of 77 total)
sjsubscribe (10/19/2009)
sort output columns by clicking
compare output of two different result sets
compare two different code windows
right-mouse click on object name in QA and open...
October 20, 2009 at 12:16 pm
Here is another way to go. It avoids the DROP which I think affects any auditing done on your DDL. Of course it does the 1 time creation...
October 19, 2009 at 8:28 am
Something that may have been overlooked and I think the following code could use a slight change to insure it is a unicode string since it is being declared as...
September 25, 2009 at 12:36 pm
Question about the use of the CONTINUE keyword in the function. Why was this chosen over using an IF ELSE IF structure? Just curious if there was some...
September 23, 2009 at 12:29 pm
Jayraj.Todkar (9/16/2009)
Hi,Is there any solution to overcome this situation?
Best Regards,
Jayraj Todkar
I am not entirely sure of the problem but you may try to entity encode the...
September 21, 2009 at 9:42 am
scott detweiler (9/13/2009)
However, after I created the function, it is only returning the 1st value, not the entire list of items that qualify.
I am getting...
September 18, 2009 at 11:59 am
Matt Whitfield (9/11/2009)
Adam Gojdas (9/11/2009)That will not work, at least in my SSMS ide. Try it.
I did - rule #1 of posting 🙂 I didn't do it with a...
September 11, 2009 at 3:05 pm
^(.+)$ is what's wanted.
Or, you could use an editor that has a 'Copy data as IN Clause' option...
That will not work, at least in my SSMS ide. Try it.
It...
September 11, 2009 at 1:54 pm
Type {()} into the 'Find What' box and type '\1', into the 'Replace With' box. (Please type both of these as I've pasted them, unless you know what you are...
September 11, 2009 at 1:32 pm
Paul White (9/11/2009)
Sure: Using Special DataSYSNAME has been around at least since 6.5 😎
:-D, geeze, I have to admit I am surprised I never knew of it. (Maybe I...
September 11, 2009 at 9:26 am
Paul,
Excellent, I was totally unaware of the datatype SYSNAME. That sounds like it is definitely the best way to go. But I really can't find info in BOL...
September 11, 2009 at 8:55 am
Nice work benyos.
I would think about changing the following from:
@TableName NVARCHAR(100)
to
@TableName NVARCHAR(128)
That will match the actual size of...
September 9, 2009 at 11:37 am
set @sql = 'select EmpName FROM Test WHERE EmpID IN (' + @empid + ')'
EXEC sp_executesql @sql, N'@emp_id varchar(100)',@emp_id=@emp_id
this way, you can't throw injection in (well, at least not as...
August 19, 2009 at 1:18 pm
You may want to think about nesting a TRY/CATCH similar to the following. Based on what starunit came up with above I just wrapped a TRY/CATCH around all his...
August 13, 2009 at 4:06 pm
Jeff Moden (8/11/2009)
Heh... ALL code is production code... maybe just not yet. 😉
Too funny...too true.
August 13, 2009 at 3:26 pm
Viewing 15 posts - 46 through 60 (of 77 total)