September 20, 2013 at 4:48 am
Based on what I read about Table-Valued Functions it can be used to return modified data from one or more tables in a database. But since they are programmable functions, they can also generate data. Does this mean Table-Valued Functions can be created to prevent applications from accessing tables directly while still providing access to retrieve or modify data?:doze:
September 20, 2013 at 5:14 am
user defined functions in sql server doesn't allow you to perform ddl/dml operations on permanent tables
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
September 20, 2013 at 5:46 am
Thanks you so much for your reply. So this means I need to create a VIEW
September 20, 2013 at 5:57 am
If you're trying to avoid access to a table, maybe stored procedures?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply