Transact-SQL Syntax Conventions

T-SQL Syntax Gotchas

Syntax Validation

SQL Server CREATE TABLE syntax diagrams

Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough to put off the most resolute of code-cutters. However, there is a goldmine of information there, and Phil had an ambition to get at it, and share the gold. The result is this article, full of railroad diagrams.

10 tips on converting MS SQL queries to MySQL

The syntax of SQL queries in MS SQL and MySQL are similar but not identical. This article discovers 10 most popular differences between MS SQL and MySQL syntax.

RE: Permissions in sql server 2000 (URGENT)

Hi Sheilish,Only once did I need to get around the limitation of this "dco" security scheme regarding identity_insert where I required strict accountability of the sequential identity numbers (for 1 table in 1 application).If you need to do this you can custom code around it as follows.  Unfortunately I don't have a generic solution since […]

RE: How can I kill a process

Rollback means it's rolling back. Likely something is stuck. Did you check for blocks? If KILL doesn't do it, you'd have to do a restart to end the process.

RE: Restoring Database Problems

A message box appears to me , only with this...Microsoft SQL-DMO(ODBC SQLState : 42000 )An internal consistency error occcurred. Contact Techinal Support for assistance.Backup and restore operation terminally abnormally.ok button...I tried to restore a backup from disk, but the file was restored from a tape.

RE: T-SQL and Microsoft Query

That message is OK to ignore.  It just means that Query analyzer can't display it in the Query By Example (QBE) area.  The CASE statements are too complex for it to represent.You'll get similar messages if you create UNION queries, and often if you're doing pivot/crosstab type queries.  The query will most likely run ok since […]

RE: Problem with Linked Server

Thanks for the link to further details on how to set this up. As it turns out, security on the objects in the Access database were not being enforced. I was able to map to 'Admin' with a NULL password without having to point to the system.mdw file in the registry.CSDunn