Viewing 15 posts - 4,666 through 4,680 (of 14,953 total)
Kit G (3/9/2011)
CirquedeSQLeil (3/9/2011)
GSquared (3/9/2011)
CirquedeSQLeil (3/9/2011)
GilaMonster (3/9/2011)
*sigh* I know I'm a little short tempered due to lingering jetlag ...
I know the feeling (done the jetlag thing several times).
It was also...
March 9, 2011 at 1:30 pm
Something like this will do a full dedupe. It won't leave deliberate dupes intact. The only way I can think of to do that would be a full...
March 9, 2011 at 1:23 pm
Ironic that in a post about removing duplicates ....
March 9, 2011 at 12:51 pm
SKYBVI (3/9/2011)
Now I got the mail body as :-ITEMNMBR ------------------------------- No items Inserted
Regards,
Sushant
Is that what you want? It seems to be, from the prior post, but I'm not...
March 9, 2011 at 12:50 pm
CirquedeSQLeil (3/9/2011)
GilaMonster (3/9/2011)
*sigh* I know I'm a little short tempered due to lingering jetlag ...
I know the feeling (done the jetlag thing several times).
It was also difficult for me transitioning...
March 9, 2011 at 12:46 pm
Sounds like homework, but it was interesting enough to get my attention anyway.
Maybe something like this:
-- Test Data
CREATE TABLE #T
(Prod CHAR(3),
Ref...
March 9, 2011 at 12:44 pm
At the beginning of the proc, after "AS", add "SET NOCOUNT ON".
create procedure [dbo].[insert_kit_components]
as
SET NOCOUNT ON;
INSERT INTO dbname.dbo.IV00104
That should get rid of that part.
March 9, 2011 at 12:30 pm
And what do you want to do if the word has a legitimate repeat in it? Aardvark, apple, peer, assimilate, better, coordinate, dunnage, tonne, etc., all have repeating letters,...
March 9, 2011 at 12:28 pm
The DBCC command is really meant to be an option if you're not auto-updating stats, or if the automatic updates fail to work as expected.
On large, high-traffic tables, with lots...
March 9, 2011 at 12:23 pm
Here's an example of how to do it:
CREATE TABLE My_Table (ID INT IDENTITY PRIMARY KEY);
GO
ALTER TABLE My_Table ADD [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL DEFAULT (NEWID());
GO
DROP TABLE My_Table;
March 9, 2011 at 12:17 pm
You can limit the maximum number of concurrent connections, but it's more usual to use connection pooling or whatever in your data access layer, instead of at the database server.
March 9, 2011 at 12:15 pm
The "print" command is really only useful if you're calling the procedure from Management Studio. It doesn't really do much if you call the procedure from an application or...
March 9, 2011 at 12:13 pm
You'll need to restore a backup from before the truncation, and pull the data out of that.
March 9, 2011 at 12:08 pm
Use the Windows Update tool. That'll work in most cases.
March 9, 2011 at 11:22 am
Phil Parkin (3/9/2011)
Code-1029433 (3/9/2011)
I've been searching the forums trying to find the answer to my question but I'm not having much luck. The majority of our clients...
March 9, 2011 at 11:20 am
Viewing 15 posts - 4,666 through 4,680 (of 14,953 total)