Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server > Samples & Scripts


Search:
What's New - What's Hot
SQL Server Integration Services (SSIS) - Scripting in SSIS Packages  Version: 0.00     Price: $0.00  
Total Hits: 11  |  Today: 0Author: Karthikeyan Anbarasan      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes the scripting option available with SSIS, which is nothing but the Script Task component in SSIS. The very cool feature available in SSIS packaging is the Script Task, to justify is many task components are available which performs a single operation as per the nature of the task. But with this Script task we can perform our own custom task on how the process should happen as per the business. We will see the step by step process on how to use this task....

A Small Utility to Generate Cascading Delete SQL Script in Oracle  Version: 0.00     Price: $0.00  
Total Hits: 7  |  Today: 0Author: ronald.cao@gmail.com      Rating:  
Read Reviews | Write Review |  Your Rating: 

Recently I was doing data fixes for my client, which required to delete data in tens of tables. There tables have reference tables, which have reference tables, which have reference tables ... To delete a table, I had to delete its reference tables first, to delete its reference tables, I had to delete the reference tables' reference tables first and so on. In one case, there are six levels deep and 220 tables to delete first in strict order. I created the utility to generate the cascading delet...

Copy text or image into or out of SQL Server     
Total Hits: 203  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, I want to show, how you can copy a single text or image value into or out of SQL Server by using the textcopy.exe utility. You can find this utility in the directory containing the standard SQL Server EXE files (C:\Mssql\Binn for SQL Server 6.5, by default and C:\Mssql7\Binn for SQL Server 7.0, by default)....

Finding the Nth Maximal Value     
Total Hits: 616  |  Today: 0Author: Eli Leiba      Rating:  
Read Reviews | Write Review |  Your Rating: 

This T-SQL procedure takes a tablename, column and an integer number N as parameters and finds the Nth maximum value of the column's value in a table....

Form Based Authentication in MOSS2010 Against SQL Server Database  Version: 0.00     Price: $0.00  
Total Hits: 7  |  Today: 0Author: Ravishankar      Rating:  
Read Reviews | Write Review |  Your Rating: 

Here you will see Form Based Authentication in MOSS2010 Against SQL Server Database....

VBScript Interfaces in SQL Server 2000 Let You Transform Data and Provide Reports to Your Users  Version: 0.00     Price: $0.00  
Total Hits: 8  |  Today: 0Author: Alok Mehta and Daniel Williams      Rating:  
Read Reviews | Write Review |  Your Rating: 

Application service providers often must send information to clients automatically rather than on-demand. For example, a manufacturer may want to know each day how many of their products were sold by a retail chain. While SQL Server is ideal for maintaining this type of database, you have to write scripts to get the data out in a client-friendly format. Here you will see how you can use Data Transformation Services (DTS), a powerful tool in SQL Server, to automate the retrieval and formatting of...

How to Write SQL to Dynamically Script Mass INSERT Statement Scripts  Version: 0.00     Price: $0.00  
Total Hits: 10  |  Today: 0Author: Josh Calderonello      Rating:  
Read Reviews | Write Review |  Your Rating: 

The following is an article that describes a unique approach of scripting out the contents of a table.

The reasons for doing so are many. The context that I will provide is one where you have a development environment where static tables exist for the purpose of storing application lookup data (i.e. a ZipCode table), but the contents of the table change often enough that it is often tedious to modify an INSERT script you may have saved off somewhere....

Script Component as Data Source  Version: 0.00     Price: $0.00  
Total Hits: 7  |  Today: 0Author: Dinesh Asanka      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you were asked what are the data sources that you can use as a data source for SQL Server Integration Services (SSIS), you may say list the out of the box data sources such as, SQL Server Oracle, DB2 etc and flat files such as Text files and CSV files or Excel. If that is your answer it is correct but only half correct, because you can use data source by using the script component in the SSIS data flow task. This article shows few real world examples of how you can use the script component as...

three email Sending script in C# .NET     
Total Hits: 96  |  Today: 0Author: Ritesh Shah      Rating:  
Read Reviews | Write Review |  Your Rating: 

there are several ways, secured and unsecured , to sending an email from C#. there are three ways given here....

SQL Server function to determine if all characters in a string are capitalized     
Total Hits: 185  |  Today: 0Author: Tim Ford      Rating:  
Read Reviews | Write Review |  Your Rating: 

Working with strings in SQL Server is not as simple as you would hope for a lot of things that you need to do with text data. It is sometimes simpler to do a lot of these things outside of SQL Server, but if you have time and patience to write T-SQL code you could just about do anything you need to do. One of my programmers asked if there was a way to determine if all characters in a string were capitalized. I was not able to find an existing function so I figured I'd create my own. Take a lo...

Locking in SQL Server 6.5     
Total Hits: 76  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, I want to tell you about general details of SQL Server 6.5 locking, about Transaction Isolation Level, what kind of Transaction Isolation Level exists, and how you can set the appropriate Transaction Isolation Level, about Lock types and Locking optimizer hints, about Lock Escalation, about Deadlocks, about how you can view locks with sp_lock stored procedure, and how you can set insert row lock for a particular table or tables....

Using UNION ALL statement in SQL Server 6.5     
Total Hits: 56  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you use OR logical operation to find rows from a SQL Server 6.5 table, and there is index on the field for which values you use OR operation, then SQL Server 6.5 can use worktable with dynamic index on searchable field instead simple index search. You can check it by setting SET SHOWPLAN ON. So, if the table is very big, it can take a lot of time....

SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example     
Total Hits: 190  |  Today: 0Author: pinaldave.      Rating:  
Read Reviews | Write Review |  Your Rating: 

Yesterday I posted small note about SQL SERVER - 2005 Best Practices Analyzer (July BPA). I received many request about how BPA is used. Some of readers has asked me to provide sample tutorial which can help start using BPA. This utility has many uses for best practice. I have created very simple and initial tutorial.

I encourage to follow that and once used it create your own reports in your desired format. Do not hesitate to install this add-on as I have use this previously to tune our ...

Scripting SQL Server 2000 Indexes     
Total Hits: 161  |  Today: 0Author: Ron Talmage      Rating:  
Read Reviews | Write Review |  Your Rating: 

Adding indexes to tables is the most effective way to optimize your SQL Server query performance. Tables that you query often may require several indexes in order to handle the various search arguments you send. There is one particular situation where indexes on large tables are a hindrance, though. When you're bulk-copying data into the table, it's best to have either no index at all, or just a clustered index. For those situations it is best to use Transact-SQL scripts to remove and add those ...

VBScript Interfaces in SQL Server 2000 Let You Transform Data and Provide Reports to Your Users     
Total Hits: 548  |  Today: 0Author: Alok Mehta and Daniel Williams      Rating:  
Read Reviews | Write Review |  Your Rating: 

Application service providers often must send information to clients automatically rather than on-demand. For example, a manufacturer may want to know each day how many of their products were sold by a retail chain. While SQL Server is ideal for maintaining this type of database, you have to write scripts to get the data out in a client-friendly format. Here you will see how you can use Data Transformation Services (DTS), a powerful tool in SQL Server, to automate the retrieval and formatting of...

Disk Space Alert Script      
Total Hits: 892  |  Today: 0Author: Harry Parkinson      Rating:  
Read Reviews | Write Review |  Your Rating: 

Monitor the free disk space on your SQL Server and send an alert via email or net send if the available space on any of the drives SQL Server resides on is lower than the specified limit. The script could also be scheduled as a job to provide 24/7 monitoring. Supports SQL Server 7 or 2000....

Convert String to Table/Array Script     
Total Hits: 1262  |  Today: 0Author: R. Rasu      Rating:  
Read Reviews | Write Review |  Your Rating: 

This function splits a string by a specified delimiter and returns the separated values as a table or array....

Problem with GO statements in SQL scripts  Version: 0.00     Price: $0.00  
Total Hits: 4  |  Today: 0Author: Morris Bahrami      Rating:  
Read Reviews | Write Review |  Your Rating: 

Recently, I was working on an installer application which, as part of its job, would update the database based on a SQL script. When running such scripts from the .NET environment, you would get a SqlException as it does not like the GO statements within your script. The way around that is to split your script into pieces separated by GO and run each piece separately....

Sql Script Generator in C# From SQL Table ,get the SQLTable name And Generate The Insert and Update Script  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: idreesbari      Rating:  
Read Reviews | Write Review |  Your Rating: 

Sql Script Generator in C# From SQL ,MS Access, FoxPro ,MySql etc Table Generator SQL Script Generator Generates the SQL Scripts to run on sql query analizere these queries of only insert and update this class still not contain Delete query but u can change according to ur requirement....

Enterprise Services, SQL Script Editing  Version: 0.00     Price: $0.00  
Total Hits: 6  |  Today: 0Author: Ken Spencer      Rating:  
Read Reviews | Write Review |  Your Rating: 

I have lots of experience developing ASP applications that use Visual J++® components wrapped in COM running in Microsoft® Transaction Services (MTS). I am currently developing an application with the Microsoft .NET Framework and have written several classes that perform the bulk of my data access. I then use these classes in my ASPX pages. This application will have as many as 10,000 concurrent users....


1  2  3  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net