Atlanta Custom Software Development 

   Search        Code/Page

User Login



Forgot the Password?
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
VB VB (1648) (736)
C# C# (15) (779)
ASP ASP (41)
VC++ VC++ (25)
JScript JScript (5)
» SQL Server (708)
» ORACLE (5)
» MySQL (0)
» DB2 (0)
» C/C++/ASM (11)
» Microcontroller (1)
» Circuit Design (0)
» Networking (5)
» Unix/Linux (1)
» WinNT/2k/2003 (8)
» Flash (0)
» Maya (0)
» 3D max (0)
» Photoshop (0)
» (2)
» PC Interfacing (1)
» Networking (4)
» SQL Server (4)
» VB (23)
» (4)
» VC (3)
» HTML/CSS/JavaScript (10)
» Regular Expr Tester
» Free Tools

(Page 1 of 24) 708 Result(s) found 


Custom Ranking for Search conditions ( Similar to Full-Text Rank column).
Total Hit (2954) This example demonstrates how to generate some ranking column for string searches. This column can be something like the RANK column generated by the SQL70 Full-Text feature.
Get more than 40 Date/Time formats with SQL Server using Convert function
Total Hit (5587) You can use convert function to format your datetime the only thing you need to to know is format type which is a integer number. This sample output will help you to find your format id quickly.
Dynamic execution of SP ( This method is not well-known ).
Total Hit (2383) This method of dynamic SQL execution is not well-known. This will work from SQL60 & upwards. This is very useful when calling SPs dynamically with parameters of different datatypes, output parameters & return value.
How to pass a list of IDs & use it like an IN clause?
Total Hit (2332)
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.
Total Hit (2646)
How can I use Transact-SQL to programmatically determine the number of processors that my SQL Server computer has?
Total Hit (3031)
How to install MSDE
Total Hit (3938) To install MSDE first extract files to a folder e.g. c:\sql2ksp3 then run folloing command on command prompt c:\>cd sql2ksp3 You can specify installation option either in command line itself or specify in setup.ini «b»[1] Specifying parameters in command line«/b» For example the following ....Read More
DATEFLOOR : Rounding dates to nearest day,hour,minute,second
Total Hit (7041) This function takes a date and a date part parameter and rounds the date down to the nearest date part. Credit goes to "Gordon Klundt" <b>Example:</b> In order to round '2010-11-03 17:44:10.117' to the nearest hour ('2010-11-03 17:00:00.000') «code LangId=6»select dbo.datefloor(cast('2010- ....Read More
Another pivot table example
Total Hit (3336)
An aggregation problem in a topic, seminars & registration scenario.
Total Hit (2444)
Procedure to import SQL Server error log into a table (SQL 2000)
Total Hit (3182) This procedure reads the SQL Server error log using sp_readerrorlog and imports the error log's contents into a specified table. It accepts three parameters: @log_name is the name of the table into which the error log will be imported @log_number is the error log number, 0 is default and refers ....Read More
Using INFORMATION_SCHEMA views to get schema information (i.e. tables, columns, primary keys, foreign keys ...)
Total Hit (4258) INFORMATION_SCHEMA is ANSI standard and most of modern RDBMS support it. You can use INFORMATION_SCHEMA views can be used to get various schema information i.e. Table information Column information Primary Key information etc. <b>How to get list of tables</b> «code LangId=6»SELECT * ....Read More
How to Implement IRR Financial function like Excel IRR in SQL Server using T-SQL
Total Hit (26489) Have you ever wondered how to use same functionality of IRR function of Excel in T-SQL. Well unfortunately there is no inbuilt function in T-SQL but we can create a user defined function to implement the same logic as IRR of Excel/VB. «code LangId=6»create table IncomeTable ( amt float, d ....Read More
This is a link to a different site MDX Essentials: Basic Set Functions: The Order() Function
Total Hit (935) This is the twelfth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs. ....Read More
This is a link to a different site Multiple Paths in Workflow
Total Hit (916) Branching workflow is a common requirement, and is quite easy to achieve using the basic On Success or On Failure constraints available through the designer. However branches go in different directions and do not meet up again.
This is a link to a different site Configuring Disks and Managing Space in SQL Server Part 1
Total Hit (912) Something like fifty percent of system outages are caused by "Out of space" conditions. I kid you not. I run into them all the time. Combine this problem with the need to maintain high availability and peak performance and the consequence is that disk configuration and space allocation become one of ....Read More
This is a link to a different site Disabling or Enabling All Constraints of a Table or Database
Total Hit (1155) 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 want the constraint ....Read More
This is a link to a different site Introduction to Relational Databases - Part 1: Theoretical Foundation
Total Hit (2134) Good introduction on general database theory and design. Lots of terminology (Entity, Attibute, Normalization ...) defined, explained of all...DEMONSTRATED!
This is a link to a different site Troubleshooting SQL Server Alerts
Total Hit (1057) If you have problems with Microsoft SQL Server alerts, review this troubleshooting checklist to find potential solutions.
This is a link to a different site Import Files with Date-stamped Filenames or Paths
Total Hit (1147) DTS packages are fantastic features available in SQL Server 7.0 and SQL server 2000. One outstanding feature in the DTS package is the ability to run ActiveX scripts. ActiveX gives us an added advantage in handling many situations; we will discuss how to handle three of these situations. File-nam ....Read More
This is a link to a different site Exporting SQL Data as XML
Total Hit (3190) In my last article, Importing XML into SQL Server 2000, we looked at various techniques to import the XML data into SQL Server. To complement that, this article will focus on some of the methods that you can use to export relational SQL data to the XML format. More specifically, we'll explore th ....Read More
This is a link to a different site XML and SQL 2000 (Part 3)
Total Hit (1042) In the third article of this series, we will look into executing T-SQL statements against SQL Server 2000 via HTTP. This functionality is provided by SQLXML component (implemented in the form of SQLISAPI.DLL, which is included as part of SQL Server 2000 installation). The updated versions of this co ....Read More
This is a link to a different site Implementing Application Roles
Total Hit (1122) SQL Server 7.0, as well as SQL Server 2000, support several technological feature enhancements that allow for a faster time to completion for database and application development. Application roles exist as SQL Server database objects that allow developers and database administrators to assign SQL S ....Read More
This is a link to a different site How to Create ODBC DSN on multiple SQL server machines
Total Hit (2029) In a typical Client - Server environment it is often necessary to create ODBC DSN on many client machines or servers for front-end applications such as VB, or MS-Access, which uses ODBC DSN for linked tables. Even for creating linked servers to heterogeneous systems like Oracle, Sybase and mainframe ....Read More
This is a link to a different site Dynamic ORDER BY Statements in Stored Procedures
Total Hit (1613) When creating data-driven Web applications, it is ideal to place the actual SQL statements into stored procedures, and to have the Web pages, then, call the appropriate stored procedures rather than executing the SQL statements themselves. (If you are unfamiliar with what stored procedures are, or t ....Read More
This is a link to a different site How do I know what type of index to create?
Total Hit (1228) We get a lot of index questions related to what type of index should be created given a particular situation. I compiled the items below from books-online to facilitate this discussion: Before creating clustered indexes, understand how your data will be accessed. ....Read More
This is a link to a different site Coping with text files and abnormal column or row delimiters
Total Hit (1209) Sometimes you may receive a text file to import that has a row or column delimiter not available in the standard drop-down boxes of the Text File Properties dialog. The first thing to try in these cases is to type directly into the Row Delimiter or Column Delimiter box. This will work fine if th ....Read More
This is a link to a different site Connecting to MS SQL Server from Unix
Total Hit (1011) I've written this page as I keep getting questions on how to access MS SQL Server from Unix. I have never had any reason talk to SQL Server from Unix myself, but since people kept asking me how to do it, I decided to compile an web page with the tiny fragments of information and I have. The main foc ....Read More
This is a link to a different site Data Mining Algorithms: Microsoft SQL Server 2000 vs. "Yukon" SQL Server
Total Hit (1818) This article describes a well-known concept, (Data Mining algorithms, built into Microsoft SQL Server 2000 Analysis Services) and what I would like to see in the final "Yukon" SQL Server release (i.e. my expectations in a field of new / improved data mining algorithms). ....Read More
This is a link to a different site Changing the DataPump Source and Destination Tables
Total Hit (1053) You can use an ActiveX Script to change both the source and destination of the DataPump task. The first thing you need is the Name of the task. Right-click the DataPump task and select Workflow Properties. On the options tab it shows you the step name. The task name is almost guaranteed to be th ....Read More

(Page 1 of 24) 708 Result(s) found  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Recommanded Links


Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.