Recent Articles Developing And Utilizing SQL Naming Standards The format for stored procedure names will be: Pwwddddd where: p the prefix indicating the type of SQL operation as shown below, must be in upper case. ww first two characters of the window name (the processing.... SafeNet Offers HSM That Works With MS SQL Server 08 SafeNet has announced that its Luna SA hardware security module (HSM) now works with Microsoft SQL Server 2008 for greater application security and performance.... Setting Up MySQL Replication This is the second part of an article that I wrote discussing replication in MySQL. The first part of the article was a more general primer on what replication... Finding And Using DateFormat Within SQL Have you ever tried to find a DateFormat or date_format function in SQL Server? Chances are you probably ended up concatenating a bunch of DatePart strings to get the format you are looking for. What about grouping... MySQL Replication Replication is a way to run several SQL servers so that all of them have a current copy of a database or databases. Keep in mind that replication is not the same as... Closing The Open Source Model Of MySQL Okay, I didn't really want to write about Sun again today, but Simon has an interesting post about the "Sun Model" for open source business. Simon states that the model boils down to: "1. remove barriers to software...

03.03.09 Understanding SQL Language Restrictions By Craig Borysowich A. SQL LANGUAGE RESTRICTIONS The following is a list of major NON-ANSI and NON-ODBC SQL syntax provided by SQL Server which must not be used in the System Development Environment (SDE). Do not use: The COMPUTE keyword in a SELECT statement to generate simple reports with summary values. The ALL keyword in a GROUP BY clause. User defined datatypes built on system supplied datatypes. Temporary tables which exist only for the duration of the current work session. The != (not equal) sign.  (Note that SQL Server 4.2 also supports the <> sign, which is ANSI and ODBC compliant.) The ability to nest an aggregate function (e.g., AVG) inside another aggregate function (e.g., MAX). The ability to insert data from a table into that same table. The ability to extract data from one table and put it into another using a JOIN in an UPDATE statement. The ability to remove data based on data in other tables using a JOIN in a DELETE statement. eMetrics Marketing Optimization Summit Register Now The TRUNCATE TABLE statement to delete all rows in a specified table and reclaim the space it took up. The ability to update through views. The ability to scan a table and update its data one row at a time using the clause FOR BROWSE in a SELECT statement. The ability to define a maximum of thirty characters as identifiers of database objects like tables, columns, etc.  (The maximum for ANSI standard is eighteen.) The "duplicate-key" or "duplicate-row" options in the CREATE INDEX statement to control whether duplicate keys/rows are allowed. B. SQL Datatypes The data types which can be used are listed below.  The exceptions are: Text Image Continue reading this article. About the Author: Craig Borysowich has over 18 years of Technology Consulting experience with both public and private sector clients, including ten years in Project Leadership roles. His extensive background in working with large scale, high-profile systems integration and development projects that span throughout a customer’s organization allows him to help consulting organizations world-wide to deliver better quality projects more consistently.

SQLproNews is brought to you by: SecurityConfig.com NetworkingFiles.com NetworkNewz.com WebProASP.com DatabaseProNews.com SQLProNews.com ITcertificationNews.com SysAdminNews.com SQLproNews.com WirelessProNews.com CProgrammingTrends.com SysAdminNews.com About SQLproNews SQLproNews is a collection of up to date tutorials and insightful articles designed to help SQL users of any skill level implement successful SQL systems and practices. SQL Strategies and Tactics for Business

-- SQLProNews is an iEntry, Inc. publication -- iEntry, Inc. 2549 Richmond Rd. Lexington KY, 40509 2009 iEntry, Inc.  All Rights Reserved  Privacy Policy  Legal advertising info | news headlines | free newsletters | comments/feedback | submit article