SQLServerCentral: Content tagged T-SQL

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Content with tag T-SQL

Items 1 to 20 of 2930 Next 20 >>

Stairway to T-SQL DML

This Stairway will provide you with a basic understanding of how to work with data from SQL Server tables, using SQL Server’s Transact-SQL (T-SQL) dialect. DML is the Data Manipulation Language, and is the aspect of the language dealing with the data. It includes the statements SELECT, INSERT, UPDATE and DELETE. This Stairway will as also provide some history of the SQL language and some general concepts about set theory. Each level will build upon the prior level, so by the time you are finished you will have a good understanding of how to select and modify data from SQL Server. Read more...

Email Formatted HTML Table with T-SQL

Create a professional looking HTML table from T-SQL, not SSRS. Read more...

By Steve Moore 2013/06/20 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 1,071 reads

SQL CHOOSE

By Bill Lantz 2013/06/19 | Category: choose

Rating: (not yet rated) |

Briefcase | 1,072 reads

ALL clause in SQL Server

By Chirag Patel 2013/06/18 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,333 reads

Alias Usage

By Ismail ADAR 2013/06/17 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,487 reads

T-SQL Tuesday #43 – Plan Operators

This month’s TSQL-Tuesday is hosted by Rob Farley (blog | twitter), who became a Microsoft Certified Master this past December (congrats!).... Read more...

By Wayne Sheffield 2013/06/14 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Briefcase | 654 reads

Custom Sequence Numbering

This article shows how to implement low cost custom sequence numbering logic via a cunning use of the the ROW_NUMBER() function Read more...

By James Skipwith 2013/06/14 (first published: 2011/02/07) | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 16,858 reads

Best practice recommendations for writing Dynamic SQL

Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over... Read more...

By Kenneth Fisher 2013/06/13 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Briefcase | 2,876 reads

SHOWPLAN_XML

By malls reddy 2013/06/13 | Category: execution_plan

Rating: (not yet rated) |

Briefcase | 1,206 reads

BETWEEN a hard place and a rock

By Hugo Kornelis 2013/06/12 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,627 reads

Finding queries to tune

A query to help identify queries that need some tuning. Read more...

By Simon Osborne 2013/06/11 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 1,508 reads

Float Data Type

By Mark Hobson 2013/06/07 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,417 reads

Insert Commas Into Number String

Function to take a number as a string and return it with commas separating thousands, millions, etc. Read more...

By Jesse McLain 2013/06/07 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 2,136 reads

IFF - 1

By bitbucket 2013/06/06 | Category: iff

Rating: (not yet rated) |

Briefcase | 1,704 reads

Usage of Null

By Bhavpreet Singh Narang 2013/06/05 | Category: null

Rating: (not yet rated) |

Briefcase | 1,721 reads

Paging Data with TSQL

Greg Larsen shares a number of different TSQL methods to provide paging functionality, for when your application requires that you display only one page of data at a time. Read more...

By Additional Articles 2013/06/05 | Source: Database Journal | Category: t-sql

Rating: (not yet rated) Rate this |

Briefcase | 3,661 reads

TOP and ORDER BY

By Yogesh Kumar 2013/06/04 | Category: top

Rating: (not yet rated) |

Briefcase | 1,769 reads

COALESCE

By Chirag Patel 2013/06/03 | Category: coalesce

Rating: (not yet rated) |

Briefcase | 1,996 reads

GROUPING SETS - 1

By bitbucket 2013/05/31 | Category: grouping

Rating: (not yet rated) |

Briefcase | 1,802 reads

TOP clause WITH TIES

By Ron Moses 2013/05/30 | Category: top

Rating: (not yet rated) |

Briefcase | 1,646 reads

Items 1 to 20 of 2930 Next 20 >>

Tags

miscellaneous (496)

maintenance and management (237)

advanced querying (180)

sqlinsider scripts (123)

sql server 7 (115)

performance tuning (112)

administration (98)

sql server 2005 (96)

stored procedures (78)

programming (60)

date manipulation (55)

indexing (55)

backup / restore (48)

blogs (46)

string manipulation (45)

sql server 2008 (40)

sql puzzles (36)

data warehousing (29)

security (27)

utility (27)

xml (24)

aggregates (22)

maintenance (21)

triggers (21)

user defined function (udf) (21)

identity property (20)

strategies (20)

views (18)

cte (17)

database design (17)

transactions (17)

configuring (16)

lock and connection management (16)

development (15)

search (15)

data types (14)

monitoring (14)

visual basic 6 (14)

null (13)

pivot (13)

ado (12)

replication (12)

stairway series (12)

basics (10)

datetime manipulation (10)

delete (10)

foreign keys (fk) (10)

merge (10)

tally table (10)

crosstab (9)

datetime (9)

insert (9)

recursion (9)

sql server 2012 (9)

editorial (8)

nums (8)

row_number() (8)

sql server (8)

storage (8)

table of numbers (8)

tally (8)

truncate table (8)

video (8)

automated dba (7)

common table expression (cte) (7)

counter (7)

delimited strings (7)

error handling (7)

except (7)

mail (7)

parse (7)

sql spackle (7)

sys.dm_db_partition_stats (7)

table variables (7)

tables (7)

udf (7)

arrays (6)

case (6)

collation (6)

computed column (6)

dynamic sql (6)

integration services (ssis) (6)

intersect (6)

output clause (6)

paging (6)

ranking functions (6)

select (6)

sql-dmo (6)

subquery (6)

system development life cycle (6)

temp tables (6)

top (6)

union (6)

.net (5)

automation (5)

best practices (5)

checksum (5)

coalesce (5)

constraints (5)

convert (5)

cursors (5)

excel (5)

grouping sets (5)

list indexes (5)

order by (5)

outer joins (5)

reporting services (ssrs) (5)

schema (5)

string comparison (5)

update (5)

apply (4)

auto-growth (4)

best and worst practices (4)

count (4)

cross apply (4)

data file management (4)

design and theory (4)

dts (4)

etl (4)

execution plans (4)

for xml path (4)

group by (4)

hashbytes (4)

hierarchies (4)

installation (4)

linked server (4)

management studio (ssms) (4)

openxml (4)

primary key (pk) (4)

routine database growth (4)

routine growth (4)

select into (4)

sql server 6.5 (4)

sqlclr (4)

synonyms (4)

sys.allocation_units (4)

table (4)

tvp (4)

updategrams (4)

xsl (4)

administrator (3)

alias (3)

analysis services (ssas) (3)

cast and convert (3)

columns (3)

create sequence (3)

cross join (3)

distinct (3)

dml (3)

dmv (3)

encryption (3)

full-text search (2005) (3)

function (3)

hierarchy (3)

hierarchyid (3)

humor (3)

inner join (3)

isnull (3)

joins (3)

lead (3)

like (3)

locking (3)

naming standards (3)

performance testing (3)

permissions (3)

replicate (3)

running totals (3)

scalar-valued functions (3)

script (3)

scripting (3)

space usage (3)

spatial data (3)

statistics (3)

text matching (3)

@@error (2)

2-dimensional arrays (2)

4-4-5 accounting (2)

adjacency list (2)

aggregate function (2)

alter table (2)

asp (2)

auditing (2)

backup (2)

between (2)

bigint (2)

binary_checksum (2)

bitwise operators (2)

buffer cache (2)

cascade (2)

cast (2)

change detection (2)

charindex (2)

choose (2)

comma seperated (2)

common language runtime (clr) (2)

common table expressions (2)

conflict resolution (2)

csv (2)

data generation (2)

data profiling (2)

data warehouse (2)

database (2)

database weekly (2)

date (2)

ddl (2)

distributed queries (2)

duplicate records (2)

editorial - mp3 (2)

extract, transform, load (etl) (2)

filestream (2)

fiscal year (2)

full join (2)

games (2)

grant (2)

indexed views (2)

information_schema (2)

job history (2)

jobs (2)

joe celko (2)

join (2)

len() (2)

linked servers (2)

list (2)

math (2)

matrix (2)

mdx (2)

mysql (2)

nested sets (2)

news (2)

ntile (2)

outer apply (2)

output (2)

over (2)

pagination (2)

parsing delimited string (2)

patindex (2)

patrick leblanc (2)

puzzle (2)

random (2)

random numbers (2)

recursive function (2)

regular expressions (2)

restore (2)

reverse (2)

round (2)

rounding (2)

rowversion (2)

schemas/dtds (2)

scripts (2)

semaphore (2)

sequence (2)

sequence objects (2)

smtp (2)

sparse columns (2)

sql_variant (2)

str (2)

stuff (2)

sys.dm_exec_query_plan (2)

sys.dm_exec_requests (2)

sys.dm_exec_sessions (2)

sys.dm_exec_sql_text (2)

sys.dm_os_buffer_descriptors (2)

sys.partitions (2)

table value constructor (2)

tips & tricks (2)

troubleshooting (2)

try catch (2)

tuning (2)

unique constraint (2)

varchar (2)

window functions (2)

worst practices (2)

(cross) apply (1)

::fn_listextendedproperty (1)

abs() (1)

access (1)

ace (1)

active directory (1)

advanced (1)

advantage (1)

affinity (1)

alias data types (1)

alter column (1)

alwayson (1)

ansi_nulls (1)

array (1)

assembly (1)

automatic (1)

backup / recovery (1)

backup/restore (1)

barcode (1)

bi (1)

binary (1)

bit data type (1)

bitwise operator (1)

blob manipulation (1)

book reviews (1)

boomerang (1)

bug (1)

bulk (1)

bulk insert (1)

business days (1)

business intelligence (1)

c# (1)

cartesian product (1)

cascade deletes (1)

case statement (1)

ceiling (1)

change tracking (1)

check constraint (1)

check constraints (1)

checksum() (1)

clean garbage data (1)

closing balances (1)

clr (1)

cmdshell (1)

common table expression (1)

compare data (1)

compare dataset (1)

comparing (1)

computed columns (1)

connectivity (1)

constraint (1)

contest (1)

conversion (1)

conversions (1)

converter (1)

copying structure (1)

copyright (1)

correlated subqueries (1)

correlation (1)

cpu (1)

create (1)

create a folder (1)

create index (1)

cube (1)

current activity (1)

cursor (1)

custom optimizaqtion (1)

custome statistics (1)

data dictionary (1)

data manipulation (1)

data mart (1)

data mining (1)

data pump task (1)

data quality (1)

data type (1)

database mail (1)

database mirroring (1)

database restore (1)

database restore history (1)

database size (1)

databases (1)

datatype (1)

date calculations (1)

date conversion (1)

date data types (1)

date dimension (1)

date functions (1)

dateadd (1)

datediff (1)

datetime functions (1)

dba (1)

dbase (1)

dbcc checkident (1)

deadlock (1)

declare (1)

deduplicate (1)

default (1)

defaults (1)

defensive programming (1)

delete rows (1)

delta (1)

denormalize (1)

dense_rank() (1)

deny select (1)

dependency (1)

deprecated features (1)

derived table (1)

derivedtables (1)

description (1)

developers sql (1)

diagnostic (1)

dimensional modeling (1)

dm_db_index_physical_stats (1)

documentation (1)

dom (1)

drives (1)

drop column (1)

dsql (1)

duplicate indexes (1)

dwh (1)

editorial - ipod (1)

editorial - wmv (1)

elements (1)

ema (1)

emonth (1)

encode (1)

english query (1)

execute (1)

execute as (1)

execution_plan (1)

exponents (1)

extended stored procedures (1)

factor (1)

fall on friday (1)

filegroups (1)

financial rounding (1)

find foreign key using sql (1)

floor (1)

fox (1)

friday poll (1)

functional dependency (1)

fuzzy match (1)

generic sql (1)

geometry (1)

gettablename (1)

gps (1)

grantee (1)

grantor (1)

graphs (1)

groouping (1)

grouping (1)

grouping varchar columns (1)

growth trend (1)

guest user (1)

guid (1)

hash (1)

having (1)

hcf (1)

hex (1)

hexadecimal (1)

hexadecimal conversion numeric inline fast (1)

high availability (ha) (1)

histogram chart (1)

history (1)

holiday (1)

html (1)

identity column (1)

identity_insert (1)

ids to table (1)

iff (1)

implicit conversion (1)

indexes (1)

insert update stored procedure generation (1)

int (1)

internals (1)

interstorm (1)

inventory problem (1)

ip addresses (1)

ipv4 addresses (1)

isnumber (1)

isnumeric (1)

iso (1)

iso week (1)

isolation level (1)

isolation levels (1)

jaro winkler (1)

javascript (1)

json (1)

kimball (1)

lag (1)

large udt (1)

left join (1)

len (1)

linked (1)

local variables (1)

logging (1)

logins (1)

lookups (1)

macd (1)

magnetic tape (1)

management (1)

map (1)

max() (1)

mds (1)

median (1)

meta data (1)

metadata (1)

michael davis (1)

microsoft office (1)

missing indexes (1)

mobile devices (1)

modulus (1)

moving average (1)

msdb (1)

mssql (1)

mstvf (1)

multi language (1)

multi process (1)

mutex (1)

network (1)

new feature of sql server 2008 (1)

newid (1)

next 13th (1)

nitesh dedhia (1)

nodes (1)

notification services (1)

nth occurance of day in a month/year (1)

nth occurrence of a weekday in a month and year (1)

nullif (1)

numbers table (1)

nvarchar (1)

object (1)

object permissions (1)

object_id (1)

objects (1)

odbc functions (1)

operators (1)

options (1)

or (1)

oracle (1)

order (1)

ordinal rank (1)

paging data (1)

palalelism (1)

parallel (1)

parallel processing (1)

parameter (1)

parameterized queries (1)

parameters (1)

parsename (1)

partition by (1)

partitioned sets (1)

partitioned tables (1)

password (1)

pdf (1)

performance (1)

permission (1)

permutation (1)

pl/sql (1)

powershell (1)

precedence (1)

precision (1)

primary key (1)

prime (1)

prime number (1)

pro (1)

procedural programming (1)

procedure (1)

process synchronization (1)

product reviews (1)

public (1)

purge (1)

qa-taskpad (1)

query (1)

query optimization (1)

query plans (1)

queue processing (1)

quick tip (1)

raffle (1)

raiserror (1)

rand() (1)

random dates (1)

range (1)

ranking (1)

ranking function (1)

ratio (1)

rbar (1)

rebind and rewinds (1)

record linkage (1)

referential integrity (1)

remote servers (1)

render (1)

replace (1)

report (1)

revert (1)

reviews (1)

right join (1)

role (1)

rollback (1)

rollup (1)

routine (1)

row constructor (1)

row count (1)

running aggregate (1)

running count (1)

sample chapters (1)

scd (1)

schedulers (1)

script generator (1)

select * (1)

selectivity (1)

semi-additive measures (1)

sequence object (1)

sequence of letters (1)

server (1)

service broker (1)

service packs (1)

set based (1)

set dateformat (1)

set functions (1)

set option (1)

set options (1)

sieve (1)

similarity (1)

slowly changing dimension (1)

sma (1)

software development (1)

solo (1)

soundex (1)

source control (1)

sp (1)

sp_msforeachdb (1)

sp_sproc_columns (1)

sp_who2 (1)

sparse column sets (1)

spherical coordinates (1)

split (1)

split function (1)

sql agent (1)

sql jobs (1)

sql n-tuples (1)

sql script (1)

sql server 2000 (1)

sql server 2011 (1)

sql server agent (1)

sqldom (1)

ssas (1)

star schemas (1)

storage management (1)

stored procedure (1)

stp_cleangarbagedata (1)

stream (1)

stress test (1)

string formatting (1)

string match (1)

string to table (1)

strings (1)

strored procedure (1)

structure (1)

substring (1)

sum (1)

summer time (1)

surround (1)

swap data (1)

sybase (1)

syntax (1)

sys.dm_db_index_usage_stats (1)

sys.dm_db_missing_index_details (1)

sys.dm_exec_connections (1)

sys.dm_exec_cursors (1)

sys.dm_os_ring_buffers (1)

sys.dm_os_schedulers (1)

sys.dm_os_sysinfo (1)

sys.dm_tran_session_transactions (1)

sys.fn_physlocformatter (1)

sys.foreign_key_columns (1)

sys.foreign_keys (1)

sys.sql_modules (1)

syscolumns (1)

sysobjects (1)

system tables (1)

table field information (1)

table functions (1)

table metadata (1)

table spool operator (1)

table valued function (1)

tablediff utility (1)

table-valued function (1)

ted (1)

tempdb (1)

temporary objects (1)

temporary tables (1)

test data (1)

test-driven development (1)

throw (1)

time (1)

time zone (1)

timestamp (1)

to us (1)

tools (1)

triangular joins (1)

truncate (1)

truncation (1)

try-catch (1)

t-sql challenges (1)

t-sql tuesday (1)

twitter (1)

type (1)

ucc/ean (1)

undocumented stored procedures (1)

unicode (1)

union all (1)

unique (1)

uniqueidentifier (1)

unit testing (1)

unix (1)

update with case (1)

url (1)

user (1)

user defined functions (1)

user defined table type (1)

user group (1)

user-defined functions (1)

uuid (1)

vb.net (1)

visualizer (1)

where (1)

without ssis (1)

workdays (1)

xp_create_subdir (1)

xquery (1)

your own optimizer (1)

zip codes (1)