Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips

Sql Server - Page 4

61-80 of 741     Previous     Next
Create and Retrieve a Named DataSet
by Victor Stefanescu
Use this C# function to create and retrieve a named DataSet using an open connection and a command.
Registering a MSDE SP3 instance into a group in Enterprise Manager
by Ian Northwood
I installed MSDE SP3 as per MS's directions. However, running Enterprise Manager and trying to register the SQL Server instance into a group (this is on the same box that MSDE was installed, BTW) resulted in the old "Server does not exist or access denied" error. This occured whether I used SQL ...
Compare Oracle and SQL Server Dates
by Andy Clark
A Simple Way to Debug a Stored Procedure
by Alex Grinberg
Running a DTS Package Through TSQL with a COM Concept
by K.Nageswara Rao
ExecuteSqlScriptsWithOsql - Executing an array of script files with the OSQL utility
by Marco Bellinaso
Execute an array of sql script files with batch statements, by using the OSQL utility - dbName is the name of the destination database - isWinAuth, login and pwd specify whether to use the integrated Windows authentication, or the SQL Server's login-password otherwise Example: Dim script1 ...
GetOsqlPath - Get the path of the SQL Server's OSQL.exe utility
by Marco Bellinaso
Get the path of the SQL Server's OSQL.exe utility
Execute a SQL Server DTS Package Remotely
by Steve Simon
Moving Transaction Logs to a Different Drive
by Devington B.
Sending Email Through a Stored Procedure in SQL Server 2000
by Somaiah Manukonda
Use the CASE Statement in a SQL SELECT Clause
by Jason Rein
Send Email Using OLE Automation Stored Procedures in SQL Server 2000
by Somaiah Manukonda
Multiply Values of a Particular Column in SQL Server
by Harinatha Reddy
There is no T-SQL function for getting product of rows in a particular column. For example, say you had a table like ...
Calculate the product of a field
by Francesco Balena
The SQL language includes the SUM() aggregate function, that evaluates the sum of all the values in a given column, but it doesn't include a PROD() function that evaluates the product of those values. While this function is surely less commonly useful than SUM(), there are cases when you'd like ...
Most runtime errors don't rollback transaction
by Francesco Balena
Many developers mistakenly believe that any error inside a transaction will make the transaction fail and automatically rollback. However, this is true only for fatal errors, such as most errors with severity equal to 16 or higher. The commonest runtime error - for example duplicate ...
Retreive information about SQL Server
by Francesco Balena
You may retrieve a few important information about a connection to SQL Server by querying the server through appropriate @@ global variables. For example, the following routine takes an ADO Connection object that points to SQL Server and prints a few information about the connection:
Swap the values of two columns
by Francesco Balena
At times you may need to swap the values of two columns of the same SQL Server table. For example, suppose that you realized that the fname column of the Employee table contains the last name of each employee, and vice versa. Typically you do this from VB using a writeable cursor-based ...
The WITH CHECK OPTION option with views
by Francesco Balena
SQL Server's views are updateable, but it is possible that when you insert a new record or update an existing record, the record added or modified doesn't logical belog to the view any longer. For example, consider the following view: CREATE VIEW authors_CA AS ( ...
Update SQL Server records via HTTP
by Giuseppe Dimauro
Thanks to the SQL Server extensions for the Web and XML, it is now possible to query a SQL Server database (and get the result as XML) as well as insert, update, and delete records in a database. In this tip I'll show a few examples of this technique. Here's a first example that shows how you ...
Update SQL Server database with Updategrams
by Giuseppe Dimauro
You can use XML to transfer both data and commands. In this column I'll show how you can update a database by means of XML commands sent over the HTTP protocol and, even more interesting, how to perform bulk uploads with these commands. An updategram is a piece of XML data that contains ...
61-80 of 741     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date