hemal_301080 (4/14/2013)

---

I have following 3 table definition with data

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)...

Good question 🙂

+1

Hugo Kornelis (4/12/2013)

---

No, it is not....

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...

Really good question 🙂

+1

have you tried these things from creating sql jobs?

SQLDub (4/10/2013)

---

I answered a QotD correctly and I didn't guess! I am pretty new to SQL development (~6months) but I could see straight away there was an issue with the...

Good easy one 🙂

+1

You can put index on the columns which are using in your WHERE, ON clause ........

Good question Vinay ans as usual gr8 explanation from Hugo 🙂

Same here Vinay, forget about the TEXT datatype part and choose...

Well now I am done with the result that was required 🙂

ChrisM@Work (4/8/2013)

---

kapil_kk (4/8/2013)

---

Hi all, I have to check a condition that if I entered correct first and last voucherno then only it have to perform some operation like insertion.... But...

Hugo Kornelis (4/8/2013)

---

The . actually represents 0.0, with leading...

Hugo Kornelis (4/8/2013)

---

An okay question, I guess. The combination of title, question, and answer options may make it very easy to overlook the actual issue, but if we cannot be...