EzAdo Part 4
EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.
2016-11-29
751 reads
EzAdo
EzAdo Part 3
EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.
2016-11-03
990 reads
EzAdo - Part 2
EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.
2016-11-02
1,205 reads
EzAdo - Part 1
EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.
2016-10-24
2,229 reads
RE: Small doubt in SQL query!
I have a constraint that i need to return a single resultset to crystal report so i can use only single select. The second select statement in the previous post is the actualy select where i am facing a problem.There i actually need the rows for which Error1 != ''. Could you help me with […]
2004-11-22
RE: Which Object(s) Containting in a Specific Page On SQL.
Hi,Something new is something to investigate....selecting some IOlatches (select * from sysprocesses) and using these waitresource numbers for executing dbcc traceon(3604) dbcc page(9,1,15805,1)gave a lot of results but can anyone tell me how to translate them?GKramer, The Netherlands*************************************************************PAGE: (1:15805) ---------------BUFFER: -------BUF @0x00F2DA80 --------------- bpage = 0x50244000 bhash = 0x00000000 bpageno = (1:15805) bdbid = 9 breferences […]
2004-11-22
RE: Problem Trigger
The triggers are : NewTblProperty_TriggerUpdateSurveyorand dbo.NewTblProperty_UpdateSurveyorIf I try to drop triggers that do not exist I get this:Server: Msg 3701, Level 11, State 5, Line 1 Cannot drop the trigger 'dbo.xNewTblProperty_TriggerUpdateSurveyor', because it does not exist in the system catalog. Server: Msg 3701, Level 11, State 5, Line 2 Cannot drop the trigger 'dbo.xNewTblProperty_UpdateSurveyor', because […]
2004-11-18
RE: How to clear data in Excel before execute DTS
When you export data from SQL to excel first time, it creates table or name range in excel. When you again export data to excel to the same name(table) in excel, it appends data to that table. You have to drop table (you can not delete record with delete * from ..., but using drop table […]
2004-11-18
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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