Viewing 15 posts - 526 through 540 (of 1,048 total)
Here is the table structure of GV_Voucher for your reference
USE [GVApp]
GO
/****** Object: Table [dbo].[GV_Voucher] Script Date: 05/07/2013 17:32:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 7, 2013 at 6:02 am
ChrisM@Work (5/7/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 7, 2013 at 6:02 am
can you please provide some more details so that we can help you
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 7, 2013 at 3:23 am
ChrisM@Work (5/7/2013)
Four queries in your stored procedure use TOP (n) without ORDER BY. The results may be unpredictable.
Hi Chris, I didn't get your point
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 7, 2013 at 1:23 am
Here is my stored procedure script in which I have to achive isolation:
ALTER Procedure [dbo].[BS_Voucher_CreateVoucher]
@vouchertypeID int = 1,
@denomination int = 100,
@quantity int = 10,
@amountvalue int = 100,
@userid varchar(50) = 1,
@validateDays...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 7, 2013 at 12:41 am
Hugo Kornelis (5/6/2013)
wolfkillj (5/6/2013)
It bears mention that Microsoft has slated the "timestamp" syntax for deprecation in favor of "rowversion"...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 6, 2013 at 11:34 pm
Sean Lange (5/6/2013)
kapil_kk (5/6/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 6, 2013 at 11:23 pm
Lynn Pettis (5/6/2013)
kapil_kk (5/6/2013)
Sergiy (5/6/2013)
kapil_kk (5/6/2013)
Instead of RETURN I have added a SELECT @pSTN statement for the different different conditions and its working 🙂Is it correct?
Yes, it is correct.
In fact,...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 6, 2013 at 11:16 pm
Thanks Vinay for the question... 🙂
I was not aware of the thing that if we use DISTINCT then Column names specified in the ORDER BY clause, must be defined in...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 6, 2013 at 11:12 pm
Sergiy (5/6/2013)
kapil_kk (5/6/2013)
Instead of RETURN I have added a SELECT @pSTN statement for the different different conditions and its working 🙂Is it correct?
Yes, it is correct.
In fact, "RETURN @pSTN "...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 6, 2013 at 7:11 am
Instead of RETURN I have added a SELECT @pSTN statement for the different different conditions and its working 🙂
Is it correct?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 6, 2013 at 2:54 am
Danny Ocean (5/5/2013)
I think author did mention it clearly that execute all statement in a single batch.Due to that i lose my points..:doze:
Me too lose the points 🙁
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 6, 2013 at 12:06 am
malleswarareddy_m (5/4/2013)
If you have foreign key then the reference column value must exists in parent...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 4, 2013 at 5:32 am
Sergiy (5/2/2013)
select @SearchString = REPLACE(@SearchString, LastName, '')FROM ThisTable
select @SearchString
+1 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 3, 2013 at 3:21 am
Please provide us more detail so that we can answer your question more clearly...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 3, 2013 at 3:16 am
Viewing 15 posts - 526 through 540 (of 1,048 total)