Hi, I have created a table which contains several standard columns and one computed column. What I'm trying to do is create a view on top of the...
Hi, I'm trying to write a stored procedure that sits in one database, but only create objects in a remote database. However, I am having trouble...
Hi, I would like to be able to tell when a particular table was last updated (e.g. rows added / deleted / updated etc). I'm aware that you can...
Morning All, I was wondering if somebody could explain if there is any significant benefit from defiing a primary key constraint on a table as oppose...
Hi folks, I'm looking to improve the efficiency of an UPDATE statement that I currently run. Having read some previous discussions, I understand...
Hi, I'm looking to find a command that will reduce the memory space taken up by tables once you have deleted records from them. i.e. suppose you...
Hi, I'm having a slightly annoying problem with importing data from Excel in SQl. My data is in columns A and B of Sheet1 of an Excel spreadsheet....
I have written a procedure which creates several temporary tables within it. I have granted exec for the procedure and insert + select for the final...
Separate names with a comma.
