|
|
|
| You are here : HOME > SQL > General |
 |
 |
Introducing Microsoft® SQL Server® 2012
Price : Click to see price
Average
Customer Rating : Not
yet rated |
|
Editorial Review :
Introducing Microsoft® SQL Server® 2012 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management. This book is for anyone who has an interest in SQL Server 2012 and wants to understand its capabilities, including database administrators, application developers, and technical decision makers.
Customer Review :
No review yet |
 |
Learning PHP, MySQL, and JavaScript: A Step-By-Step Guide to Creating Dynamic Websites (Animal Guide)
Price : $39.99 $22.70
Average
Customer Rating : Not
yet rated |
|
Editorial Review :
If you know HTML, this guide will have you building interactive websites quickly. You'll learn how to create responsive, data-driven websites with PHP, MySQL, and JavaScript, regardless of whether you already know how to program. Discover how the powerful combination of PHP and MySQL provides an easy way to build modern websites complete with dynamic data and user interaction. You'll also learn how to add JavaScript to create rich Internet applications and websites.
Learning PHP, MySQL, and JavaScript explains each technology separately, shows you how to combine them, and introduces valuable web programming concepts, including objects, XHTML, cookies, and session management. You'll practice what you've learned with review questions in each chapter, and find a sample social networking platform built with the elements introduced in this book.
This book will help you:
- Understand PHP essentials and the basics of object-oriented programming
- Master MySQL, from database structure to complex queries
- Create web pages with PHP and MySQL by integrating forms and other HTML features
- Learn about JavaScript, from functions and event handling to accessing the Document Object Model
- Use libraries and packages, including the Smarty web template system, PEAR program repository, and the Yahoo! User Interface Library
- Make Ajax calls and turn your website into a highly dynamic environment
- Upload and manipulate files and images, validate user input, and secure your applications
Customer Review :
No review yet |
 |
Sams Teach Yourself SQL in 10 Minutes (3rd Edition)
Price : $24.99 $12.75
Average
Customer Rating : Not
yet rated |
|
Editorial Review :
Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in applying the SQL language. Forta¿s examples are clear and his writing style is crisp and concise. As with earlier editions, this revision includes coverage of current versions of all major commercial SQL platforms. New this time around is coverage of MySQL, and PostgreSQL. All examples have been tested against each SQL platform, with incompatibilities or platform distinctives called out and explained.
Customer Review :
No review yet |
 |
Microsoft® SQL Server® 2008 T-SQL Fundamentals (PRO-Developer)
Price : $49.99 $25.98
Average
Customer Rating : Not
yet rated |
|
Editorial Review :
Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance—including exercises and code samples—that show you how to develop code to query and modify data. You’ll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries.
Discover how to:
Apply T-SQL fundamentals, create tables, and define data integrity Understand logical query processing Query multiple tables using joins and subqueries Simplify code and improve maintainability with table expressions Explore pivoting techniques and how to handle grouping sets Write code that modifies data Isolate inconsistent data and address deadlock and blocking scenarios Customer Review :
No review yet |
 |
PHP and MySQL Web Development (4th Edition)
Price : $54.99 $27.99
Average
Customer Rating : Not
yet rated |
|
Editorial Review :
PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications. PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server. This practical, hands-on book includes numerous examples that demonstrate common tasks such as authenticating users, constructing a shopping cart, generating PDF documents and images dynamically, sending and managing email, facilitating user discussions, connecting to Web services using XML, and developing Web 2.0 applications with Ajax-based interactivity. The fourth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP 5 through version 5.3, such as namespaces and closures, as well as features introduced in MySQL 5.1.
Customer Review :
No review yet |
|
More
Results : 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 [Next] [Last]
Quick Link : 40 | 60 | 80 | 100 | 120 | 140 | 160
|
|
Questions & Answers
Question : SQL query _ I just wanted to know the general query for the following with the table names A,B,C?
I wanted to know the sql query for the followingFor all cases where the same reviewer rated the same movie twice and gave it a higher rating the second time, return the reviewer's name and the title of the movie.
Answer:
Table Movie, Table Review, Table Reviewer. In each table a record is identified by column ID. Foreign keys have the format fk_table.A Reviewver can have multiple reviews, each review is for one movie only, and of course a movie can have multiple reviews.Select count(*) as Reviews, Reviewer.ID, Reviewer.Name, Movie.TitleFROM Reviewer INNER JOIN Review ON Review.fk_Reviewer = Reviewer.ID INNER JOIN Movie ON Movie.ID = Review.fk_MovieGROUP BY Reviwer.IDHAVING (COUNT(*) > 1)The selection whether the 2nd review was better than the 1st will probably be needed to do programmatically (loop through the reviews and compare rating and review date).
|
Question : Why is the integer time stamp of excel and sql off by one digit,Excel is one digit higher?
Excel formula *****= today()***** Formatted as generalSql formula = *****convert(int,Getdate())*****
Answer:
Date/Time functions use the EPOCH date (seconds since 1/1/1970 12:00 AM)Excel, however, is off by a day (tracking back to epoch in excel returns 1/0/1900 - a non-existent date).Subtract 1 day from Excel datetime to get it right.
|
Question : How can i change all collation in PHP My Admin With One SQL command?
Hii want to change my collation from latin1_general_ci to latin1_swedish_ci.but i have 200 tables in my database!!!!i found this topic:http://answers.yahoo.com/question/index?qid=20090319040418AAGvbXzbut i want to change all of them in One SQL command.please help me.
Answer:
I don't believe it can be done with ONE SQL statement, but I may be wrong. Here is a simple PHP script to do the task for you. $v) {mysql_query("ALTER TABLE $value COLLATE latin1_swedish_ci") or die('MySQL Query Error: ' . mysql_error());}}echo 'All Tables in database, have successfully been altered.';?>Formatted Version: http://pastebin.com/QYxmeAKLCheers,Gitlez
|
Question : What is SQL Injection and How does one accomplish this for penetration testing?
I am interested in SQL injection to maintain secure and safe networks as well as secure software. Does anyone have any general information to help me learn more about this phenomena?
Answer:
SQL Injection is a trick to inject SQL query/command as an input possibly via web pages. Many web pages take parameters from web user, and make SQL query to the database. Take for instance when a user login, web page that user name and password and make SQL query to the database to check if a user has valid name and password. With SQL Injection, it is possible for us to send crafted user name and/or password field that will change the SQL query and thus grant us something else. Try to look for pages that allow you to submit data, i.e: login page, search page, feedback, etc. Sometimes, HTML pages use POST command to send parameters to another ASP page. Therefore, you may not see the parameters in the URL. However, you can check the source code of the HTML, and look for "FORM" tag in the HTML code. You may find something like this in some HTML codes:You should look for pages like ASP, JSP, CGI, or PHP web pages. Try to look especially for URL that takes parameters, like:http://duck/index.asp?id=10Start with a single quote trick. Input something like:hi' or 1=1--Into login, or password, or even in the URL. Example:Login: hi' or 1=1-- Pass: hi' or 1=1-- http://duck/index.asp?id=hi' or 1=1--If you must do this with a hidden field, just download the source HTML from the site, save it in your hard disk, modify the URL and hidden field accordingly. Example:If luck is on your side, you will get login without any login name or password. Let us look at another example why ' or 1=1-- is important. Other than bypassing login, it is also possible to view extra information that is not normally available. Take an asp page that will link you to another page with the following URL:http://duck/index.asp?category=foodIn the URL, 'category' is the variable name, and 'food' is the value assigned to the variable. In order to do that, an ASP might contain the following code (OK, this is the actual code that we created for this exercise):v_cat = request("category")sqlstr="SELECT * FROM product WHERE PCategory='"& v_cat &"'"set rs=conn.execute(sqlstr)As we can see, our variable will be wrapped into v_cat and thus the SQL statement should become:SELECT * FROM product WHERE PCategory='food'The query should return a resultset containing one or more rows that match the WHERE condition, in this case, 'food'.Now, assume that we change the URL into something like this:http://duck/index.asp?category=food' or 1=1--Now, our variable v_cat equals to "food' or 1=1-- ", if we substitute this in the SQL query, we will have:SELECT * FROM product WHERE PCategory='food' or 1=1--'The query now should now select everything from the product table regardless if PCategory is equal to 'food' or not. A double dash "--" tell MS SQL server ignore the rest of the query, which will get rid of the last hanging single quote ('). Sometimes, it may be possible to replace double dash with single hash "#".However, if it is not an SQL server, or you simply cannot ignore the rest of the query, you also may try' or 'a'='aThe SQL query will now become:SELECT * FROM product WHERE PCategory='food' or 'a'='a'It should return the same result.Depending on the actual SQL query, you may have to try some of these possibilities:' or 1=1--" or 1=1--or 1=1--' or 'a'='a" or "a"="a') or ('a'='a
|
Question : Can I establish my own Futures Market Database by manually typing in price feeds and allow general public use?
Currently I am in the process of establishment so I want to minimize my costs. I do not have exact idea about the rules so I request the person who knows about it. I am not in position to pay heavy costs for Commodity Futures Market Data. I want to feed it into my database manually and then develop a technical analysis software that will take End of Day Data from my database. I want to make available that application/technical analysis software to general public free of cost. Anybody knows that can I establish my own database like this and then make it available to general public for use for free? That Java application will be emeded into my web site and SQL Sever will act as the backend tool to keep the full data.
Answer:
I'm afraid there is no way you could keep up with the volume of data coming in during the trading day if you tried to type prices in manually. There are just too many coming in. As you know, the Exchanges charge heavily for access to 'live' trading data. They back that data up with licences, if they find you are putting the data through analysis software they will come after you with lawyers. They don't care whether you're charging or not.End of Day data is easier to get hold of, most Exchanges will allow you to download it direct from their websites for free. In theory you could develop your own technical analysis software, but the Exchanges are likely to tie you into a legal agreement. Also, you will be up against dozens of large companies who provide the same service on a much bigger scale. If you manage to develop software that does something new (and patent your development!) you might be able to take them on. They charge for their product, but are likely to offer SLA level reliability and support guarantees that you will not be able to match as a sole trader.
|
Question : The answer is not general but particular. It would be much better if it brought out a sql query for example?
The answer is not general but particular. It would be much better if it brought out a sql query for example?
Answer:
SELECT question FROM yahoo_answers WHERE text = "incomprehensible"
|
Question : how this error be resolved "General SQL error.C:\WINNT\TEMP/iba02036"?
This error is appearing when we open the accounting package which runs through lan
Answer:
You'll need to elaborate by indicating which accounting program, what operating system is on the computers, which windows server are you using, etc.
|
Question : Which pays more in general.... Oracle or SQL?
Which pays more in general.... Oracle or SQL?
Answer:
Oracle generally.There are various levels of DBA's and database positions that pay different rates of course, but on a lateral comparison, Oracle will usually take the honors of highest salary.Microsoft products are, by nature, easier to learn/use. Thus, with a more difficult/robust product (i.e. - Oracle), pay will be commeasurate with the skill set involved to perform the job adequately. Oracle also runs mostly on Linux/Unix, so a knowledge of those operating systems is a must (and conversely, Windows 2000/2003 Server for MS SQL).Oracle certifications are generally harder (even with less tests), as they include a hands-on 'lab' portion in which you actually must apply the knowledge you're being test on; whereas MCDBA (SQL Server) and the new MCITP certs are strictly written tests only.If you are persuing a career as a DBA/Data Architect/Business Intelligence Developer/Data Analyst/etc, it is always helpful to know more than one product. Oracle and MS SQL Server 2000/2005 are an excellent combination, and many larger companies have systems that run on both platforms. DB2 and MySQL are two other excellent secondary choices.Whatever RDBMS you choose to learn, be sure to have a solid foundation of relational database theory first. Understanding how databases work and how to map their architecture out properly will only aid you in learning whichever system you choose more quickly. Also know whatever corresponding OS is involved as well as you can beforehand. There are many excellent vendor neutral books on the topic that I'm sure you could find on amazon.com or at your local bookstore. I also recommend bookpool.com for any technology books. Great prices, a ridiculous selection, and fast shipping.Hope this helps.
|
Question : in SQL or general programming, if no math is planned, just store number as string?
If you're storing a number, like someone's phone number, 8675309, which will never have math applied to it, should the number be stored as a string instead? Whether in a database or variable?
Answer:
Absolutely. A phone number isn't really a number; it's a string. Storing it as a number will only lead to complications later. For instance, what if the number you want to store starts with a zero? Or two zeroes? That distinction will be lost if you store it as a number.Only store numbers as numbers. Never store something that's not really a number as a number.
|
Question : How this error be resolved "General SQL error.C:\WINNT\TEMP/iba0286, Server is window 2000 & user xp,
How this error be resolved "General SQL error.i/o error for file C:\WINNT\TEMP/iba02..., the server is window 2000 and problem appearing on XP, accounting package is Galileo India Accountant.
Answer:
I got the same error. I backed up all my data and reinstalled windows xp. Now I have windows vista thats better and works much faster
|
Powered by Yahoo! Answers
|
|
