Viewing 8 posts - 46 through 53 (of 53 total)
Use a text qualifier. When importing, the soft sees "1886 stuart street, apt #515" as one column.
June 13, 2003 at 1:39 am
Referential Integrity maintained by the Server is much more performant than RI maintained by triggers, stored procedures or an application.
June 13, 2003 at 1:28 am
Auch, didn't look at the Forum, looks like this one should be moved too
June 12, 2003 at 2:10 am
Thanks!
Did some tests here and this is the solution i've implemented.
I have a dedicated table I lock exclusively. The other tables in the procedure are only locked when necessary, so...
May 7, 2003 at 3:15 am
I have a procedure that runs correctly at my system,
I have done this:
1. Command task: delete the old Excel File
2. SQL Execute task: CREATE TAB on a Excel Connection
CREATE TABLE...
May 6, 2003 at 1:38 am
Set the quotes as:
'SELECT * FROM tbl_Table
ORDER BY ('+ @orderby +') DESC'
This gives:
ORDER BY (Rank) DESC
May 6, 2003 at 1:22 am
Compiling can take a long time. It is indeed wise to place fixed or parametrized data-handling queries in a stored procedure.
I wonder if compiling time reduces when reindexing the Master...
March 13, 2003 at 1:59 am
A good practice for assigning rights to users for an internally developed app is the use of Application roles.
An application role grants rights at runtime.
It works this way:
1. User starts...
February 17, 2003 at 2:31 am
Viewing 8 posts - 46 through 53 (of 53 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy