Viewing 15 posts - 1,606 through 1,620 (of 7,429 total)
You will need to use the -1 option.
Look at the operation, of course all you want to do is find the one with LOP_INSERT_ROW as the operation on the table...
August 19, 2004 at 7:11 am
The name of the table is dbo.ALLOCATION with an object id of 99. You won't find it in sysobjects but if you run SELECT OBJECT_NAME(99) you will see it really...
August 19, 2004 at 6:41 am
ApexSQL (http://www.apexsql.com) also has a tool which is a bit lower cost and they do lifetime upgrades.
You could however use DBCC LOG but the data is hex in the...
August 18, 2004 at 2:41 pm
Depending on what you are doing this may be or may not be a bad idea. And most times you are going to close your connection ASAP and thus the...
August 18, 2004 at 2:39 pm
Yeah , unfortunately Null sorting is not implemented in SQL Server.
Another option you can use especially around issues where you don't have an open values is to use case.
ORDER BY
(CASE...
August 18, 2004 at 2:32 pm
No not like that. Just
col like 'x%' OR
col like 'x%' OR
...
However if it is a large list you could dump each to a table and join this table to the...
August 18, 2004 at 1:50 pm
The answer would be things like last 5 deposits and similar situations like you see on banking sites. Many of these are predetermined queries and people want to simplify as...
August 18, 2004 at 7:01 am
I was aware it existed but never have used so not sure of the impact but here are some others http://www.novicksoftware.com/TipsAndTricks/tip-sql-dbcc-help.htm
Many are internal use only and undocumented.
August 17, 2004 at 1:42 pm
Quote from previous:
The only "real" solution to not using NULLs is to decompose your entity design such that every related group of optional fields are in their own table. (See...
August 17, 2004 at 1:16 pm
What does you connection look like. 'Microsoft JET Database Engine' makes me think it is trying to use an Access DB or Excel file and not a SQL Server connection....
August 17, 2004 at 1:11 pm
Look at the execution plan in QA to see what it is doing.
August 17, 2004 at 1:09 pm
Look at the execution plan in QA to see what the process is doing.
August 17, 2004 at 9:07 am
I tried the same thing myself. I ran into no issues. The only difference was I did not build the SQL string I created a static string.
I suggest adding a...
August 17, 2004 at 9:02 am
Can you please provide the code you are using. A lot of times placement of where items into related ON parts of the join can speed things along. But seeing...
August 17, 2004 at 8:05 am
Viewing 15 posts - 1,606 through 1,620 (of 7,429 total)