Viewing 15 posts - 376 through 390 (of 1,048 total)
Voide (7/16/2013)
riya_dave (7/16/2013)
hiselect * from tableA with(nolock) a
join tableB with(nolock) b
on a.id = b.id
where a.date > getdate()
i am getting error incorrect syntax near a
As Gail said, why nolocks?
Also alias...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 17, 2013 at 1:18 am
Hi Riya, its better if you keep of your old data in some temp table and then insert the new data....
first insert the old data into a temp table...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 17, 2013 at 12:54 am
Shadab Shah (7/17/2013)
kapil_kk (7/17/2013)
vinu512 (7/16/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 17, 2013 at 12:47 am
vinu512 (7/16/2013)
-- Enable...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 17, 2013 at 12:17 am
Hi,
as per the explanation- The stmt "return (select 5)" gives error because in a batch RETURN with integer_expression is not admitted (note: PARENTHESIS cast the SELECT to an integer_expression for...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 16, 2013 at 11:58 pm
sa.ordekci (7/16/2013)
Should I use below bode?set @isexist=(select count(*) from GNL_OgretmenDevamsizlikGirisLog
where OgretmenID=@ogretmenID
and DersYiliID=@dersyiliID
and SinifID=@sinifID
and DersID=@dersID
and
Convert(date,GirisTarihi) = Convert(date,getdate())
)
if(@isexist>0)
begin
end
I think Chris have already done your homework... refer his post please
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 16, 2013 at 6:40 am
Your stored procedure was executing as you didn't specify any parameters in that sp...
Please refer Luis post...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 16, 2013 at 6:20 am
Can you please post the execution plan?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 16, 2013 at 5:38 am
Sorry, I am not clear with your requirement 😉
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 16, 2013 at 3:01 am
yes, you can create database and database objects with the role dbcreator...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 16, 2013 at 1:33 am
Ed Wagner (7/15/2013)
The RAISERROR simply throws the error. To terminate processing in a stored procedure, you should fire a RETURN.
yes, that why now am insteady of choosing severity 20...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 15, 2013 at 11:19 pm
Good start of the day with the easy one 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 15, 2013 at 11:18 pm
Actually first I tried with Batch Abort but it did nt work for me.......
SET XACT_ABORT On;
select 'yes'
RAISERROR('yes',20,1)
select 'yes'
RAISERROR('NO',16,1)
SELECT 'NO'
When error raises then also all select statements gets executed so...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 15, 2013 at 6:55 am
Thanks Wegner for your suggestion...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 15, 2013 at 6:52 am
Thanks for your replies I got it now 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 15, 2013 at 5:17 am
Viewing 15 posts - 376 through 390 (of 1,048 total)