I had shrunk the database after the delete but take no effect. As long as I know, shrink database only can be done when the the free spaces more than...

Dear Rebecca Starr,

Very easy!

Inside the instead of insert trigger, put this lines inside:

SET @DATE = CONVERT(VARCHAR(8), getdate(), 112)

Insert the date with value...

Hi Loi Tan Vo,

Try to use bcp (bulk copy). Refer to BOL for the syntacs and options (including in CSV or other...

myself,

If you really can't avoid in using variable to query, i suggest to use sp_executesql instead of direct query. Ian is correct. When you are using variable in the select...

For maintainable purpose, you can separate the action to three "class", such as insert, update and delete called by a "super-class". For example,

CREATE...

Easy and clean cut. Just modify a bit of your query like below:

SELECT CONVERT(VARCHAR, mydate, 105) AS MYNEWDATE FROM TBL1

May I know what is logical file name? Is it used to point to the physical file path as alias.

Only users with sysAdmin rights can execute xp_cmdshell from the database or job. Another method is create a windows ID and register it as a domain user and then use...

Thank you. I prefer David Burrows method - neat!