Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Add a script
Items 1 to 20 of 2774
Next 20 >>
Format Currency Into a String
I had a requirement to produce a formatted currency string from within SQL server. I was able to build this scalar-valued function to meet the requirement.
Read more...
By
Chris Kutsch
2013/05/13
|
Source:
SQLServerCentral.com
|
Category:
substring
Rating:
|
Discuss
|
Briefcase
|
512 reads
Union Forcing Distinct
The use of union would seem to force a distinct in each of the select statements being unioned. The use multiple unions, with mixed union and union all clauses, seems to cause haphazard results.
Read more...
By
Clyde Merrell
2013/05/14
|
Source:
SQLServerCentral.com
|
Category:
union
Rating:
|
Discuss
|
Briefcase
|
553 reads
PowerShell to SlipStream SQL 2008
PowerShell script to SlipStream SQL Server 2008 installer with SPx patch.
Read more...
By
Fahim Ahmad
2013/05/03
|
Source:
SQLServerCentral.com
|
Category:
powershell
Rating:
|
Discuss
|
Briefcase
|
408 reads
Get IP Addresses of all Hostnames using SQL Server
To get the IP addresses of Multiple hostnames from below stored procedure.
Read more...
By
Sumit Agarwal
2013/05/02
|
Source:
SQLServerCentral.com
|
Category:
dba
Rating:
|
Discuss
|
Briefcase
|
1,610 reads
PowerShell to search for domain Computer objects
Query Active Directory Computer objects to verify existence
Read more...
By
Fahim Ahmad
2013/05/01
|
Source:
SQLServerCentral.com
|
Category:
powershell
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
455 reads
PowerShell to Pre-Create domain objects for SQL Server Cluster
Pre-Create Active Directory Virtual Computer objects to support a new SQL Cluster
Read more...
By
Fahim Ahmad
2013/04/30
|
Source:
SQLServerCentral.com
|
Category:
powershell
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
242 reads
Script to find username and corresponding loginname for all user DB
Script to find username and corresponding loginname for all user database in SQL Server
Read more...
By
Shashank Srivastava
2013/04/29
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
1,292 reads
Change DB Owner to sa for multiple DB's
Changes DB owner to sa for Online DB's where owner is not sa
Read more...
By
Riken Patel
2013/04/26
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
751 reads
String Character Count
A while ago I once attended an interview where I was asked to write a short script that counts each letter of a given string.
Read more...
By
Benson Sibanda
2013/04/25
|
Source:
SQLServerCentral.com
Rating:
|
Discuss
|
Briefcase
|
1,026 reads
List of Stored Procedures modified in past 7 days
Provide list of Stored Procedures that have been changed in past 7 days.
Read more...
By
Nitesh Dedhia
2013/04/24
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,364 reads
Check Candidate Columns for FOREIGN KEY Constraints
Reports table columns that are not foreign keys but that perhaps should be.
Read more...
By
Charles Jacobus
2013/04/23
|
Source:
SQLServerCentral.com
|
Category:
maintenance
|
SQL Scripts Manager Compatible
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
567 reads
Script to find the total used size of all database inside SQL Server
Script to find the total used size of all database inside SQL Server
Read more...
By
Shashank Srivastava
2013/04/19
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,096 reads
Get Database Backup Details on SQL Server
DB Backup status Details
Read more...
By
sathish siva
2013/04/18
|
Source:
SQLServerCentral.com
|
Category:
backup / recovery
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
827 reads
Generate N numbers
Reursive CTE Script to generate n numbers
Read more...
By
Harsha Majety
2013/04/17
|
Source:
SQLServerCentral.com
|
Category:
recursion
Rating:
|
Discuss
|
Briefcase
|
992 reads
Restore Latest Backup with Powershell
Restores the latest backup of a database to a destination server of your choice, and creates a new backup if needed.
Read more...
By
Luke Losli
2013/04/16
|
Source:
SQLServerCentral.com
|
Category:
powershell
Rating:
|
Discuss
|
Briefcase
|
624 reads
Tables in Merge Replication
Find all tables used in Merge Replication
Read more...
By
Kishore Saripalli
2013/05/18
|
Source:
SQLServerCentral.com
|
Category:
replication 2008
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
170 reads
Find the position of all occurrences of an expression within a string
This iTVF returns both the relative and the actual positions of ALL occurrences of a string within a string.
Read more...
By
Steven Willis
2013/04/12
|
Source:
SQLServerCentral.com
|
Category:
charindex
Rating:
|
Discuss
|
Briefcase
|
700 reads
Retrieve SQL Instance Connect Info
This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port
Read more...
By
Steven Whaley
2013/04/11
|
Source:
SQLServerCentral.com
|
Category:
sql server
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
899 reads
Run SQL code on each database
You can use this to run a script/s on multiple databases
Read more...
By
Ashley McLellan
2013/04/10
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,534 reads
Scripting SQL Agents Jobs using Powershell
The script helps to Scripting SQL Agents Jobs using Powershell automatically by scheduling as a job.
Read more...
By
Saranya Venugopal
2013/04/09
|
Source:
SQLServerCentral.com
Rating:
|
Discuss
|
Briefcase
|
662 reads
Items 1 to 20 of 2774
Next 20 >>
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.