I'm always into the free resources, as long as you are willing to pour your time into learning.

I started straight from the source: android.com has a lot of of reosurces...

sqlvogel (12/4/2013)

---

That's incorrect. It's not necessary to create a primary key for referential integrity purposes. Referential Integrity is a good thing of course but you can enforce referential integrity against...

at one point, built a .NET project that used the quickbooks connector from http://www.rssbus.com/;

with that, and some minor configuration in quickbooks to allow remote access, i was able to see...

mote.ajit2 (12/4/2013)

---

Hi!

I am trying to call procedure from function but getting following error.

Invalid use of side-effecting or time-dependent operator in 'INSERT EXEC' within a function.

Actually I want table valued function...

sree-226516 (12/3/2013)

---

Hi,

We have a stored procedure which updates table A every 5 mins whole day(9AM to 7PM).Table A has only one day worth data and end of the day it...

karthik babu (12/3/2013)

---

thanks for your interest...

Please check the below code..

set rowcount 40000

Update T1 SET sName = t2.sName

from dbo.t_table1 T1 INNER JOIN dbo.t_table2 T2 ON t1.tID =...

lianvh 89542 (12/2/2013)

---

Good Day,

we use varchar(max) , and I also read Text is to be depricated . My concern is this : You'll have poor performing queries on this column...

is the...

what version is your SSMS tool actually running?

I've seen similar issues with the scripting of objects, where a prior version of SSMS cannot work correctly against a higher version...

sheesh, i know that, explained that lots of OTHER times,...

two primary keys, by definition, would be repetitively redundant 😀 if you think about it.

essentially the primary key's main purpose is to be able to uniquely point to each...

rray 44280 (11/27/2013)

---

I have a query that returns a bunch of rows. I have an sp that takes 3 of the columns in the query as parameters that I want...

JimS-Indy (11/27/2013)

---

It's a left join, so there will be I rows without L rows. In that case, I'm done, and need only one message ('Adding New PO Line to CPAS')....

for a single stored procedure, you would grant view definition on the User in the database(or the role/windows group)

GRANT VIEW DEFINITION ON dbo.DelimitedSplit8K to ClarkKent;

GRANT VIEW DEFINITION ON dbo.DelimitedSplit8K...

Jim i see the join critieria is this:

LEFT JOIN tblPOLine AS L

ON I.POID = L.POID

AND I.POLINENUM =...