You might try something like this. This is how to return variables to calling program from dynamic SQL. set nocount on create table foobar (id int, theid int) insert into foobar values(1,1) insert into foobar values(1,2) insert into foobar values(1,2) insert into foobar values(1,3) insert into foobar values(1,3) insert into foobar values(1,3) go create PROCEDURE […]
2003-06-04
1 reads
Within the actual job, if you open up the step and select the Advanced tab, there is facility for the step to retry. You can set the number of retry attempts and the retry interval (in minutes). This only works if the step actually fails. Jeremy
2003-06-04
sp_password will allow people to change their password, but they need a way of running it eg isqlw, osql or an application.
2003-06-04
1 reads
Hi Antares686, quote: I use Notes at work and it does this automatically. uuiih, here in my company we can only afford Outlook However, I'm on the hunt for some code snippets on the internet and have found some promising links. I hope putting it all together in some of the next evenings. Thanks, anyway! […]
2003-06-04
Option 1: You can vertically partition a table by splitting the structure of a table into multiple tables based on column. For instance, you can have a main table with all frequently accessed columns and a supplemental table with less frequently accessed columns, joined on a unique key (one to one). This produces more efficient […]
2003-06-04
I don't see a solution to your problem in a single query. The problem lies in the assignment of a unique Trip_ID in the new table. However, you could do it in two goes. First insert one record for each trip using an identity field for Trip_id. After that remove the identity (or 'set IDENTITY_INSERT […]
2003-06-03
1 reads
2003-05-30
I run the following on our system when the SHRINKDATABASE doesn't work properly For this example the Database is named DB and the MDF is named DB_Data.MDF DBCC SHRINKFILE(DB_Data, [enter size to shrink to]) This will tell the system to shrink the physical file itself to be the size you set. This is if you […]
2003-05-29
This is a great site that lists all the free trade publications in various industries. You have to meet the criteria of course, but you should definitely check out the offerings.
2003-05-29
1,031 reads
What are you needing to change about it? Is it the rule that is bound to it or the underlying datatype itself. If the rulle bound then create a new rule and change the bound rule over. If the underlying datatype I usually create a new datatype with the changes and then change all the […]
2003-05-28
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers