Search results for query: *

Do you know if M/S SQL Server 2000 has Column Level Security With out views? Can you prevent someone from viewing a given column on the actual table? Thanks!

Transact SQL is a dialect of T-SQL written by Sybase. Outside of minor syntax changes, and variables, they are IDENTICAL. They refer to the same thing as Oracles very different PL-SQL offering. It is a database programming language written mainly for stored procedures. If you have to ask...

I have some questions, and would be very grateful if someone could help me. 1. How different are the COBOLs on DOS/VSE and iSERIES? 2. How different are the CICS libraries? 3. What would you say are the major problems concerning a conversion from DOS/VSE to O/S 400 on the iSERIES? Steve

Yeah, I used to LOVE VMS! It was the ONLY fully self contained standardized O/S I have ever seen. It is the only one that was: MULTIUSER/TASKING with detached processing (sure UNIX has this, but most don't) STANDARD SHELL (UNIX tends to have at least 2 favored shells, and several flavors of...

Frankly, *I* would recommend having a program do the inserts, but I think you want to use 2>error_output_filename to get input from std_err instead of >normal_user_output_filename to get input from std_out You can even have both if you want. Steve

First, rycamor was 100% correct with the explanation. I would add just a few things. SOME people feel that deleting an autoincremented key should cause it to reuse that number. Both sides have their own reasons. However I would give you THIS example: Suppose that ID is used as a customer...

Your question is very hard to understand, so I will try to cover many possibilities. You can have many users use the sameuser/ password on the same or different databases, and many users/ passwords on the same or different databases. Each password can be limited to a particular originating...

Yeah, I forgot. Sub queries ARE standard SQL, and not CURRENTLY supported in MYSQL. In MY uses of mysql, and many other real world places, it isn't much of a limitation. In a reporting app, for example, the sub query may be run seperately to load a selection list, and the items selected from...

I got TIRED of all the things in thrid party libraries that didn't work. One used features that ANSI apparantly changed(and gcc 3.1 TRASHED all the old TRUE standards). One provided a trial library that was STRIPPED, so I couldn't use it. I had problems elsewhere, SO...... I wrote my OWN...

MYSQL is the BEST trade off of price(actually, its father WAS free and is STILL less capable, but is now MORE expensive!), performance(can be one of the fastest), capabilities(it lacks foreign keys, and SUPERSET features), compatible(perhaps THE most compatible), and simplicity(one of the...

Interesting how people talk about MYSQL like it is a TOY! It is a nice database, and getting better. *I* have noticed some defaults that are set for speed AT ALL COSTS, and have found that bypassing some of them get rid of some desire for more endowed databases, while still maintaining speed...

MYSQL is thought of as web specific because that is where many seem to use it. It is no more/less geared to the web than any other. As for A.I., one organization claimed to have one as intelligent as a 3 year old, last I heard. This is patently absurd. Besides, if it were really that smart...

Win98 DOES have a network. As does ANY computer that can connect to the internet directly. If you set NOTHING up, or you want the ULTIMATE in network security, just set it up as your default loopback IP: 127.0.0.1(aka localhost or [local] or LO or loopback) That is a standard that ALL...

The previous answer is not an answer to the problem. Your REAL problem is probably that it is legally probably impossible. It is VERY rare, at best, that free services give you ANY access to dynamic pages. As for the UNIX thing? This is what M/S REALLY wants! To trick guys like you into...

Basically, there are four reasons for not using the Email address: 1. Inefficient(numbers take less space, and are faster to check.). 2. Insecure. (do you REALLY want your email address all over the place?) 3. It could change! Ideally, keys should NEVER change! 4. Not unique (A person could...

Almost NO database can handle varchar greater than 255.(M/S SQL SERVER, SYBASE, ORACLE(as I recall), MYSQL, and many others can't do this. On the otherhand, MOST(including MYSQL, M/S SQL SERVER, SYBASE, and ORACLE) can handle TEXT fields that are much larger. Use TEXT! BTW, you can probably...

Your app sounds EARILY like mine! Right down to ALL the numbers! Mine has a little over 1205000 records though.(although almost 4000 records were in my first version, and I still haven't pared down the table as much as I want.). You wouldn't happen to be writing a search engine? Look at the...

XML is a LOT of HYPE! It, like Java, is being touted as a panacea, and is being claimed to be great for things that it will NOT work well with. I DID write a metadata extraction program that took a complicated denormalized database representing conversion metadata, and outputted this as a...

That statement about mysql and sybase isn't exactly true. Try this: select a.name,c.name,a.length,a.prec,a.scale,a.isnullable from syscolumns a,sysobjects b,systypes c where a.id=b.id and c.xtype=a.xtype and b.name='CUSTOMERS' order by colorder The above statement gives metadata (field name...

Mysql doesn't know one language from another. However Many languages(ESPECIALLY ones that had not accepted the latin alphabet(such as russian or greek)), will have odd characters. It is very likely that incompatible programs could cause such a failure to occur. This is why UNICODE is now...