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 2896 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...

REPLICATE

By Mike Bova 2013/05/23 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 97 reads

The many uses of CROSS APPLY

Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY. In the first... Read more...

By Kenneth Fisher 2013/05/23 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Briefcase | 287 reads

Object Qualification

I came across an interesting issue recently with NHibernate, now it is widely known I despise ORM’s, in my experience... Read more...

By Chris McGowan 2013/05/22 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Briefcase | 542 reads

Paging Data with T-SQL

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/05/22 | Source: Database Journal | Category: paging data

Rating:

Rate this |

Briefcase | 2,169 reads

CHARINDEX()

By Bill Lantz 2013/05/21 | Category: charindex

Rating: (not yet rated) |

Briefcase | 1,242 reads

EXCEPT - 1

By bitbucket 2013/05/20 | Category: except

Rating: (not yet rated) |

Briefcase | 1,307 reads

INSERT

By Kapil Singh 2013/05/17 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,572 reads

Assigning categories to values 2

By Hugo Kornelis 2013/05/15 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,712 reads

Assigning categories to values 1

By Hugo Kornelis 2013/05/14 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,840 reads

INTO Identities

By Steve Jones 2013/05/13 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,715 reads

Data Type

By Yogesh Kumar 2013/05/10 | Category: null

Rating: (not yet rated) |

Briefcase | 1,681 reads

The Subquery

By malls reddy 2013/05/09 | Category: subquery

Rating: (not yet rated) |

Briefcase | 1,709 reads

Nested triggers 2

By Tom Thomson 2013/05/08 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,500 reads

Comparing an inner join vs a subquery

I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing... Read more...

By Kenneth Fisher 2013/05/08 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Briefcase | 3,626 reads

Distinct

By Vinay Kumar 2013/05/07 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,726 reads

Timestamps

By Honza Mensdorff 2013/05/06 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,628 reads

Identity Insert

By Ashok Berwal 2013/05/03 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,821 reads

Table Alias

By Vinay Kumar 2013/05/02 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,612 reads

REPLICATE - 1

By bitbucket 2013/05/01 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,435 reads

Items 1 to 20 of 2896 Next 20 >>

Tags

miscellaneous (496)

maintenance and management (237)

advanced querying (180)

sqlinsider scripts (123)

sql server 7 (115)

performance tuning (110)

administration (98)

sql server 2005 (96)

stored procedures (78)

programming (60)

date manipulation (55)

indexing (53)

backup / restore (47)

string manipulation (45)

blogs (44)

sql server 2008 (39)

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)

data types (14)

search (14)

visual basic 6 (14)

monitoring (13)

pivot (13)

ado (12)

replication (12)

stairway series (12)

null (11)

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)

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)

mail (7)

parse (7)

sql server (7)

sql spackle (7)

sys.dm_db_partition_stats (7)

table variables (7)

tables (7)

arrays (6)

case (6)

collation (6)

computed column (6)

except (6)

integration services (ssis) (6)

intersect (6)

output clause (6)

ranking functions (6)

select (6)

sql-dmo (6)

subquery (6)

system development life cycle (6)

udf (6)

union (6)

.net (5)

best practices (5)

checksum (5)

constraints (5)

convert (5)

cursors (5)

dynamic sql (5)

grouping sets (5)

list indexes (5)

outer joins (5)

paging (5)

schema (5)

string comparison (5)

temp tables (5)

update (5)

apply (4)

auto-growth (4)

automation (4)

best and worst practices (4)

coalesce (4)

count (4)

cross apply (4)

data file management (4)

design and theory (4)

dts (4)

etl (4)

for xml path (4)

group by (4)

hashbytes (4)

hierarchies (4)

installation (4)

linked server (4)

management studio (ssms) (4)

openxml (4)

order by (4)

primary key (pk) (4)

routine database growth (4)

routine growth (4)

sql server 6.5 (4)

synonyms (4)

sys.allocation_units (4)

table (4)

top (4)

tvp (4)

updategrams (4)

xsl (4)

administrator (3)

analysis services (ssas) (3)

cast and convert (3)

columns (3)

create sequence (3)

cross join (3)

distinct (3)

dml (3)

encryption (3)

excel (3)

execution plans (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)

reporting services (ssrs) (3)

running totals (3)

scalar-valued functions (3)

script (3)

select into (3)

space usage (3)

spatial data (3)

sqlclr (3)

statistics (3)

text matching (3)

@@error (2)

2-dimensional arrays (2)

4-4-5 accounting (2)

adjacency list (2)

aggregate function (2)

alias (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)

comma seperated (2)

common language runtime (clr) (2)

common table expressions (2)

conflict resolution (2)

csv (2)

data generation (2)

data profiling (2)

database (2)

database weekly (2)

date (2)

ddl (2)

distributed queries (2)

dmv (2)

duplicate records (2)

editorial - mp3 (2)

extract, transform, load (etl) (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)

math (2)

matrix (2)

mdx (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)

scripting (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)

varchar (2)

window functions (2)

worst practices (2)

(cross) apply (1)

::fn_listextendedproperty (1)

abs() (1)

access (1)

active directory (1)

advanced (1)

alias data types (1)

alter column (1)

alwayson (1)

array (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)

check constraint (1)

check constraints (1)

checksum() (1)

choose (1)

clean garbage data (1)

closing balances (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)

create (1)

create a folder (1)

cube (1)

current activity (1)

cursor (1)

custom optimizaqtion (1)

custome statistics (1)

data manipulation (1)

data mart (1)

data mining (1)

data pump task (1)

data quality (1)

data type (1)

data warehouse (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)

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)

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)

exponents (1)

extended stored procedures (1)

factor (1)

fall on friday (1)

filegroups (1)

filestream (1)

financial rounding (1)

find foreign key using sql (1)

floor (1)

friday poll (1)

functional dependency (1)

fuzzy match (1)

generic sql (1)

geometry (1)

gettablename (1)

gps (1)

grantee (1)

grantor (1)

groouping (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)

implicit conversion (1)

indexes (1)

insert update stored procedure generation (1)

int (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)

list (1)

local variables (1)

logging (1)

logins (1)

lookups (1)

macd (1)

magnetic tape (1)

management (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)

mysql (1)

network (1)

newid (1)

next 13th (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)

parameterized queries (1)

parameters (1)

parsename (1)

partition by (1)

partitioned sets (1)

partitioned tables (1)

password (1)

performance (1)

permission (1)

permutation (1)

pl/sql (1)

powershell (1)

precedence (1)

precision (1)

primary key (1)

prime (1)

prime number (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)

replace (1)

report (1)

revert (1)

reviews (1)

right join (1)

role (1)

rollback (1)

rollup (1)

row constructor (1)

row count (1)

running aggregate (1)

running count (1)

sample chapters (1)

scd (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_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)

stp_cleangarbagedata (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)

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_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)

twitter (1)

type (1)

ucc/ean (1)

undocumented stored procedures (1)

unicode (1)

union all (1)

unique (1)

unique constraint (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)

where (1)

without ssis (1)

workdays (1)

xp_create_subdir (1)

xquery (1)

your own optimizer (1)

zip codes (1)