Problem solve

SQL Transact SQL T SQL

• Find the product of a field in Microsoft SQL Server

  This function will produce the product of a field or set of values in SQL Server 2000. Continue Reading

• Avoid joining tables on a range in SQL Server

  An example of a query to avoid: Even when columns are indexed and the result set is only one row, SQL Server can choke. Continue Reading

• Adding an ORDER BY clause to a view in SQL Server

  Microsoft says that you cannot put an ORDER BY clause in the view definition with SQL Server. True...unless you do the following trick! Continue Reading

• SQL Server parameter passing fix

  Options for fixing SQL Server parameter passing problems, such as setting an environment variable in the windows operating system, are offered in this tip. Continue Reading

• Writing T-SQL functions to SQL Server system schema

  Writing T-SQL functions to a SQL Server system schema for use by the entire server is explained. Continue Reading

• Passing parameters using simple T-SQL XML parsing

  Describes an alternative way of passing a varying number of input parameters from one T-SQL stored procedure to another by using the built-in OPENXML T-SQL row set statement.Continue Reading

• Write query results to Excel using a linked server and T-SQL

  A SQL Server procedure that can be used as a general tool for exporting data to an Excel spreadsheet since the bcp utility can only export to a text file.Continue Reading

• Error with RESTORE DATABASE in vb.net code

  Continue Reading

• UDF for getting a column list for INSERT statements

  Learn about the SQL Server UDF gets a column list for any table within the current database.Continue Reading

• Using T-SQL instead of menus or shortcuts in Query Analyzer

  Continue Reading

• Exporting T-SQL scripts from command line

  Continue Reading

• Reseeding identities in SQL Server

  Here are some tips to use and pitfalls to avoid when using IDENTITY columns as primary keys in SQL Server tables.Continue Reading

• Split delimiter-separated lists with a T-SQL UDF

  Creating and parsing lists of items in a string is a frequent request. Here's a SQL Server UDF that does it.Continue Reading

• Using the SQL Server INFORMATION_SCHEMA view

  Here's how to get the columns from the primary key of a SQL Server table along with the column's data type information.Continue Reading

• An easy way to move T-SQL to Java?

  Continue Reading