Even better, don't use loops. :hehe:

UnbalancedKarma (3/22/2012)

---

http://www.codeproject.com/Articles/10135/Not-Another-C-Versus-VB-Article?msg=3050761#xx3050761xx

The article is the usual C#/VB snobbery and in-fighting but the linked reply makes some good points in the case for VB.NET.

Comparing the two is always invitation for a...

One other point, it looks like you are referencing numbers with string values. This means that sql has to make an implicit conversion over and over. You should remove the...

That looks interesting. If you try that please post back...

GuruGPrasad (3/22/2012)

---

Yes Sean Lange

Each and every action . Exactly what we get in CDC.

Delete Statement

Insert Statement

...

Eugene Elutin (3/22/2012)

---

GuruGPrasad (3/22/2012)

---

Hi Sean Lange,

I think i can't use Triggers. Because, The values of Master table will be updated every time a record is inserted / updated / deleted...

Please don't cross post. Direct all replies to the original thread here. http://www.sqlservercentral.com/Forums/Topic1270724-8-1.aspx

If you roll your own with triggers make sure you do some research about how to avoid the common mistake of assuming there is only 1 row being modified at...

This should help. http://msdn.microsoft.com/en-us/library/aa933299%28v=sql.80%29.aspx

This should help. http://msdn.microsoft.com/en-us/library/aa933299%28v=sql.80%29.aspx

Or better than triggers look into Change Data Capture (CDC).

http://msdn.microsoft.com/en-us/library/bb522489.aspx

Well that would certainly point out the queries that use select * then. 😀

Didn't think about that Lowell. Maybe even rename the original base table so the new view can have the name of the base table currently so that no code has...

You could create a view that does not include the column you want to hide. Grant select to the view to the users role. Then deny select to the base...

Depending on your split function you might take a look at the string splitter link in...