Viewing 15 posts - 886 through 900 (of 1,048 total)
in this case the max ident value would be 101 as with first insert statement the value of ident was 100 and with another insert statement the ident value would...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 22, 2012 at 12:00 am
nice question to start on Monday with +1 :-):-P
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 21, 2012 at 11:58 pm
good explanation
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 20, 2012 at 12:10 am
easy one
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 20, 2012 at 12:07 am
nice
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 19, 2012 at 11:57 pm
BUt I told to not to change the stored procedure..
just need to pass the column value into variables of SP to insert rows one by one from employees
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 18, 2012 at 9:36 am
how to fetch one by one row using WHILE instead of cursor?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 18, 2012 at 9:32 am
Hi Luis I added code of sthe stored procedure..
plzz find a solution for me
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 18, 2012 at 9:13 am
sp_helptext 'adduser'
CREATE PROCEDURE dbo.AddUser
@PortalID int,
@Username nvarchar(100),
@FirstName nvarchar(50),
@LastName nvarchar(50),...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 18, 2012 at 8:47 am
thanks for the information Gila
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 18, 2012 at 4:29 am
ohhh....
Means if I delete any database then we cant restore it back anyhow?
Is there any way using logs file...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 18, 2012 at 4:14 am
But I dont know that if the backup of that database is exist on sytem or not as I didnt take any backup of that...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 18, 2012 at 4:08 am
thanks beeb...
I am able to migrate the data after deleting data through delete statement rather than using Truncate statement
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 18, 2012 at 4:06 am
thanks for the info Gila
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 18, 2012 at 4:05 am
Hi,
delete from Rolemaster is working and all data gets deleted
But I want that if I disable the constraint of the referencing table and then disable the constraint of RoleMaster then...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 18, 2012 at 12:17 am
Viewing 15 posts - 886 through 900 (of 1,048 total)