SQL 2005 / SQL Server Mgmt Studio "Script Table as"

Last Post 05 Feb 2009 09:56 AM by jbelisle. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
jbelisle
New Member
New Member

--
05 Feb 2009 09:56 AM
Greetings,
In SQL Server Mgmt Studio there is a feature to "Script Table as" let say SELECT...ie

SELECT [au_id]
,[au_lname]
,[au_fname]
,[phone]
,[address]
,[city]
,[state]
,[zip]
,[contract]
FROM [Pubs].[dbo].[authors]

Are there some system calls within SQL DBMS that we can call to quickly gain access to these same scripting functions? Id like to make simple T-SQL calls to build some dynamic SQL based on these scripting outputs...don't wont to recreate the wheel if I don't have to.

Thanks in advance,
JB

You are not authorized to post a reply.

Acceptable Use Policy