I have made an update of this script http://qa.sqlservercentral.com/scripts/Metadata/64603/. the new version includes can generate 4 stored procedures for every table in a database
2013-01-08 (first published: 2008-10-23)
3,191 reads
use metadata to generate basic create procedure statements for insert update and select
2008-11-22 (first published: 2008-10-10)
3,808 reads
Using a stored procedure doesn't stop people from having access to the table as well though. Although, in SQL2005 you can tell the stored procedure to execute to impersonate an appropriately privileged user, so that you can stop people from accessing the table without going through the stored proc. But I would actually use a […]
2005-04-26
I read previously that placing multiple triggers on a table is not a "best practice" since the order in which triggers fire cannot be controlled. Therefore, there is always the potential for conflicting triggers and more maintenance overhead. (Not to mention 1 trigger firing multiple triggers on another table - nesting triggers). My personal practice […]
2005-04-25
I don't think Select Into configures indexes and keys.You may want to script the table first with all keys and indexes but WITHOUT Drop Table option so you would not accedentally delete your original table, in the script replace a table name with a new name, run the script to create a new table. The […]
2005-04-11
How can I create synonyms for tables in a database and give a user read only access to those tables. I don't want to use the schema name before querying the table as that read only user. ThanksAnu
2005-04-11
hi, As I mentioned earlier I think of the surrogate key as a proxy for the real key, hence my loss of the true name "surrogate". More to your question "So, is it fair to say that Normalization rules do not apply to surrogate keys?" this is one of the old debates in database modeling. […]
2005-03-08
I have read that non-clustered indexes are built using the clustered index keys. Does that mean that explicitly including columns present in a clustered index in the definition of a non-clustered index is redundant? Suppose I have a clustered index on TransactionDate, and want to query by (WorkOrder, TransactionDate) Should I declare the non-clustered index […]
2005-01-20
3 reads
This is a shot in the dark.. but have you tried this : CHAR(13) + 'Comment 1' + ': ' + rtrim(so.comments_1) + CHAR(13) + 'Comment 2' + ': ' + rtrim(so.comments_2) + CHAR(13) + 'Comment 3' + ': ' + rtrim(so.comments_3) + CHAR(13) + 'Comment 4' +': ' + rtrim(so.comments_4) AS Record_Notes if that […]
2005-01-12
The packages I need to update with new connection information already exist in an SQL Server. Currently, I open the package in designer and modify the connections. I would like to script the changes instead of opening each package.
2004-09-07
Embracing Limitations: Finding Strength and Purpose in Hard Times For four years, I was...
By Steve Jones
fitching – v. intr. compulsively turning away from works of art you find frustratingly,...
By James Serra
Microsoft Copilot is an app that uses AI to help you find information, create content,...
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