Tag: MS SQL Server

T-SQL 2008 Joes 2 Pros: Core T-SQL Coding Fundamentals For Microsoft SQL Server 2008

Product Description Joes 2 Pros turns SQL students into SQL certified experts. This is the original SQL book that began it all. A newer second edition of this book has been reprinted with a lower price under the new title, “Beginning SQL Joes 2 Pros”. It has the same images, explanations, practices, and quizzes as… Continue reading T-SQL 2008 Joes 2 Pros: Core T-SQL Coding Fundamentals For Microsoft SQL Server 2008

Can I install Oracle 9i, Oracle 10g, and SQL Server 2005 in one machine?

Oracle 9i – 9. 2 Enterprise (Developer edition)Oracle 10g -10. 2 Enterprise (developer edition)SQL Server 2005 Developer EditionI already installed the 9i and SQL Server 2005, with the appropriate services stopped (set to manual). I am planning to install 10g on the same machine and set the appropriate services to manual. Can I have them… Continue reading Can I install Oracle 9i, Oracle 10g, and SQL Server 2005 in one machine?

Pro T-SQL 2005 Programmer’s Guide

Product Description Pro T-SQL 2005 Programmer’s Guide provides comprehensive and detailed coverage of all the major features and facilities of T-SQL for SQL Server 2005. It is designed for all users of T-SQL, database administrators, systems administrators, application developers, and end-users, who want to learn how to exploit the power of T-SQL. Whatever you need… Continue reading Pro T-SQL 2005 Programmer’s Guide

Pro T-SQL 2005 Programmer’s Guide

Product Description Pro T-SQL 2005 Programmer’s Guide provides comprehensive and detailed coverage of all the major features and facilities of T-SQL for SQL Server 2005. It is designed for all users of T-SQL, database administrators, systems administrators, application developers, and end-users, who want to learn how to exploit the power of T-SQL. Whatever you need… Continue reading Pro T-SQL 2005 Programmer’s Guide

SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach

ISBN13: 9781590599808 Condition: NEW Notes: Brand New from Publisher. No Remainder Mark. Product Description SQL Server 2008 Transact–SQL Recipes: A Problem–Solution Approach is an example–based guide to the Transact–SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author… Continue reading SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach

How do I get started in writing/programming in T-SQL?

I am completely confused on what T-SQL really is and how it is different from SQL and its variants. How do you guys program something using T-SQL language? I mean where do you actually ‘encode’ those T-SQL codes? In cobol I use notepad as the programming environment. Do I need to download something like that… Continue reading How do I get started in writing/programming in T-SQL?

SQL Server 2008 T-SQL Debugger

The Transact-SQL debugger in SQL Server Management Studio enables you to find errors in Transact-SQL scripts, stored procedures, triggers, and functions by observing their run-time behavior. You can start the debugger when you are using the Database Engine Query Editor window. By using the Transact-SQL debugger, you can do the following: • Step through the… Continue reading SQL Server 2008 T-SQL Debugger

Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable web sites using ASP.NET and SQL Server

ISBN13: 9781430223832 Condition: NEW Notes: Brand New from Publisher. No Remainder Mark. Product Description Ultra-Fast ASP.NET presents a practical approach to building fast and scalable web sites using ASP.NET and SQL Server. In addition to a wealth of tips, tricks and secrets, you’ll find advice and code examples for all tiers of your application, including… Continue reading Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable web sites using ASP.NET and SQL Server

T-SQL: How do I find the greatest values in a column?

How can write a SELECT statement that finds the n greatest values in a column? From what i’ve read, the TOP statement only returns the first n rows, it doesn’t take any regard to the values. For example, if a have a column with ages, i want to be able to find the 5 oldest… Continue reading T-SQL: How do I find the greatest values in a column?

Valid styles for converting datetime to string

I wrote this little table and procedure to help me remember what style 104 did, or how to get HH:MM AM/PM out of a DATETIME column. Basically, it populates a table with the valid style numbers, then loops through those, and produces the result (and the syntax for producing that result) for each style, given… Continue reading Valid styles for converting datetime to string