Viewing 15 posts - 16 through 30 (of 49 total)
jared-709193 (10/13/2011)
xgcmcbain (10/13/2011)
enforcing not null is always good on a table, and peformance.
I'm not sure what you mean by this statement, but I want to make clear that enforcing NOT...
October 13, 2011 at 1:30 pm
what im doing is giving it a default so it seams checking not null is ambiguous
no outside application has access but myself
October 13, 2011 at 1:23 pm
i have heard people saying sqlprompt for years, i just wanted to know if it had that second ability.
Thanks for your quick response
September 15, 2011 at 1:00 pm
so your saying redgates is better ? ok
another very important feature, is the "tree" icons to the left in a very lengthy stored procedure, where it matches up with if's...
September 15, 2011 at 12:43 pm
is there a tool i can install that will run side by side and not override its 2008 native ability?
September 15, 2011 at 12:26 pm
just to fix a few bugs
ALTER procedure [dbo].[MakeIndendity](@identityField varchar(50), @fieldsDeclare text,@fieldsSelect text,@tableName varchar(50))
as
Begin
EXEC('CREATE TABLE Tmp_tbl(' + @fieldsDeclare + ')')
SET IDENTITY_INSERT Tmp_tbl ON
EXEC('INSERT INTO Tmp_tbl (' + @fieldsSelect + ') SELECT...
April 29, 2011 at 7:51 am
or just do this
procedure [dbo].[MakeIndendity](@identityField varchar(50), @fieldsDeclare varchar(255),@fieldsSelect varchar(255),@tableName varchar(50))
as
Begin
EXEC('CREATE TABLE Tmp_tbl(' + @fieldsDeclare + ')')
SET IDENTITY_INSERT Tmp_tbl ON
EXEC('INSERT INTO Tmp_tbl (' + @fieldsSelect + ') SELECT ' +...
April 27, 2011 at 12:59 pm
wow over 20 answers to this guys guestion "lol"
April 15, 2009 at 12:57 pm
as long as i row_number works in a where statment thats golden thank u
April 7, 2009 at 5:29 pm
Vladan (4/7/2009)
xgcmcbain (4/6/2009)
April 7, 2009 at 12:55 pm
Jeff Moden (4/6/2009)
jgrubb (4/6/2009)
By definition, identity has gaps, check BOL. If you need sequential id's without gaps, identity is not the way.
Ummm.... you're gonna have to...
April 7, 2009 at 12:49 pm
Tim Wilson-Brown (4/6/2009)
xgcmcbain (4/6/2009)
why would an insert be rolled back? its just a basic insert
Because you have duplicates in your import files 🙂
(See post http://www.sqlservercentral.com/Forums/Topic690671-338-1.aspx)
Every time you load a duplicate,...
April 6, 2009 at 7:22 pm
ohps sorry i wrote that too fast
April 6, 2009 at 11:53 am
Lowell (4/6/2009)
if it's from an application,say from the client-server or web and a session times out....starting...
April 6, 2009 at 10:03 am
Viewing 15 posts - 16 through 30 (of 49 total)