Microsoft SQL Server Utilities and Tools
Useful free and paid utilities and tools for Microsoft SQL Server - complete list of 275 Utilities
2020-06-02 (first published: 2020-05-26)
32,321 reads
Utilities
ODBC --SQL -- ConnectionPool -- Statement with ReturnValue
I have an aplication written in VC 6.0 that uses ODBC API 3.0 with connection pooling activated. I execute a STATEMENTlike this pStatement = (SQLCHAR *) "{call MyProc(?,?)}"; rc = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_VARCHAR, lstrlen(pParam1)+1, 0,pParam1, 0, &cbNTS); if(!MYSQLSUCCESS(rc)){error_out(0,0,hstmt);return false;} rc = SQLBindParameter(hstmt, 2, SQL_PARAM_OUTPUT, SQL_C_SLONG ,SQL_INTEGER, 4, 0, &i_NoOfRows, 4, &ii_NoOfRows); if(!MYSQLSUCCESS(rc)){error_out(0,0,hstmt);return false;} rc = SQLPrepare(hstmt,pStatement,strlen((char*) pStatement)); […]
2005-05-19
4 reads
RE: tables sizes and recovery models
You can use the stored procedure sp_spaceused to obtain the size information for each table. You will need to supply the table name as a parameter, so if you want all tables in a database I would suggest using a cursor. For the recovery modes you can execute the following command on each database:SELECT DATABASEPROPERTYEX(N'Your […]
2005-05-18
Automatically Utilizing XML's Untapped Semantic Goldmine
Comments posted to this topic are about the content posted at http://www.dmreview.com/editorial/newsletter_article.cfm?nl=dmdirect&articleId=1019816&issue=20131
2005-03-03
1 reads
RE: How to avoid the rework in SPs
Hi Goce Thanks for the reply , but im still not clear. I want to avoid the recreation or altering of sps again. pls answer this query if any one faces this situation Thanks Jones
2005-01-26
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