|
|
|
|
|
Total Hits: 161 | Today: 0 |
Author: Abhisek Panda
|
Rating:
|
|
|
A query result can include data from multiple tables. To combine data from multiple tables, you can use the JOIN operation from SQL. The JOIN operation matches the rows of one table with rows of another table, based on values in those rows....
|
|
|
|
Total Hits: 400 | Today: 0 |
Author: Carvin Wilson
|
Rating:
|
|
|
The SQL Distributed Management Objects (SQL-DMO) provide a set of OLE objects that enable applications to use management features of SQL Server. This functionality helps to extend the capabilities of SQL Server by providing access to any 32-bit OLE-compliant application. This article gives an overview of SQL-DMO and provides a demonstration on how to access SQL-DMO via Active Server Pages (ASP)....
|
|
|
|
Total Hits: 440 | Today: 0 |
Author: chirag
|
Rating:
|
|
|
Populating Data Warehouses and Data Marts
- Merging Data from Heterogeneous Data Stores
- Cleaning and Standardizing Data
- Building Business Intelligence into a Data Transformation Process
- Automating Administrative Functions and Data Loading...
|
|
|
|
Total Hits: 389 | Today: 0 |
Author: Sandesh S
|
Rating:
|
|
|
A SQL Server CMS is just a central repository that holds a list of managed servers. SQL Server 2008 SSMS introduces a new feature, Multiple Server Query Execution, in Query Editor. Centralize the management and administration of a number of SQL Server instances from a single source can allow the DBA to save significant time and effort. This feature intends to increase the productivity of running same query against multiple servers at once. Some of usage includes: Configure group of servers Gener...
|
|
|
|
Total Hits: 350 | Today: 0 |
Author: : Alwyn
|
Rating:
|
|
|
In this article, I have listed the steps to increase the performance of the queries.
If one follow these guidelines, he can boost the performance of the queries which are taking longer time for execution....
|
|
|
|
Total Hits: 119 | Today: 0 |
Author: Abhisek Panda
|
Rating:
|
|
|
A trigger is a special kind of stored procedure that executes automatically when a user attempts the specified data modification statement on the specified table. Miccrosoft SQl server allows the creation of triggers for any given INSERT, UPDATE or DELETE statement....
|
|
|
|
Total Hits: 497 | Today: 0 |
Author: Sundar
|
Rating:
|
|
|
I faced the issue in the Excel download of my Dotnet Application where the rows were split up in to second line for some records and not for all. The data is from output of a stored procedure in SQL server database....
|
|
|
|
Total Hits: 223 | Today: 0 |
Author: Brett Burridge
|
Rating:
|
|
|
The Transact SQL Coalesce function is an extremely useful piece of syntax to know as it can be used in place of other longer SQL Server syntax.
Given a number of arguments, the Coalesce function will return the first argument that does not have a value of null. Note that if all of the arguments are null, Coalesce itself will return null!
Incidentally, the case function can often be used instead of coalesce - see the article "How to use the SQL Case function"....
|
|
|
|
Total Hits: 179 | Today: 0 |
Author: Brett Burridge
|
Rating:
|
|
|
Since strings are normally enclosed within single quotes in Transact SQL, it can be a problem if the string's text contains an apostrophe within it, such as the query below:
SELECT *, FROM Products WHERE ProductName = 'King's Jalapeno Peppers'
Obviously this SQL query would fail due to the apostrophe in the ProductName. Thankfully though, the solution is simple - just put two apostrophes in the string, as shown below:
SELECT *, FROM Products WHERE ProductName = 'King''s Jala...
|
|
|
|
Total Hits: 89 | Today: 0 |
Author: Randy Dyess
|
Rating:
|
|
|
An often over-looked method to help prevent SQL Injection attacks is the use of parameterized stored procedures. This first article in a two-part series briefly discusses the use of a parameterized stored procedure to help prevent SQL Injection attacks during your web site logon process....
|
|
|
|
Total Hits: 105 | Today: 0 |
Author: Ehsanul Haque
|
Rating:
|
|
|
Nowadays, SQL injection is a big threat for websites. It is a technique by which hackers can execute dangerous SQL commands by taking advantage of un-sanitized input opportunities in web application. While there is a good amount of best practices to prevent SQL injection in ASP.NET, ASP has very little information. In this article, Ehsanul examines a quicker and easier way to sanitize input parameters as well as the design plan for a new website to protect from SQL Injection. After a brief intro...
|
|
|
|
Total Hits: 271 | Today: 0 |
Author: Vic Mackey
|
Rating:
|
|
|
This is an extended stored procedure for Microsoft SQL Server 2000 that implements an optimized MD5 hash algorithm. It is intended to work much like the MySQL MD5() function. The algorithm was taken from here. I only added the md5_string() function. The DLL should work for older versions of SQL Server too, although I have not tested that. The source was compiled and tested on Microsoft Visual C++ 6.0 and .NET 2003....
|
|
|
|
Total Hits: 615 | Today: 0 |
Author: Srdjan Vujosevic and Robert Laberge
|
Rating:
|
|
|
Many handheld wireless devices such as cellular phones and PDAs already have the ability to access Web sites. So how do you build Web applications that tap this wireless audience? Although there are a number of limitations to wireless devices—such as screen size, navigation, and connection speed—you can use familiar Web development technologies to make your existing Web applications available to mobile users.
This article outlines the services and equipment currently available to support wire...
|
|
|
|
Total Hits: 181 | Today: 0 |
Author: Alex Homer
|
Rating:
|
|
|
This is the third and final article in a series of three that look at how the latest version of Microsoft’s enterprise-level database, SQL Server 2005, now offers great support and close integration with XML as a data persistence format. This includes new ways to validate, store and query XML documents that are stored within the database. SQL Server 2005 provides native support for XML that can vastly improve application performance, while supporting robust and safe multi-user access to the data...
|
|
|
|
Total Hits: 244 | Today: 0 |
Author: Carvin Wilson
|
Rating:
|
|
|
The SQL Distributed Management objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks using programming and scripting languages. The first article in this series entitled "Using the SQL Distributed Management Objects", provided an overview of SQL-DMO. This article expands upon those concepts by showing you how to use SQL-DMO to create an Active Server Page application to backup and verify a SQL Server database....
|
|
|
|
Total Hits: 369 | Today: 0 |
Author: John Peterson
|
Rating:
|
|
|
While it's not strictly ASP news... the worm is affecting businesses large and small:
The "Slammer" virus is an Internet worm targeting un-patched Microsoft SQL Server 2000 and MSDE 2000 systems resulting in a high volume of network traffic on both the Internet and private internal networks.
A patch resolving the vulnerability has been available for some time and yet many systems remain vulnerable. If you're running SQL Server or any version of MSDE, make sure you patch it imm...
|
|
|
|
Total Hits: 172 | Today: 0 |
Author: Muhil
|
Rating:
|
|
|
1. To add System.Data.Linq.
In Solution Explorer, right-click References, and then click Add Reference And System.Data.Linq assembly
2. Add the following directives
using System.Data.Linq;
using System.Data.Linq.Mapping;
3. In your class...
|
|
|
|
Total Hits: 495 | Today: 0 |
Author: Alwyn
|
Rating:
|
|
|
Concurrent Data Access is nothing but a set of users accessing the same resource at the same time.
This requires something to prevent the impact when a set of users tries to modify resources which are being used by other users....
|
|
|
|
Total Hits: 561 | Today: 0 |
Author: Sandesh S
|
Rating:
|
|
|
This DBCC command checks the allocation and structural integrity of
the primary database file....
|
|
|
|
Total Hits: 340 | Today: 0 |
Author: Sandesh S
|
Rating:
|
|
|
Prevent Saving Changes is a new option being introduced in SQL Server 2008. This option helps in preventing the unexpected modifications that can happen on a table which includes dropping & re-creating the table.
By default, Prevent Saving Changes Option will set to ON in SQL Server 2008....
|
|
|
|
|
|
|
