Eli Leiba

This user-defined in-line T-SQL function for SQL Server 2000 creates an in-memory sequence flush 1,2,3….N where N is a natural number with a value less than 1000. If N needs to be greater than 1000, the function can be modified to satisfy this as well. Explanation: By using a cross join between three derived tables […]

These procedures are very important to use when you need to load a bulk of data that you know is correct but when you do not need the foreign keys and check constraints to interfere while you are loading the data. This is also the case when you want to change key values and don’t […]

This procedure gets a tablename, column and an integer number N as parameters and finds the Nth maximum value of the column’s value in a table. For example: running it with ‘products’, ‘UnitPrice’ , 13 , @res will get the 13TH largest value of unitprice from products is no such N exist an error message […]

Enabling Full Text search in T-SQL is usually neither as “popular” nor as easy as doing it with the Enterprise Manager, but it can be done. (For more information on full text search in SQL Server, see our article from Alexander Chigrik, Setting Up Full-text Search: A Step-by-step Guide.) Here are the steps you’ll need […]