see column names in sql

The code is as follows: EXEC sp_rename ' table name. [Original column name] ', ' new column name ', ' column ' Transact-SQL Reference sp_rename Changes the name of a user-created object (such as a table, column, or user-defined data type) in the

35. use SQL query analyzer and SQL profilerUse SQL query AnalyzerUse SQL profilerOptimize T-SQL statementSummaryIn this chapter, we will continue with the description of the pre-stored procedures in Chapter 21st. This chapter describes how to use

13. T-SQL and SQL query AnalyzerWhat is SQL?What is T-SQL?Introduce new features of T-SQLHow to Use T-SQLSummaryIn this chapter, we will introduce some basic concepts about the Structured Query Language and transact-SQL and their differences. This

30. Microsoft SQL Server ManagementAutomatic Setting of SQL ServerDatabase Maintenance PlanSummaryUsing appropriate settings and performing routine maintenance tasks in the database is the key to optimizing the server. This chapter describes the

　　　　　　　　　　　　　　　　　　　　　　Kindergarten class, Silentyou are welcome to continue to follow my work believe that after n years after I have published all the things you will reap quite well   Well, then how do you manipulate the data with a statement? Don'

There are a couple of concepts to talk about before you start."Overwrite Query"When an index contains all the columns referenced by a query, it is often referred to as an "overwrite query.""Index Overlay"If the returned data column is contained in

MS SQL Server Query optimization methodThere are many reasons for the slow speed of queries, which are common1, no indexes, or no indexes (this is the most common problem with query slowness, is the flaw in programming)2, I/o throughput is small,

A more concise version will be published in the blog Hall (excluding the English version). I hope this article will help you! Allowed to reprint, trouble to indicate the source: http://www.cnblogs.com/hanxianlongOriginal

Multi-line Turn stringThis is relatively simple, with | | Or the CONCAT function can be implementedSelect Concat (id,username) str from App_userselect id| | Username Str from App_userString to multiple columnsis actually the problem of splitting the

Original address: http://www.cnblogs.com/lyhabc/p/3367274.htmlBefore reading this article, you can read the following article firstSQL Server's unique task scheduling algorithm "Sqlos"Task Scheduler for SQL Server Sqlos [go]Translated