|
Hello all, i have a three tables user,aspnet_user,and aspnetmembership table and i made my table name myapplicationuser which contins colum similer to that of the three tables. Now from Store procedure i want to check those data in tables user,aspnet_user,and aspnetmembership and not in myapplicationuser and insert into myapplicationuser , i.e check if exist if not insert it (from stored procedure)
|
|
|
|
|
Try using IF EXISTS statement.
IF Not exists (select 1 from tablex where columny = 'z')
begin
insert ....
end
else
begin
update ...
end
Bob
Ashfield Consultants Ltd
|
|
|
|
|
whats wrong with this one why is it opening a new sqlqury ide
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[copyuser]
AS
SET NOCOUNT ON;
DECLARE @iRowId int, @userName NVARCHAR(100)
DECLARE usercursor1 CURSOR FOR
SELECT UserID,Username FROM users
print 'reached here'
OPEN usercursor1
FETCH usercursor1 into @iRowId,@userName
WHILE @@Fetch_Status = 0
BEGIN --loop started
PRINT @userName
IF not EXISTS (SELECT 1 FROM Esso_UserInfo WHERE UserName=@userName)
BEGIN --if started
PRINT 'not exist'
END --if closed
ELSE
BEGIN --else started
PRINT 'exist'
END --else closed
FETCH usercursor1 into @iRowId,@userName
End --loop closed
CLOSE usercursor1
DEALLOCATE usercursor1
RETURN
|
|
|
|
|
justintimberlake wrote: whats wrong with this one
No idea. Where does it go wrong?
justintimberlake wrote: why is it opening a new sqlqury ide
Again, no idea.
A tip, don't use cursors they slow processing down enormously. Try running updates first and then inserting where not exists.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
it just opnes a new sqlquery editor and shows return value 0
|
|
|
|
|
hey its ok the stored procedure works
|
|
|
|
|
Hello everyone,
I need ur help to write a trigger. I have 3 tables (Ex: Employee master,Employee salary details and Employee in_out details),if i update any value in the Employee master table, the value must be automatically updated in other related tables.
Plzzzzzzzzzz help urgent!!!!!!
Thanks.
|
|
|
|
|
Jesu Prabhu.J wrote: Plzzzzzzzzzz help urgent!!!!!!
Not, its not urgent.
Jesu Prabhu.J wrote: I need ur help to write a trigger.
So write your version and if it doesn't work post it and someone will help. A clue, you need a trigger on Employee for insert and update which will select the values from the inserted table and update the other two tables.
There you go, now google triggers.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I am using SQL Server 2000, If i change any value Ex: Employee Name in the (Employee Master) the value Employee Name must get updated in the other 2 tables..
Thanks for the Reply..
|
|
|
|
|
Jesu Prabhu.J wrote: I am using SQL Server 2000, If i change any value Ex: Employee Name in the (Employee Master) the value Employee Name must get updated in the other 2 tables..
Yes, I assumed you were using SQL Server. You still need a trigger on Employee Master. There are hundreds of examples on Google.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Plzzzzzz help me out with this problem, i have to store special symbols like integral, sigma, pi etc in tha database. I'm using the nvarchar datatype, but getting unexpected results..
Thanks in advance...........
|
|
|
|
|
I think using nvarchar should be sufficient.
Although you'll not be able to see these characters in 'Query Analyzer' or 'Enterprise Manager' (you will see boxes instead) but when this data is called by client application e.g. C# you can see correct depiction of the character.
Razov
|
|
|
|
|
I am viewing these values in a rich textbox, but it displays ?? when the application is run.I'm using VB.net 2008
|
|
|
|
|
Is your VB.NET project Unicode enabled?
Razov
|
|
|
|
|
How do one check if VB.net project is Unicaode enabled, Plzzzz help..
|
|
|
|
|
Click Advanced Save Options Encoding should be Unicode (UTF-8).
Razov
|
|
|
|
|
Firstly i thank u,for the help. Again i am facing the problem, there is no Advanced Save Options under the File menu...
|
|
|
|
|
Try Save As option for solution there you can check for Encoding option.
Razov
|
|
|
|
|
Thanks a ton, for ur timely help. Looking forward for your help in future also...
Bye n Thanks once more..
modified on Tuesday, September 16, 2008 6:30 AM
|
|
|
|
|
Hello
I've inserted many records while testing and now I want to start indentity column from 1.
How can it be possible??
Please Reply,
Thanks 
Syed Shahid Hussain
|
|
|
|
|
I believe if you truncate the table that will do it.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
<br />
DBCC CHECIDENT (tablename, RESEED, 0)
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Thanks But
I'd tried (test is table name)
DBCC CHECIDENT (test, RESEED, 0)
and also
DBCC CHECIDENT ('test', RESEED, 0)
And receive this error message
Server: Msg 2526, Level 16, State 2, Line 2
Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options.
have u any idea about that?
Thanks
Syed Shahid Hussain
|
|
|
|
|
My apologize it iwas my write mistake,the syntax is: DBCC CHECKIDENT (tablename, RESEED, 0)
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
Oh! Now It works Goooooooooooooooooooooooooooooooooood.
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)