Login
or
Sign Up
to become a member!
EXPERTS, INFORMATION, IDEAS & KNOWLEDGE
Launchpad
Forum
Wiki
Blogs
About Us
Create Account
Contact Us
Launchpad
›
Wiki
›
Data Management
›
Database Programming
Your profile
38.103.63.58
Talk for this IP
Search
Views
Category
Discussion
View source
History
Navigation
Main Page
Category List
Recent changes
Random page
Help
Categories
Architecture, Design & Strategy
Data Management
Desktop Developer
Enterprise Developer
IT Professionals
IT Students & Researchers
System Admins
Web Developer
Toolbox
What links here
Related changes
Upload file
Special pages
Printable version
Permanent link
Print as PDF
Links
Forum
Blog
Category:Microsoft SQL Server
From Wiki
Jump to:
navigation
,
search
Articles in category "Microsoft SQL Server"
There are 101 articles in this category.
5
5 ways to return rows from one table not in another table
6
6 Different Ways To Get The Current Identity Value
A
Adding Leading Zeros To Integer Values
B
SQL Server Books
C
CSharp IsNullOrEmpty Function In SQL Server
Calculate Birthday In Years
Calling Stored Procedures With Datetime Parameters
Case Sensitive Search
Case Without Else
Check If Temporary Table Exists
Column To Row (UNPIVOT)
Concatenate Values From Multiple Rows Into One Column
Concatenate Values From Multiple Rows Into One Column Ordered
Concatenation with NULL values
Converting IP Addresses Between Bigint and Varchar
D
Data formatting SSN
Data formatting dates
Date Range WHERE Clause Simplification
Date Ranges Without Loops
Trouble With ISDATE And Converting To SMALLDATETIME
Dense Rank
Don't Use (select *), but List Columns
Dynamic TOP
E
Epoch Date
How to read SQL Server Error Messages
F
Find All Tables Without Triggers In SQL Server
Find Out How Many Occurrences Of A Substring Are In A String
Find Out If A Table Has An Identity Column
Find all Primary and Foreign Keys In A Database
Find all The Rows Where Any Of The Columns Is Null Or Zero Or Both
Find all tables that contain a certain column
Finding duplicates across columns
How to find the first and last days in years, months etc
F cont.
Formatting Dates
G
Get Datetime Without Time
Get Datetime Without Time 2
H
How Can I Select Multiple TOP N Data Sets With SQL Server 2005
How To Calculate How Many Minutes Have Passed Since Midnight With Datetime In SQL
How To Check For A Certain Time With SQL
How To Check If Any, ALL Or No Parameters Have A NULL Value
How To Use ROW NUMBER() In A WHERE Clause
How do I format money/decimal data with commas
How do I format money/decimal data with commas?
I
ISNUMERIC Trouble
ISO Week In SQL Server
Identity Values And Triggers
Integer math
N
NOT IN and NULLs
No Functions on Left Side of Operator
No Math In Where Clause
Non deterministic functions and nullif
O
Optimization: Set Nocount On
Order IP Addresses
Q
Query Optimizations With Dates
R
Random Sorting
Rank
Return Null If A Value Is A Certain Value
Return The First Non Null Value
Return Top N Rows
Returning The Maximum Value For A Row
Row Number
Row To Column (PIVOT)
S
SQL Server Programming Hacks - 100+ List
Getting the First and last days of month, quarter and week
Trouble With ISDATE And Converting To SMALLDATETIME2
SQL Server Quirks - sp rename
Some Undocumented DBCC Commands
S cont.
Sort Values Ascending But NULLS Last
Sort certain values last
Sorting Numbers Stored In A Varchar Column
Sp MSForEachtable
Sp MSforeachDB
Sp tempdbspace
Split A String By Using A Number Table
Store The Output Of A Stored Procedure In A Table Without Creating A Table
Subquery typo with using in
Syntax Error Converting The Varchar Value To A Column Of Data Type Int
Sys.dm exec sessions
T
Ten SQL Server Functions That You Have Ignored Until Now
Testing for Null Values
Three Ways To Display Two Counts From a Table Side By Side
Three differences between COALESCE and ISNULL
How Can I Select Multiple TOP N Data Sets With SQL Server (2000 and earlier)
How Can I Select Multiple TOP N Data Sets With SQL Server 2005?
U
Update triggers
Use RAISERROR within a Try-Catch
Use REPLACE To eliminate unwanted characters
Use XACT ABORT to roll back non trapable error transactions
Use XACT STATE() To Check For Doomed Transactions
Use sp executesql Or EXEC To Get The Count For Dynamic Table Names
Use the *1 trick to do math with two varchar values
Use the sys.dm db index usage stats dmv to check if indexes are being used
Using Common Table Expressions for Parent-Child Relationships
X
Xp dirtree
Xp enumdsn
Xp enumerrorlogs
Xp fileexist
Xp fixeddrives
Xp getfiledetails
Xp getnetname
Xp subdirs