Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & . NET

Product Description Create and Use Stored Procedures for Optimal Database PerformanceDevelop complex stored procedures to retrieve, manipulate, update, and delete data. Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & . NET identifies and describes the key concepts, techniques, and best practices you need to master in order to take full advantage of stored… Continue reading Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & . NET

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

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

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?

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?

Oracle Database 11g PL/SQL Programming

Product Description Design Feature-Rich PL/SQL ApplicationsDeliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements,… Continue reading Oracle Database 11g PL/SQL Programming

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

Use CAST (or CONVERT) to handle Null Date values in Microsoft SQL Server

In an SQL Server View, a problem is that the DateTime field has many Null values which is causing a problem with the parsing of the data in MSAccess. How to I use CAST (or CONVERT) to handle Null Date values in my SQL Server view? There is a way to use CAST or CONVERT… Continue reading Use CAST (or CONVERT) to handle Null Date values in Microsoft SQL Server

SQL SELECT INTO Statement

The SQL SELECT INTO statement can be used to create backup copies of tables. The SQL SELECT INTO Statement The SELECT INTO statement selects data from one table, creates a new table with the exact structure and size and inserts automatically the selected data into the new table. SQL SELECT INTO Syntax We can select… Continue reading SQL SELECT INTO Statement