This is very simple query to find Nth Maximum number from a Table. For example, using this query, we can identify the 5th, 8th or Nth highest paid employee of an organization.
2007-09-06 (first published: 2007-04-29)
975 reads
This stored procedure uses a series of input parametes to generate, and optionally execute a series of SQL commands to move production data to an archive table. The procedure assumes that the production and archive tables will have the same structure. The procedure uses the following input parameters:@SourceTable: This is the name of the table […]
2007-09-05 (first published: 2007-04-26)
4,110 reads
The script scrapes out all default constraints (optional for particular column, table or script generation for the whole db) in SQL Server 2005 manner. Based on: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro2k/html/sql00a11.asp
2007-09-03 (first published: 2007-04-25)
594 reads
To Retreive List of Default Constraints from current database with PRINT or DROP
2007-05-04 (first published: 2007-04-20)
553 reads
2007-05-07 (first published: 2007-04-20)
241 reads
This is a generalised Function that will return a String in Proper Case [Camel Case]. Means Afetr every space, first later will be in UPPER Case.Example:Input String: 'microSoft sql server'Output String: 'Microsoft Sql Server'
2007-05-09 (first published: 2007-04-19)
22,298 reads
If you're like me and find XML a bit of an acronym minefield, Robyn Page's Cribsheet will help sort out your XSLT from your XDM.
2007-04-16
2,866 reads
This function splits a delimited string (up to 4000 characters long) into a single column table. The delimiter can be specified at the time of execution. If not specified, the delimiter defaults to a comma. The default length of each value is 100, but that can easily be changed.An example for usage:DECLARE @string NVARCHAR(4000)DECLARE @instruments […]
2007-05-25 (first published: 2007-04-10)
5,689 reads
Have you ever wanted to ensure that keywords in your data are easily searchable? Have you struggled with full-text search? New author Michael Ahmadi brings us an interesting idea for a keyword tracking and searching subsystem based on T-SQL and triggers.
2008-02-21 (first published: 2007-04-09)
12,115 reads
2015-11-10 (first published: 2007-04-05)
461 reads
By Vinay Thakur
As Open Source – PostgreSQL and AI is a growing and powerful DB system,...
By gbargsley
A New Chapter: Why I Made the Move from Dayforce to ESO Over the...
By Vinay Thakur
When you have a project or system, it has to be optimized, tuned, and...
Hub Cs:0817825533 Jl. Jendral Sudirman No.106, Imopuro, Metro, Kota Metro, Lampung 34111
Hub Cs:0817825533 Jl. Yos Sudarso No.100, Bumi Waras, Kec. Bumi Waras, Kota Bandar Lampung,...
Hub Cs:0817825533 Jl. Dokter Sutomo No.50-50A, Ps. Jambi, Kec. Ps. Jambi, Kota Jambi, Jambi...
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers