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

INSERT

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

Rating: (not yet rated) |

Briefcase | 1,100 reads

Assigning categories to values 2

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

Rating: (not yet rated) |

Briefcase | 1,533 reads

Assigning categories to values 1

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

Rating: (not yet rated) |

Briefcase | 1,694 reads

INTO Identities

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

Rating: (not yet rated) |

Briefcase | 1,581 reads

Data Type

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

Rating: (not yet rated) |

Briefcase | 1,559 reads

The Subquery

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

Rating: (not yet rated) |

Briefcase | 1,599 reads

Nested triggers 2

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

Rating: (not yet rated) |

Briefcase | 1,422 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,557 reads

Distinct

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

Rating: (not yet rated) |

Briefcase | 1,653 reads

Timestamps

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

Rating: (not yet rated) |

Briefcase | 1,582 reads

Identity Insert

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

Rating: (not yet rated) |

Briefcase | 1,787 reads

Table Alias

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

Rating: (not yet rated) |

Briefcase | 1,577 reads

REPLICATE - 1

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

Rating: (not yet rated) |

Briefcase | 1,405 reads

Table Variable

By Sergiy 2013/04/30 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,847 reads

QUERY and TABLE HINTS

By Steven Neumersky 2013/04/29 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,706 reads

Create Table

By Kapil Singh 2013/04/26 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,817 reads

Triggers 2

By Hugo Kornelis 2013/04/25 | Category: triggers

Rating: (not yet rated) |

Briefcase | 1,521 reads

Solving Complex T-SQL Problems, Step-By-Step

What should you do if your first, most intuitive solution to a problem ends up scanning the data more than is necessary, resulting in poor performance? Have you missed a new SQL Server feature that can remove inefficiency from your technique? Alternatively, do you need a little help, and some lateral thinking, to open the path to a different approach? Sometimes, the answer is "both". Read more...

By Additional Articles 2013/04/25 | Source: SimpleTalk | Category: t-sql

Rating: (not yet rated) Rate this |

Briefcase | 5,917 reads

FK to IDENTITY

By Nenad Zivkovic 2013/04/24 | Category: foreign keys (fk)

Rating: (not yet rated) |

Briefcase | 1,726 reads

Items 1 to 20 of 2890 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 (44)

blogs (43)

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)

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

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)

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)

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

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

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)