Search results for query: *

Hi! Can anybody help me in prividing the links for MDX Tutorial. I am very new to it. Thankx in advance. TapKs

Hi! I want to use the Users & Groups of Active Directory of Win 2K in MS-Analysis Server. But in Database Role Manager Window of MS-Analysis Manager I can only acces the Users not the Groups. But I want to use the Groups of Active Directory as Roles in Database Role Manager Window of...

Hi! I am getting an XML output in Query Analyzer which is more that 8000 character, hence unable to see the whole output. CAn I save the output to a text file so that I can see the output ot is there any way I can see the total output in query analyzer. Can anybody help me.. Thanks in...

Hi! while inserting image type data to a table, I am getting the following error : 'Server: Msg 7133, Level 16, State 2, Line 6 NULL textptr (text, ntext, or image pointer) passed to WriteText function.' My table Test is having the colums id int, img image I am executing the following...

Why the output of the following calculation is shown as 0 in query analyser, where as the output should be 0.207 (approx)? select 61*4*31/36500 Can anybody help me out? Thankx in advance

Does Oracle 10g supports Windows NT or Windows 2000? Pl let me know. ANy links are available on it? Thanks in advance. tapks

Dear friends! I am facing a problem while I am trying to read an xml string inside a stored procedure. The length of the xml string is more than 15000 characters. Is there any way I can declare a variable in my stored procedure so that I can use that XML string to read. Please help me in this...

Hi! I have created the linkd Server for Server2. I can able to make a SELECT query on the required table & also able to INSERT data into that table. But unable to DELETE or UPDATE the table. It is throwing the following error while executing the DELETE statement : Server: Msg 7306, Level 16...

HI! In SQL Server 7.0 I can create a table with wrong syntax i.e. create table Test (id int, descr varchar(10),) Can anybody tells me whether this whether it is a feature in SQL Server or so. Pl help. Tap_Ks

I am wkoing in a Server from which I have to access the other Server also. Both the SQL server are of version 7.0. I can able to access the Server2 data from Server1 through Enterprise Manager. But throught a Select statement how can I access the the data of the Server2? I hve added the...

HI! I have one table called TRAN_DET with the following columns : TranDate Date Not Null, TranDesc varchar(50) Not Null, TranVal decimal(10,2) Not Null, TranSts char(1) Not Null The TranSts column stotes either 'C' or 'D'. I am unable to find the summary of the transaction for each date...

Can any once let me know the difference in the features between SQL Server 2000 & Oracle 9i ? Thankx in advance. TapKs

Hi! I am facing a very piculiar problem while using MS SQL Server 7 which is as follows. I have a table having an Identity Column. Through stored procedure I am inserting the data into it & while the record is getting created I want to use the Identity seed generated. The procedure was working...

Hi! I am very new to Oracle. I have installed Oracle 8i in my PC which is having Windows NT 4.0. After installing it the SQL Plus was running fine. After that I have tried to Oracle Developer 2000 in it. After it got installed I have rebooted the PC & found the following error while using SQL...

Hi! How to use timestamp in the table? What is the advantages of the use? Can I get some samples or sites from when I can get info on it. Thanks in advance Tapks

HI! Everytime when I click on the Tables of a Database of an SQL Server in the Enterprise Managre it displayes all the tables including the System tables. Is there any way to stop displaying the system tables. Pl let me know. Thanks in advance. Tap_ks

Hi! Can anybody let me know from which site I can get good db2 tutorial? Thanks in advance.

Hi! I am facing the following problem while trapping the errors. I have a table Test (id int, no int, name varchar(20)) where id & no are the primery keyes. I want to update this table depending on the matching of id & no. I have written the following code to update the same: update test...

Hi! I am facing the following problem while trapping the errors. I have a table Test (id int, no int, name varchar(20)) where id & no are the primery keyes. I want to update this table depending on the matching of id & no. I have written the following code to update the same: update test set...

Hi! I am facing the following problem while creating a table. The warning message is as follows: " Warning: The table 'sh_producto' has been created but its maximum row size (14232) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if...