Welcome to Binaryworld - A Powerful Knowledge Sharing Platform

Search Code/Page

User Login
Email
Password
Remember Me

Forgot the Password?

Services

» Web Development

» Maintenance

» Data Integration/BI

» Information Management

Programming

VB (1648)

VB.net (736)

C# (15)

ASP.net (779)

ASP (41)

VC++ (25)

PHP (0)

JAVA (4)

JScript (5)

Database

» SQL Server (708)

» ORACLE (5)

» MySQL (0)

» DB2 (0)

Automation

» C/C++/ASM (11)

» Microcontroller (1)

» Circuit Design (0)

OS/Networking

» Networking (5)

» Unix/Linux (1)

» WinNT/2k/2003 (8)

Graphics

» Flash (0)

» Maya (0)

» 3D max (0)

» Photoshop (0)

Links

» ASP.net (2)

» PC Interfacing (1)

» Networking (4)

» SQL Server (4)

» VB (23)

» VB.net (4)

» VC (3)

» HTML/CSS/JavaScript (10)

Tools

» Regular Expr Tester

» Free Tools

Submitted By : Nayan Patel (Member Since : 5/26/2004 12:23:06 PM)

Job Description : He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.

View all (893) submissions by this author (Birth Date : 7/14/1981 )

	How to perform DISTINCT queries on tables that contain BLOB fields like text/image. [ All Languages» SQL Server» T-SQL]
Total Hit (1435)
Rating

	How to determine the table from which a trigger was fired in the trigger itself? This technique can be used to write a common SP that can use the table name identified thus. [ All Languages» SQL Server» Trigger]
Total Hit (2091)
Rating

	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. [ All Languages» SQL Server» T-SQL]
Total Hit (2383)
Rating

	How to write a trigger for INSERT, UPDATE or DELETE operation ? [ All Languages» SQL Server» Trigger]
Total Hit (2336)	Here is very basic code to write trigger for INSERT, UPDATE or DELETE operation on a table. Internally SQL Server manages two tables (inserted and deleted) to perform trigger operations. All inserted records can be retrived by quering "inserted" table «code LangId=6»select * from inserted«/cod ....Read More
Rating

	How to format int or decimal values with commas? [ All Languages» SQL Server» T-SQL]
Total Hit (2727)
Rating

	How to print only the first value in a group of duplicates? [ All Languages» SQL Server» T-SQL]
Total Hit (2253)
Rating

	How to retrieve individual octets from an IP address? [ All Languages» SQL Server» T-SQL]
Total Hit (2331)
Rating

	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. [ All Languages» SQL Server» T-SQL]
Total Hit (2741)
Rating

	How does decimal datatypes differ in their precision & scale? [ All Languages» SQL Server» T-SQL]
Total Hit (1664)
Rating

	How to determine the product of values in a column? [ All Languages» SQL Server» T-SQL]
Total Hit (1808)
Rating

	How to retrieve rows based on a range? This solution doesn't use temporary tables or cursors. [ All Languages» SQL Server» T-SQL]
Total Hit (1518)
Rating

	How to search for strings within XML tags? [ All Languages» SQL Server» T-SQL]
Total Hit (1513)
Rating

	How to transpose columns as rows? This script also demonstrates how to use the CUBE operator. [ All Languages» SQL Server» T-SQL]
Total Hit (1536)
Rating

	How to generate ids for each row - same as the identity column without using temporary tables? [ All Languages» SQL Server» T-SQL]
Total Hit (1342)
Rating

	How to find the minimum value in 3 columns? [ All Languages» SQL Server» T-SQL]
Total Hit (1358)
Rating

	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. [ All Languages» SQL Server» T-SQL]
Total Hit (1547)
Rating

	How not to handle NOT IN queries when there are NULL values? [ All Languages» SQL Server» T-SQL]
Total Hit (2424)
Rating

	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. [ All Languages» SQL Server» T-SQL]
Total Hit (1416)
Rating

	How to strip a text field into several varchar fields? [ All Languages» SQL Server» T-SQL]
Total Hit (1391)
Rating

	How to define a column with a custom time format & verify validity of data using CHECK constraint? [ All Languages» SQL Server» T-SQL]
Total Hit (1432)
Rating

	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. [ All Languages» SQL Server» T-SQL]
Total Hit (2401)
Rating

	How to simplify CHECK constraints? This is an example using some datetime based checks. [ All Languages» SQL Server» T-SQL]
Total Hit (1443)
Rating

	How to convert TIMESTAMP values to numeric? [ All Languages» SQL Server» T-SQL]
Total Hit (11229)
Rating

	How to re-sequence the values in an indexed field? [ All Languages» SQL Server» T-SQL]
Total Hit (1687)
Rating

	How to validate an IP address specified as a character string? [ All Languages» SQL Server» T-SQL]
Total Hit (1482)
Rating

	How to rank items starting with highest value within each group? [ All Languages» SQL Server» T-SQL]
Total Hit (1527)
Rating

	How to forcefully disconnect users from a DB? This script also contains some timing features so that it doesn't run forever. [ All Languages» SQL Server» Server Operations]
Total Hit (3125)
Rating

	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. [ All Languages» SQL Server» T-SQL]
Total Hit (1514)
Rating

	How to concatenate values that are grouped by columns using SELECT statement alone? This method has several restrictions but serves to demonstrate some techniques. [ All Languages» SQL Server» T-SQL]
Total Hit (1586)
Rating