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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: wepisan
- Order by date
-
Urgent : Can I create/Open text file from Stored Procedure ?
Hi, Here's the way to write to a file from stored proc: Make sure your are having Service Pack 2 or higher installed. CREATE PROCEDURE usp_WriteToFile( @FileName varchar(255), @Text1 varchar(255) ) AS BEGIN DECLARE @FS int, @OLEResult int, @FileID int EXECUTE...- wepisan
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Openxml question
Hi, Also try adding incident_id to the reporter element as it will help you associate a reporter to incident. Here's the sample: declare @XmlHandle int declare @incident table ( inc_id int, inc_name varchar(25) ) declare @report table ( inc_id int, rep_id int, rep_name varchar(25)...- wepisan
- Post #2
- Forum: Microsoft SQL Server: Programming
-
FunnY Question About service pack of SQL 7.0 :)
Hi, try this procedure CREATE PROCEDURE dbo.usp_get_service_pack_info AS /********************************************************************************************************************************************************* ** dbo.usp_get_service_pack_info ** ** Description: This Procedure...- wepisan
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Why do my newly created tables get created as system tables?
Hi, When creating table try prefixing the owner name before the table. For ex: create table dbo.table1 create table sunny.table2 etc., Hope this helps. Thanks, Vaiyapuri Subramanian- wepisan
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Passing variables in an XML String
Hi, Try the following: declare @XmlHandle int declare @MyTable TABLE ( prequal_id bigint NOT NULL , loan_term_type varchar (15) NOT NULL , borrower_credit_type varchar (30) NOT NULL , loan_rate varchar(6) NOT NULL ) EXEC sp_xml_preparedocument @XmlHandle...- wepisan
- Post #6
- Forum: Microsoft SQL Server: Programming
