Creating a large database

How does SQL work with blanks?

Create Database

Snapshot Dynamicly

How to create a database snapshots dynamically

AUTOGENERATE Stored procedures example

This is related to my other autogenerate code. this is just an example of how to use it.

adding two columns in sql server ?

hi i have a table called "finance" and these columns date                amt_recharge          amt_food          total 12/2/2005             50                         20                 70 how can i write a query in the sql server enterprise manager to add up both the columns "amt_recharge" and "amt_food" and the resultant output in the "total" ? And by the way where and how do […]

RE: OLEDB Driver Fails to Return @@Identity

Anthony,There should not be any reason why you can't use the OLEDB provider -we use both and have not noticed this problem. Is the comma at the end of  the third line of the proc a mistype or is it really in your procedure? If so then this obviuosly should not be there and may explain […]

RE: running a dts package from access project

You can also use VBA and ADO to execute a stored procedure that calls the DTS package. Here's an example of a stored procedure that uses the system stored procedure xp_cmdshell and the dtsrun.exe command to execute the package: CREATE PROC ap_CallDTS AS SET NOCOUNT ON DECLARE @cmd varchar(255) DECLARE @error int --command string SET […]

RE: When Do You Pull Your Hair Out?

Excellent!! Concise and clear article about how to return the executing statement from the db system!

RE: Stored Procedure and parameters

You have two possibilities. The first one is using IF statements, each with their own query. This is OK if you only have a few parameters, but the number of combinations grows very quickly. Another possibility is to change the query to take left out parameters into account. In your example, the query would look […]