Problem solve

SQL Transact SQL T SQL

• Using an arbitrary TOP value in SQL Server 2000

  Contributor Serdar Yegulalp shows you how to work around the limitations of TOP keyword stored procedures in SQL Server 2000. Continue Reading

• Stored procedures: Find columns and tables

  Continuing our stored procedure series, this simple routine is handy for finding columns by name and listing the table(s) in which they exist. The listing includes table name, column name, ordinal position, data type, data size, width/precision and ... Continue Reading

• Automatic data type conversion in SQL Server 7 vs. 2000

  SQL Server 7 and SQL Server 2000 evaluate expressions in entirely different ways, making it difficult to construct SQL statements on the fly. Continue Reading

• Stored procedure: Retrieve filtered file lists from a specified directory

  Two code listings create a system stored procedure named sp_ListFiles. The first routine returns a filtered list of files found in a specified directory. The second, a README file. Continue Reading

• Custom user-defined string functions by Igor Nikiforov

  Montreal-based SQL Server programmer has written a number of useful Transact-SQL custom string manipulation functions that can be put to work in a variety of database projects. Continue Reading

• Show names of frequently absent employees

  Continue Reading

• Find a partial string in a field that contains a long string

  SQL Server expert Jeremy Kadlec explains how to use LIKE to find a partial string in a field.Continue Reading

• What are the differences between SQL-89, SQL-92, and SQL-99?

  Continue Reading

• Find S_name & S_marks of which student gets 2nd highest marks in table

  Development expert Andrew Novick explains how to use a TOP clause on a SELECT statement to query a table.Continue Reading

• User-defined functions to generate and apply a table of sequence numbers

  This tip contains user-defined functions that generate a table of sequence numbers and examples of how to apply such a table.Continue Reading

• The ACID test for T-SQL batch statements

  What is the ACID test? It's a test to determine whether a T-SQL statement is valid in Microsoft SQL Server.Continue Reading

• Key differences between SQL CAST vs. CONVERT functions

  Learn how the MSSQL CAST vs. CONVERT functions operate -- and the best time to use each in Microsoft SQL Server.Continue Reading

• Sorting output with CASE expressions for custom sort orders

  Quick tip on using CASE statements with Microsoft SQL Server.Continue Reading

• Using self joins in SQL Server

  Self joins are useful when you have a nested SQL query with the inner and outer queries referencing the same table.Continue Reading

• Five basic SQL Server functions you should be using

  Check out five of the most useful of the many SQL Server system functions.Continue Reading