Binaryworld - VB, VB.net, ASP, SQL Server Articles, Codes, Tutorials and Programming Resources

Code / Articles / Tutorials for VB, VB.net, SQL Server, ASP.net and VC++

PostedOn	Language	Category	Code Name
01/14/2004	SQL Server	T-SQL	How to perform DISTINCT queries on tables that contain BLOB fields like text/image.
01/14/2004	SQL Server	T-SQL	How to pass a list of IDs & use it like an IN clause?
01/14/2004	SQL Server	T-SQL	How to concatenate values that are grouped by columns using SELECT statement alone? This method has several restrictions but serves to demonstrate some techniques.
01/14/2004	SQL Server	T-SQL	How to find the greatest circle distance? Also shows how to do a simple UPDATE loop. Note that the greatest circle formula is an approximation only.
01/14/2004	SQL Server	Server Operations	How to forcefully disconnect users from a DB? This script also contains some timing features so that it doesn't run forever.
01/14/2004	SQL Server	T-SQL	How to rank items starting with highest value within each group?
01/14/2004	SQL Server	T-SQL	How to validate an IP address specified as a character string?
01/14/2004	SQL Server	T-SQL	How to re-sequence the values in an indexed field?
01/14/2004	SQL Server	T-SQL	How to convert TIMESTAMP values to numeric?
01/14/2004	SQL Server	T-SQL	How to simplify CHECK constraints? This is an example using some datetime based checks.
01/14/2004	SQL Server	T-SQL	How to compare rows in tables without writing a SELECT with all the conditions? Can be used for simple dirty work & of course if you are lazy to type.
01/14/2004	SQL Server	T-SQL	How to define a column with a custom time format & verify validity of data using CHECK constraint?
01/14/2004	SQL Server	T-SQL	How to strip a text field into several varchar fields?
01/14/2004	SQL Server	T-SQL	How to rollup data in a table? There are several ways to do this, here is one way. I think there might be a more efficient way but I haven't worked on it yet.
01/14/2004	SQL Server	T-SQL	How not to handle NOT IN queries when there are NULL values?
01/14/2004	SQL Server	T-SQL	How to find modulus of floating point numbers? This one doesn't calculate the real modulus but this script just demonstrates few techniques. Also contains a sample to find the values before & after the decimal point in a decimal value.
01/14/2004	SQL Server	T-SQL	How to find the minimum value in 3 columns?
01/14/2004	SQL Server	T-SQL	How to generate ids for each row - same as the identity column without using temporary tables?
01/14/2004	SQL Server	T-SQL	How to transpose columns as rows? This script also demonstrates how to use the CUBE operator.
01/14/2004	SQL Server	T-SQL	How to search for strings within XML tags?
01/14/2004	SQL Server	T-SQL	How to retrieve rows based on a range? This solution doesn't use temporary tables or cursors.
01/14/2004	SQL Server	T-SQL	How to determine the product of values in a column?
01/14/2004	SQL Server	T-SQL	How does decimal datatypes differ in their precision & scale?
01/14/2004	SQL Server	T-SQL	How to verify the validity of an IP address presented as a string? The IF part of the check can be used as part of a table's CHECK constraint also.
01/14/2004	SQL Server	T-SQL	How to retrieve individual octets from an IP address?
01/14/2004	SQL Server	T-SQL	How to print only the first value in a group of duplicates?
01/14/2004	SQL Server	T-SQL	How to format int or decimal values with commas?
01/14/2004	SQL Server	Trigger	How to write a trigger for INSERT, UPDATE or DELETE operation ?
01/14/2004	SQL Server	T-SQL	How to get identity kind of values for each row in a query? This technique demonstrates how to use CROSS JOIN, sub-query for counting & does not use temporary tables.
01/14/2004	SQL Server	T-SQL	How to calculate AGE in years? The DATEDIFF function in MS SQL Server gives the distance between year boundaries & as such cannot be used to calculate the age.

(Page 96 of 133)

3985 Result(s) found