quote:Originally posted by joechang 1. if you are SQL 2005, then its close enough 2. yes but you must catch the statement on the call to prepare,...
I don't know if this is the correct forum to post this question. Is there a better forum to post it?
Probably not any faster, just a rewrite for more standard SQL: UPDATE Cash_Receipt SET Location_Cd = (SELECT Tln.Target FROM Tbl_Tln_Location Tln...
When I do a searches across all forums, I get this: Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired /forum/search.asp,...
Is there a way to use SQL Server Profiler to show the SQL for prepared statements that are being traced? Essentially there are two things we need...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
quote:Originally posted by Adriaan Like Frank suggested, if your parameters are NVARCHAR, and your using them to compare against VARCHAR columns,...
quote:Originally posted by Adriaan Since the subquery is not a correlated one, why don't you use this syntax: DECLARE @type INT SELECT @type =...
Thanks for looking at this. I also confess that my knowledge of SQL Server is spotty at best since I divide my time between SQL Server, Oracle,...
quote:Originally posted by FrankKalis Sorry, but I think you maybe have a kind of naive approach here. Of course, substituting a subquery for a...
Why can't the query optimizer figure out that a subquery is a constant value and create a good plan? For example: 1) SELECT * FROM table1 WHERE...
A couple of annoyances with this site: 1. I hadn't logged on for a couple of years, so couldn't remember login info. But your "forgot" password...
That looks good too if we can keep the SQL scripts and just run them from DTS. I'll learn some more about it. quote:Originally posted by Lazy_DBA...
That looks very good, as I can maintain the OSQL script and others can still develop the SQL scripts as before. I'll look into OSQL.<br /><br /><br...
quote:Originally posted by Lazy_DBA It seem to me that you might be better off incorporating all these processes into a DTS package. Have you looked...
I guess we'd really like something like an "INCLUDE" statement similar to a C compiler, so that a script could include another. Based on your...
Our need is to maintain the scripts separately because we might want to run them in different orders, for example: 1) create tables without indexes;...
We have a set of SQL scripts for setting up tables that are run in a prescribed order using SQL Analyzer. We would like to create a "master" script...
Separate names with a comma.
