toad sqlserver

Label:Alter PROCEDURE [dbo]. [Sp_gongzi] @gongzi_yf varchar (7) ASDECLARE @input_id varchar (20)DECLARE @sk_sum Decimal (18, 3)DECLARE @sk_sum_yk Decimal (18, 3)BEGINDECLARE Cur_input CURSOR forSelect Docno from tc_tab1 where YF = @gongzi_yfOPEN Cur_inputFETCH Cur_input into @input_idWhile @ @FETCH_STATUS = 0BEGINSet @sk_sum = 0Set @sk_sum_yk = 0Select @sk_sum = SUM (JE * case when (HL2 was null) then HL else HL2 end)From Sk_dan where docno[email protected]_id;Select @sk_sum_yk = SUM (JE * case

.internal_objects_alloc_page_count>0or T1.user_objects_alloc_page_count >0or t1.internal_objects_dealloc_page_count>0or t1.user_objects_dealloc_page_count>0)ORDER BY T1.internal_objects_alloc_page_count DescView the amount of tempdb the database session occupies, and then view the details based on the SPID, and then investigate the specific information for the sessionAccording to the information I found a session that took up a lot of temporary space and looked at the details of the session. The

(CHARINDEX('DD',@StringDate)> 0 ) SET @StringDate = REPLACE(@StringDate,'DD', Right('0' + Datename(DD,@Datetime),2)) IF(CHARINDEX('HH',@StringDate)> 0 ) SET @StringDate = REPLACE(@StringDate,'HH', Right('0' + Datename(HH,@Datetime),2)) IF(CHARINDEX('mm',@StringDate)> 0 ) SET @StringDate = REPLACE(@StringDate,'mm', Right('0' + Datename(MM,@Dateti

duration of the session rather than the creation level, and after the session that creates the global temporary table, the global temporary table no longer issues locks to new sessions, and the global staging table is destroyed after the existing session has finished releasing the lock.3. Create a global temporary table that does not belong to any sessionThe Global temporary table is maintained by SQL Server with a reference counter greater than 0 to ensure that it is not automatically deleted

Stulist column will have a comma, then the statement with the outer layer: SELECT b.sname,left (Stulist,len (stulist)-1) as hobby is to remove the comma, and give a meaningful listing! Reproduced from: http://www.cnblogs.com/doubleliang/archive/2011/07/06/2098775.html The following applications: City table: User table: Query cityids corresponding city name, as follows: Resolve sql: SELECT TOP [id] , [UserName], [ password] , [Islock] , [ISAdmin] , [nickna

packets read from the network since SQL started. SELECT @ @PACK_SENT As W-Returns the number of output packets that have been written to the network since the last startup. SELECT @ @PACKET_ERRORS as W--returns from SQL startup,The number of network packet errors that occurred on the SQL connection. SELECT @ @SERVERNAME as W--Returns the name of the running SQL Server. SELECT @ @SERVICENAME as W--Returns the registry key name under which SQL is running SELECT @ @TIMETICKS as W--the number of

instance login account:Finally, after confirming that all the information is correct, click "Finish" to complete the database mirroring configuration. ：5. Complete the configurationOnce you have completed the above configuration, you will be prompted to ask if you want to start mirroring now. Click "Do not start mirroring" to return to the configuration dialog box. ：in the Configuration dialog box, after verifying the configuration information, click "Start Mirroring":At this point the primary

　　Springmvc+spring+mybatis+sqlserver----Query SQL Server----have return parameters

SQL Server Codesmith C #bigint Int64 Int64Binary binary system.byte[]Bit Boolean boolChar Ansistringfixedlength stringDateTime datetime StringDecimal decimal DecimalFloat Double DoubleImage Binary system.byte[]int Int32 intMoney Currency SingleNCHAR Stringfixedlength stringntext string stringNumeric decimal Decimalnvarchar string stringReal singlesmalldatetime DateTime Stringsmallint Int16 Int16SmallMoney Currency SingleSql_variant Object ObjectText ansistring stringTimestamp Binary system.byte[

=conn.preparestatement (SQL1);Panax NotoginsengPst.setstring (1, "150102030165"); -Pst.setstring (2, "Good Sanmao"); thePst.setstring (3, "male"); +Pst.setstring (4, "1996.03.28")); APst.setstring (5, "58"); thePst.setstring (6, "1968.08.14")); +Pst.setstring (7, "Shanxi"); -Pst.setstring (8, "aviation")); $Pst.setstring (9, "catwalk")); $ pst.executeupdate (); - pst.close (); - //To close a database connection the conn.close (); -}Catch(ClassNotFoundException e) {Wuyi e.printstacktr

making changes to data, and before a does commit, the data that is read by the new concurrent transaction is consistent with the data in the a transaction, thus avoiding non-repeatable reads. But before a transaction is finished, a B transaction can insert a new record into the table where data is located, and when another transaction is queried again with the same WHERE clause, the resulting number may be the last inconsistency, that is, the Phantom data.Serializable:An exclusive lock is place

To add data in bulk:An INSERT statement inserts multiple records in bulkA common INSERT statement that inserts only one piece of data into the database, one statement:INSERT INTO persons(Id_p, LastName, FirstName, City)VALUES (204, ' haha ', ' Deng ', ' Shenzhen ');(as above, only one record is inserted)How do I insert multiple records at a time?Examples of Use:INSERT INTO persons(Id_p, LastName, FirstName, City)Values(Haha, ' Deng ', ' Shenzhen '),(201, ' haha2 ', ' Deng ', ' GD '),(202, ' haha

t.taxno like CONCAT ('% ',? , '% ') Sql server:Select t.* from Sj_receiptinfo T WHERE t.taxno like '% 'PostgreSQL: SELECT *. (T. Category Code | | '-' | | T. Invoice number) as number from the account where username ~* ' Baidu ';Find information about all user names in the data table account, including Baidu and those that do not distinguish between uppercase and lowercase 4. Infer nullOracle: SELECT productname,unitprice* (unitsinstock+NVL(unitsonorder,0)) from Products MySQL: SELECT pro

(@ZoneNO, W.hx_fzone),") and IsNull (W.owningteam, ' 00000000-0000-0000-0000-000000000000 ') = IsNull (IsNull (@TeamId, W.owningteam), ' 00000000-0000-0000-0000-000000000000 ') and w.hx_fpayamount=0--clearing water and w.hx_frecorddate between @StartDateTime and @ EndDateTime and IsNull (N.hx_flevyinstituteid, ' 00000000-0000-0000-0000-000000000000 ') = IsNull (IsNull (@ Businessunitid,n.hx_flevyinstituteid), ' 00000000-0000-0000-0000-000000000000 ') left JOIN #t_estimateamountreason e- -Water

number of page compression attempts per second; Pages Compressed/sec: Calculates the number of pages compressed per second. Finally, note the data compression considerations: 1. Enabling and disabling table or cluster index compression reconstructs all fee cluster indexes. 2. You cannot use compression in sparse columns. 3. Lob beyond the line cannot be compressed. 4. Non-leaves in the index can also be compressed using row compression only. 5. Non-clustered indexes do not inherit the standard

1 . Connect SQL Server with pymssql.1), Pymssql's PyPI address: Https://pypi.python.org/pypi/pymssql.2), pymssql official website: http://pymssql.org/.3), Python uses pymssql to connect to the SQL Server database.2 . Connect SQLite with Sqlite3 module. Starting with Python 2.5, the sqlite3 becomes a built-in module without additional installation.1), official documents: https://docs.python.org/2/library/sqlite3.html.2), using Python for SQLite database operation.3. Python + MySQL.4. Python Gets

SQLSERVER compilation and recompilation definitions when SQLSERVER receives any command, including query, batch, stored procedure, trigger) pre-compiled commands (preparedstatement) and dynamic SQL statements (dynamicSQLStatement) need to complete syntax interpretation, statement interpretation, and then compile SQLSERVER compilation and recompilation definitions

How does SQLSERVER locate the target data through indexing and Statistics (article 2) before reading the content of this article, please read the content of the first article first, without the foundation of the first article, we will see the first article of o (_) o address: How does SQLSERVER locate the target data through indexing and Statistics (Article 1 )--------------- How does

Commonly used logs for SQL Server diagnosis: (1) Windows event log (2) SQLSERVERErrorLog1. Windows event log EventLog is used as a service program enabled and managed by Windows, windows records the startup, normal shutdown, and abnormal shutdown of the SQLSERVER service in its system log systemlog. Common logs used to diagnose SQLSERVER problems include: (1) Windows Event Log (2)

Commonly used logs for SQL Server diagnosis: (1) Windows event log (2) SQLSERVERErrorLog1. Windows event log EventLog is used as a service program enabled and managed by Windows, windows records the startup, normal shutdown, and abnormal shutdown of the SQLSERVER service in its system log systemlog. Common logs used to diagnose SQLSERVER problems include: (1) Windows Event Log (2)