Eugene Elutin (3/7/2012)

---

It's not a good design to email from a trigger. You're killing performance of update. If I would be MS i would not allow to call xp_sendmail from...

Alexander G. (2/29/2012)

---

The job does not execute any ddls at all.

Can you confirm...

tobbens (2/28/2012)

---

I’d like to create several views using the command below, but would like a loop that goes through a list of client IDs, i.e. TA, TB, TC etc and...

maheshkrishnas (2/21/2012)

---

Hi all,

I have to write storeprocedure program should create a file.if not just show these results when we run the SP

store_salesstore_stat.csv target

StoreProduct SalesStoreAvg Sales TV Avg SalesDVD

S1TV...

zwheeler (1/31/2012)

---

Hi

I have a cursor and I am trying to understand it. I have a couple of questions. here is the beginning of the cursor

DECLARE Cur1 CURSOR FAST_FORWARD FOR

...

Frankly, I would think the book(s) you might want to read would depend largely on your aim here... solve a few sql related problems or pursue a career change.

I'm...

bobba (1/31/2012)

---

I have SSMS version 10.50.1617.0 (MSFT SQLServer 2008 R2) on my workstation. I want to install SQL Server 2008 R2 Express with Tools.

Are there any concerns (especially w/SQL...

The db_datareader role is a fixed database role that grants read access to all...

SQLTestUser (9/15/2011)

---

I am trying to add a null column and set it to a default value of 0

with

ALTER TABLE X add acolumn smallint NULL Default '0'

but when...

It all depends on your background...

Nooooob (9/6/2011)

---

I want to duplicate a row in table 1 changing only the uniqueidentifier (this I can do).

Table 2 has many rows of data attached to this uniqueidentifier...

jdowling 65301 (8/29/2011)

---

How do I pass @UNC to another query?

use @UNC

set nocount on

SELECT CAST((ISNULL(SUM(CAST(hsi.itemdatapage.filesize AS Numeric(15,4))),0)/1024/1024/1024) AS NUMERIC(15,6)) as Storage

FROM hsi.itemdata, hsi.itemdatapage, hsi.doctype

WHERE hsi.itemdata.itemnum = hsi.itemdatapage.itemnum

AND hsi.doctype.itemtypenum = hsi.itemdata.itemtypenum

--AND hsi.doctype.itemtypenum...

Sorry, I should point out that my expected results are actually:

key_value=1

test_value=3

I would have thought the report would need to be changed anyway seeing as it will now be referencing a Column that no longer exists?

I would think a view would be the cleanest way to go with this. Remove access to the base table, create the view omitting the column in question and simply...