Showing related tags and posts accross the entire site.
-
I am in the process of converting a site (written by someone else) to use .net tiers on the back end. We have a number of stored procs which return XML. The reasoning behind generating the XML within a proc is solid and is the most efficient way getting the desired data. I've been searching the forums...
-
CreateAuditTablesAndTriggers.cst creates audit tables and triggers for the selected tables. Uses a one audit table per source table strategy. Timestamp columns are ignored. <cheese>To get around a SQL Server issue with text and ntext columns in the "inserted" and "deleted" tables...
-
Greetings If you've been looking for a Database Schema API that is a bit more intuitive than the one that ships with Code Smith and one that handles relationships such as 1:1, 1:M, M:1, M:M and recursion and also has a built in expression parser, then do yourself a favour and check this new API out...
-
Out of necessity, I created this template to help me move a SQL Server 2005 database to SQL Server 2005 Compact edition. This saved me a LOT of manual entry for all the DDL for the CREATE TABLE stuff. Right now all it does is the basic create table with primary key (if any). It doesn't do foreign...
-
I created this template to convert SQL Server DDL syntax to SQL Server CE syntax. It does primary keys, but no foreign keys. If anybody wants to add foreign keys, feel free. Enjoy!
-
Script table data as a series of insert value statements. Tested with MS SQL Server 2000.