rikimaru110011 Posted September 29, 2011 Share 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 Link to comment Share on other sites More sharing options...
rikimaru110011 Posted September 30, 2011 Author Share Posted September 30, 2011 Plz Link to comment Share on other sites More sharing options...
hannes08 Posted September 30, 2011 Share 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] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now