Our IT Dept. won't allow direct quaries on our Agile PLM Database, but they said they can create a "View" for me. I'm not too familiar with SQL Views is this something that can be used to setip EPDM Queries via T-SQL? has anyone done this?
The view is a virtual table which will allow to you to perform queries.
CREATE VIEW (Transact-SQL)
Would the View need to be refreshed or is it a Live Query?
It is a live query.
Have a look at this. Database Design - Views & indexes
Awesome, they will work perfectly for what I need thhn!
Retrieving data ...