rikimaru110011 0 Posted September 29, 2011 Hi all, I need creat table in SQL 2000 + 2005,and drop it 1/CREATE TABLE #errorlog ([a] [int] IDENTITY (1, 1) NOT NULL, ErrorText nvarchar(4000), ContinuationRow int) 2/INSERT INTO #errorlog EXEC sp_readerrorlog 3/SELECT TOP 10 * FROM #errorlog order by a desc 4/drop table #errorlog and i use $con = _SQLConnect($ip,"master",0,"sa",$pass) $str1 ="select * from test" _SQL_GetTable2D($con,$str1,$result,$hang,$cot) ;here i need create table, or drop it _SQLDisconnect($con) i have result query $str1, but i need create table Thanks all, rg Share this post Link to post Share on other sites
hannes08 39 Posted September 30, 2011 Hi rikimaru110011, have a look at the _sql.udf by ChrisL (search for it in the forum) You'll need to run your statements in a _SQL_Execute(). Regards,Hannes[spoiler]If you can't convince them, confuse them![/spoiler] Share this post Link to post Share on other sites