SQL 2005 server, how to save queries in a table for future programmatic Access

[benz_jie2005]

---

is it possible in SQL 2005 server to save queries files or structure like tables folder wherein my queries from different tables will be save for my future access with my program?, like for example in MSAccess wherein there's a table categories and also with Queries based from tables..wherein I could directly use my query files to save my data to different tables as what is being structured or link in my queries.

any help from you guys can help me a lot..i'm new to sql server 2005 database set-up..

Thanks
Ben

Thanks

[silent-kill]

you can use stored procedure..

also there is this thing called table look-up..
where a bunch of queries returns a " virtual table"..[br]Posted on: June 07, 2007, 06:37:23 AM_________________________________________________y ou can use stored procedure..

also there is this thing called table look-up..
where a bunch of queries returns a " virtual table"..

[digitalsuperman]

for queries, you can use a "view" instead of a stored procedure..

[hybrid_X]

for table-nd-queries i think everytime when BACKUP function executed ma save na nmo ang table-def/queries including data, for specific queries in ss 2k5 ma save na nmo in .SQL FORMAT or pd pud .TXT in case in future naa ka plan i execute ang T-SQL sa sqlcmd.

visit: www.msdn.com