Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag select Rss

   Items 1 to 14 of 14   
 

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS UPDATED

I have made an update of this script http://www.sqlservercentral.com/scripts/Metadata/64603/. the new version includes can generate 4 stored procedures for every table in a database  Read more...
By Chris Morton 2013/01/08 | Source: SQLServerCentral.com | Category: autogenerate parameters
Rating: |  Discuss |   Briefcase | 3,029 reads

SELECT (Transact-SQL)

By Jose Anchieta C. JR 2012/10/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,468 reads

Indexing - Take the Hint and Leave it to the Experts

The most common T-SQL command in use has to be the SELECT statement, it is the bedrock of any SQL Professional's day. Sometimes it's used to snatch some data from a table or two while some quick investigation is done, other times it is at the heart of a stored procedure or view that will inform business decisions for coming months or even years.  Read more...
By Additional Articles 2012/01/30 | Source: SimpleTalk | Category: indexing
Rating:  Rate this |   Briefcase | 4,155 reads

Understanding the SQL Server SELECT @@VERSION command

Check out this tip to learn about the SELECT @@VERSION command in SQL Server.  Read more...
By Additional Articles 2011/12/30 | Source: MSSQLCity.com | Category: select
Rating:  Rate this |   Briefcase | 4,240 reads

Stairway to T-SQL DML Level 1: The Basic SELECT Statement

There are lots of different aspects of managing data in a SQL Server database. Before you can get into the complex management issues associated with managing application data you need to start with the basic of retrieving data from a table. To return data from a SQL Server table you use a SELECT statement. In this level I will be cover the components of the basic SELECT statement and how you can use it to retrieve data from a single SQL Server table.  Read more...
By Gregory Larsen 2011/10/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 14,305 reads

Huge Insert .... Select that not blocking using snapshot isolation

a technique that allows large insert .... select but blocks no other queries  Read more...
By Jason S Wong 2010/07/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,729 reads

Huge Insert .... Select that not blocking using snapshot isolation

a technique that allows large insert .... select but blocks no other queries  Read more...
By Jason S Wong 2010/07/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,729 reads

How many Records Will Get Selected

By SQL Buzz 2010/06/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,674 reads

Display Rows Vertically or Alphabetically

Display a row vertically when a table has hundreds of columns to avoid scrolling.  Read more...
By William Talada 2010/01/21 | Source: SQLServerCentral.com | Category: select
Rating: |  Discuss |   Briefcase | 2,729 reads

SELECT @local_variable

By Honza Mensdorff 2009/12/14 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,838 reads

Display rows vertically

A script to view selects of fat rows vertically with columns in alpha order  Read more...
By Steve McRoberts 2009/10/05 | Source: SQLServerCentral.com | Category: select
Rating: |  Discuss |   Briefcase | 1,815 reads

T-SQL - SELECT TOP

By Robert Griffin 2009/03/18 | Category: top
Rating: (not yet rated) |  Discuss |   Briefcase | 5,132 reads

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS

use metadata to generate basic create procedure statements for insert update and select  Read more...
By Chris Morton 2008/11/21 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 3,563 reads

Create standard Get Procedure in T-SQL

This stored procedure saves time by creating a standard procedure to retrieve a row or set of rows.  Read more...
By Peter Strömblad 2008/09/02 | Source: SQLServerCentral.com | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 1,125 reads
   Items 1 to 14 of 14   
 
Tags
t-sql (6)    
insert (4)    
stored procedures (3)    
chris morton (2)    
codrakon (2)    
metadata (2)    
update (2)    
@@version (1)    
3-tier design (1)    
autogenerate (1)    
autogenerate parameters (1)    
columns (1)    
constraints (1)    
formatting (1)    
indexing (1)    
information_schema (1)    
local variables (1)    
mkproc_get (1)    
order by (1)    
parameters (1)    
resultset (1)    
stairway series (1)    
top (1)    
unpivot (1)    
views (1)