Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by kennethc
-
%type in T-SQL?
Yeah, thanks for the reply mfairchild. That's what I kinda thought. :Ken- kennethc
- Post #3
- Forum: Microsoft SQL Server: Programming
-
%type in T-SQL?
Does T-SQL have a operator that is similar to the %TYPE procedure variable in PL/SQL? Thanks! :Ken- kennethc
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
2 easy questions...
Thank Paul, That gives me another option in the future. I was able to figure another way of doing it. I just created a .bat file that executed the stored proc with the parameters to remove the headers (-h-1), comments (nocount), and pipe output (-O). This is acutually better, since ultimately...- kennethc
- Post #3
- Forum: Microsoft SQL Server: Programming
-
2 easy questions...
1) Is there anything in MSQL similar to a 'spool' cmd in Oracle? I want to save query results to a file, thats all. 2) How can I turn the headings off in query results. I know about the -h-1 option, but how do I do this in a query? Thanks.- kennethc
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
