Trainee SQL (12/11/2013)

---

No guys my Requirement is to make it null not to check whether it is null.

From the front end i will pass the values but at times i...

Goto Tools-> Customize window, click on "Commands"

you can reset all the...

OnlyOneRJ (12/11/2013)

---

I am able to see like below

File File File File File Edit Edit Edit Edit Edit File File File Tools Tools Tools Tools Tools Tools

in tool bar of...

nice question, it would help those who only uses the shortcut 🙂

Thanks for sharing

As the User Define table Types are created as table-valued, so you cannot assign null to a table.

2ndly if you want to check if there is any value in the...

if you need to know it in detail then you can refer to the following link

https://www.simple-talk.com/sql/learn-sql-server/showplan-operator-of-the-week---lazy-spool/

+1 , Excellent question its make you dig 🙂

thanks for sharing

you need to set the "DataElementName" property for that particular column(s) to your Desire Name

By Default its set to Blank and set the "DataElementStyle" property to "Element".

hope its helps.

hoseam (12/9/2013)

---

twin.devil (12/9/2013)

---

hoseam (12/9/2013)

---

twin.devil (12/9/2013)

---

you the maintaining your data Month wise, you need a way to segregate this data annual wise, you have PAD which represent month, which you do...

Igor just said there is a try-catch construct available in SQL Server. The OP did not say whether...

1) Why did you select 9001 rather than 9000 for new rows 4,5 and 6 in desired-results?

2) In desired-results rows 1-3 and 7-10, why aren't you returning values from TableB.FieldC?...

ahaan nice, thats why your procedure is in the silent mode 🙂

try to execute your procedure without TRY CATCH to...

hoseam (12/9/2013)

---

twin.devil (12/9/2013)

---

you the maintaining your data Month wise, you need a way to segregate this data annual wise, you have PAD which represent month, which you do not have...

share the complete error which is being generated while executing this file

you the maintaining your data Month wise, you need a way to segregate this data annual wise, you have PAD which represent month, which you do not have a column...