Shulou(Shulou.com)05/31 Report--

This article mainly introduces the use of MS SQL skills, the article is very detailed, has a certain reference value, interested friends must read it!

Determine whether a column exists in a table

If exists (select * from syscolumns where id=object_id ('table_name') and name='column_name')

Determine whether a table exists in the database

Select * from dbo.sysobjects where id = object_id (Numbtablename`) and OBJECTPROPERTY (id

NumberIsUserTable') = 1

Dynamically add Where condition

Select * from test where 1 conditions, after which you can dynamically add and conditions

SelectMethod=cursor function:

Add a SelectMethod=cursor to url = "jdbc:microsoft:sqlserver://localhost;DatabaseName=epet". Its function is to initialize multiple preprocessing handles in a transaction. For example:

DbConn.setAutoCommit (false)

For (int I = 0; I < 5; iTunes +) {

Pstmt [I] = dbConn.prepareStatement (strPreSQL [I])

Using SQL Server to drive select a lot of data is best to add SelectMethod=Cursor to connection string to make use of server-side cursors to speed up. In fact, not only sqlserver,oracle 's jdbc, as long as you use PreparedStatement, the driver defaults to using cursors, but sqlserver is not. You must use SelectMethod=Cursor to open cursors.

The above is all the content of this article "what are the tips for using MS SQL?" Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.