AUTOGENERATE INSERT UPDATE SELECT STATEMENTS
use metadata to generate basic create procedure statements for insert update and select
2008-11-22 (first published: 2008-10-10)
3,808 reads
Parameters
RE: How to verify number of CALs?
Keep in mind that this is manually maintained. If you purchase CALS there is no requirement to update this field. If you don't update it there is no impact except you may forget how many CALS you have or a new DBA may have a hard time finding out. It is only for documentation so […]
2005-04-15
RE: Generating a SP Dependency Tree
Thanks Chris, that's what I was looking for. I could not remember where this info was stored. brian
2005-04-13
1 reads
RE: SQL Server 2005 Minimum hardware requirements
There are some requirements but I have it running on a p11 450 with 512 mb ram and although it complains it works well enough for eval. I seem to remember P111 800 + 1 Gb ram.
2005-02-03
1 reads
The specified LSN for repldone log scan occurs before the current start of replication in the log
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-09-03
2004-09-02
RE: Change Data Appearance, Vertical to Horizontal
SELECT P.Period, d1.VariableLabel, IsNull(dbo.GetUsedValue(P.BusinessPeriodID, D1.CalculationVariableID), '') as valueFROM VW_LMS_BusinessPeriods AS PLeft Join #DetailTempTable AS D1 on dbo.forceDate(P.EffectiveDate) = dbo.forceDate(d1.EffectiveDate) and d1.BusinessClassID = P.BusinessClassID and P.BusinessID = @BUS_ID and d1.VariableLabel in(SELECT CV.VariableLabelFROM VW_LMS_CalculationVariables AS CVINNER JOIN VW_LMS_BusinessPeriods AS PON CV.BusinessClassID = P.BusinessClassID AND dbo.forceDate(P.EffectiveDate) = dbo.forceDate(CV.EffectiveDate) WHERE P.BusinessID = @BUS_ID) This is more what I […]
2004-08-20
RE: Deceptively hard - xfering single records to another database
Here are some sources of DTS information if you decide to investigate John's suggestion further.Executing DTS from ASP: see http://www.sqldts.com/default.aspx?207Control access to DTS packages with owner and user passwords. see "Handling Package Security in DTS" in BOL.You can pass parameters to a DTS package by using a Dynamic Properties Task and global variables. See both […]
2004-05-11
RE: How do i print special mathematical symbol in my reports?
nchar(unicode)select nchar(0x2265)results: =
2004-04-02
2004-02-20
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers