Viewing 15 posts - 601 through 615 (of 1,048 total)
hemal_301080 (4/14/2013)
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [voucherDr](
[srno] [int] IDENTITY(1,1) NOT NULL,
[vouchertype] [nvarchar](50) NULL,
[voucherprefix] [nvarchar](50) NULL,
[voucherno] [int] NULL,
[drparty] [int] NULL,
[dramount] [float] NULL,
[invoicetype] [nvarchar](50)...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 15, 2013 at 5:52 am
Good question 🙂
+1
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 13, 2013 at 9:58 pm
Hugo Kornelis (4/12/2013)
PurpleLady (4/12/2013)
Actually deprecated does not mean removed - it means currently supported but will be removed in future versions. So SOAP is a valid type.
No, it is not....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 12, 2013 at 7:02 am
AS per the explanation:
"You can create three payload types in SQL Server 2012: TCP, Service Broker, and Database Mirroring endpoints. SOAP endpoints were removed in SQL Server 2012."
When I refer...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 12, 2013 at 12:00 am
Really good question 🙂
+1
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 11, 2013 at 1:47 am
have you tried these things from creating sql jobs?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 10, 2013 at 7:12 am
SQLDub (4/10/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 10, 2013 at 6:57 am
Good easy one 🙂
+1
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 9, 2013 at 11:23 pm
You can put index on the columns which are using in your WHERE, ON clause ........
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 9, 2013 at 6:32 am
Good question Vinay ans as usual gr8 explanation from Hugo 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 9, 2013 at 4:48 am
Danny Ocean (4/8/2013)
I don't see the table definition carefully and choose incorrect option.:angry:Any way Good question, keep it up; 🙂
Same here Vinay, forget about the TEXT datatype part and choose...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 8, 2013 at 11:20 pm
Well now I am done with the result that was required 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 8, 2013 at 5:50 am
ChrisM@Work (4/8/2013)
kapil_kk (4/8/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 8, 2013 at 5:50 am
Hugo Kornelis (4/8/2013)
kapil_kk (4/8/2013)
For the first part I understand the behavior but am still confused with the SELECT ISNUMERIC('.+') -- Returns 0 behavior 🙁
The . actually represents 0.0, with leading...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 8, 2013 at 2:17 am
Hugo Kornelis (4/8/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 8, 2013 at 1:16 am
Viewing 15 posts - 601 through 615 (of 1,048 total)