Viewing 15 posts - 20,056 through 20,070 (of 22,212 total)
Great. If you did need to pursue the CASE statements, you can't use "= LIKE." So you'd have to change
AND lc.locstring =
to
AND lc.locstring LIKE
July 2, 2008 at 7:25 am
Several problems where. A horizontal line is formatting. That's not what TSQL is all about.
Also, a UNION query doesn't necessarily return the rows from table 1 and then the rows...
July 2, 2008 at 6:37 am
Johann Montfort (7/2/2008)
How can I write a stored procedure based on condition. At the moment, my code is not working. Here is my example
ALTER PROCEDURE [dbo].[FindStrings]
(
@uid bit,--...
July 2, 2008 at 6:32 am
It depends on the severity of the error. Higher severity errors cause a disconnect of the offending process. Those cannot be trapped.
For the other procedures, in SQL Server 2005, you...
July 2, 2008 at 6:23 am
That sums it up very well.
By the way, you're posting a SQL Server 2000 question in the SQL Server 2005 forum. While this question was fairly generic and the answer...
July 2, 2008 at 6:21 am
A full and hardy congratulations to you both. You deserved it and you earned it.
July 2, 2008 at 6:17 am
Yeah, yeah, I used the "depends" right at the beginning and added weasel words "in all likelihood"
I covered my behind.
😛
July 1, 2008 at 6:40 am
You have to put a "GO" statement between these two scripts. This seperates the two scripts into seperate commands so that they are processed independently by the server. That allows...
July 1, 2008 at 6:27 am
SrikanthSv (7/1/2008)
If the amount of data which the stored procedure hits is huge then use the temp tables. Using temp...
July 1, 2008 at 6:15 am
We've got some development teams advocating for it's use right now. I'm trying to build a strong case on either a correct usage (and that DOES NOT mean object databases)...
July 1, 2008 at 5:32 am
Really? You're using it? Any words of wisdom on either living with it well or avoiding it entirely?
July 1, 2008 at 5:26 am
Nah, go take it. If it's really a question & answer type of test, you'll probably pass. It's likely to be one of those filters that HR puts in place...
June 30, 2008 at 1:20 pm
Richlion (6/30/2008)
June 30, 2008 at 11:36 am
In addition to that list of links, which is pretty good, I'd just say to get very familiar with Profiler. One of the best books you can get is "Inside...
June 30, 2008 at 11:23 am
Hey guys,
You think you have problems now? Wait until nHibernate and all it's ilk are in your development systems. Now you'll have object specific databases with dynamic SQL. Tuning headaches...
June 30, 2008 at 7:59 am
Viewing 15 posts - 20,056 through 20,070 (of 22,212 total)