saquery.com
a web developer' s kung fu…

Looking for Procedure Get or Minimum?

We have the following articles on these keywords for you...

Get minimum and maximum values of different sql datatypes

[Translate] Everybody knows the min and max value properties in .Net. [vb] Dim i As Int32 = Int32.MaxValue [/vb] The values represents the smallest and the largest value for a datatype. For some of us it might be interesting to get this information within a stored procedure.

Relevance: 100.00%

Drop all connections to Sql Anywhere Databse

[Translate] This short procedure shows a way to disconect all clients with an open connection to a Sql Anywhere Database.

Relevance: 93.05%

Master of the queries

[Translate] The command sa_describe_query describes the result set for a query. One row describes a specific output column of the query. Regarding to the Posts Master a Foreign Key with Sql Anywhere and get minimum and maximum values of different sql datatypes it is possible to extend the sa_describe_query command as follows.

Relevance: 78.76%

Build a native DB Web Server Access Log with SQL Anywhere

[Translate] See how smart we can handle Web Requests in SQL Anywhere with a few lines of SQL Code. [inline] Specify HTTP Web service protocol and Port in SQL Anywhere The Database Start Parameter -xs specifies server-side Web service communication protocols. With the internal Webserver we can handle web requests within a SQL Anywhere Server. [...]

Relevance: 69.13%

SQL methodes in use

[Translate] With this statement you can select the database methodes currently in use by a connection in a Sql Anywhere database. [sql] select isnull(connection_property ('Currentprocedure',number),'') currentProc, * from sa_conn_info(); [/sql] The select statement returns the following result where currently no procedure is in use. currentProcNumberNameUseridDBNumberLastReqTimeReqTypeCommLinkNodeAddrClientPortServerPortBlockedOnLockRowIDLockIndexIDLockTableUncommitOps 2SQL_DBC_1972bfe8DBA02010-10-05 19:34:58.765FETCHlocal00000 1Sybase Central 3DBA02010-10-05 19:34:57.229CLOSElocal00000

Relevance: 54.41%

Remove Duplicate Index Warnings in Adaptive Server Anywhere

[Translate] Impact on performance Duplicate indexes slow down performance: Each time an indexed column is modified, the value will be changed in the table and also changed in the index. If there are duplicate indexes, each index must be maintained separately every time the data is modified. The amount of index maintenance increases for INSERT, [...]

Relevance: 51.05%

Rise of the machines

[Translate] An Interview with Eric Farrar Product Manager on Sybase’s SQL Anywhere Stephan: Hi Eric, First of all thank you very much for taking time to answer a few questions. Articles on your Blog indicate that you are not only a Product Manager but also an experienced developer. Maybe you can introduce yourself a little? [...]

Relevance: 12.32%

Other relevant searches:

Powered by WP SEO Tags