SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Stored Procedures Rss

   Items 1 to 20 of 274    Older >>
 

Stored Procedure Parameters

By Steve Jones 2019/02/18 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 646 reads

The Funny Stored Procedure Name

By Steve Jones 2019/02/08 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 795 reads

Creating Your First Stored Procedure

Learn how to get started writing code modules inside of your SQL Server database,  Read more...
By Steve Jones 2019/02/04 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 846 reads

Working with SQL Server Stored Procedures and .NET

Learn how to build a simple .NET application that uses SQL Server stored procedures to retrieve and update data from a database.  Read more...
By Additional Articles 2019/01/03 | Source: MSSQLTips.com | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,867 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2019/01/02 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 78,424 reads

String Replace in Stored Procedures with Powershell

Find a string in a stored procedure and replace with powershell  Read more...
By Michael D'Spain 2018/11/13 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 262 reads

Embrace Stored Procedures

Developers working with SQL Server should learn to embrace stored procedures. They really, really do work well.  Read more...
By Steve Jones 2018/11/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 552 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2019/01/02 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 78,424 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2019/01/02 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 78,424 reads

Using Parameters for SQL Server Queries and Stored Procedures

One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this tip we look at different ways to pass in values as parameters to queries and the advantages and disadvantages.  Read more...
By Additional Articles 2018/07/05 | Source: MSSQLTips.com | Category: parameters
Rating: (not yet rated)  Rate this |   Briefcase | 3,773 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2019/01/02 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 78,424 reads

How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger

How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or anything like a string starting with 'XYZ'?  Read more...
By Additional Articles 2018/04/13 | Source: MSSQLTips.com | Category: stored procedures
Rating:  Rate this |   Briefcase | 5,246 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2019/01/02 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 78,424 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2019/01/02 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 78,424 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2019/01/02 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 78,424 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2019/01/02 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 78,424 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2019/01/02 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 78,424 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2019/01/02 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 78,424 reads
   Items 1 to 20 of 274    Older >>
 
Tags
t-sql (94)    
miscellaneous (21)    
programming (19)    
administration (18)    
sql server 7 (17)    
performance tuning (14)    
security (11)    
advanced querying (9)    
xml (9)    
sql server 2005 (8)    
ado (7)    
parameters (7)    
triggers (6)    
integration services (ssis) (5)    
strategies (5)    
temporary tables (5)    
backup and restore (4)    
configuring (4)    
dynamic sql (4)    
indexing (4)    
metadata (4)    
sql-dmo (4)    
update (4)    
visual basic 6 (4)    
development (3)    
dts (3)    
function (3)    
insert (3)    
installation (3)    
linked server (3)    
reporting services (ssrs) (3)    
search (3)    
select (3)    
sql server (3)    
views (3)    
3-tier design (2)    
autogenerate (2)    
blogs (2)    
chris morton (2)    
codrakon (2)    
crosstab (2)    
database (2)    
database design (2)    
editorial (2)    
encryption (2)    
error handling (2)    
excel (2)    
execute (2)    
functions (2)    
maintenance and management (2)    
monitoring (2)    
pivot (2)    
powershell (2)    
recompile (2)    
scripts (2)    
sp_rename (2)    
sql server 2008 (2)    
sqlclr (2)    
statistics (data) (2)    
user defined function (udf) (2)    
xsl (2)    
.net (1)    
adventureworks2012 (1)    
alert (1)    
app_name (1)    
arrays (1)    
asp (1)    
autogenerate parameters (1)    
automatic (1)    
automation (1)    
azure (1)    
basics (1)    
best and worst practices (1)    
big data (1)    
business logic (1)    
call stack (1)    
certificates (1)    
changes (1)    
charindex (1)    
cluster (1)    
cluster analysis (1)    
clustered index (1)    
coalesce() (1)    
columns (1)    
comments (1)    
context_info() (1)    
cursors (1)    
data dictionary (1)    
data flow task (ssis) (1)    
data lake (1)    
data mining (1)    
data quality (1)    
data science (1)    
data warehouse (1)    
database mail (1)    
date manipulation (1)    
db_mail (1)    
dba (1)    
ddl trigger (1)    
delete (1)    
dependency (1)    
disk space (1)    
distributed queries (1)    
doneproc (1)    
drive space (1)    
drop function (1)    
drop procedure (1)    
dynamic (1)    
dynamic email (1)    
ebook (1)    
edis (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
email (1)    
embedded table (1)    
english query (1)    
enhanced data integration suite (1)    
etl (extract, transform, and load) (1)    
execute as (1)    
execute sql task (1)    
execution plans (1)    
expressions (1)    
extended procedures (1)    
find foreign key using sql (1)    
fn_listextendedproperty (1)    
fnord (1)    
foreach (1)    
foreach loop container (1)    
ftp (1)    
ftp connection (1)    
fun (1)    
google (1)    
html (1)    
html table (1)    
indexed views (1)    
information_schema.routines (1)    
in-memory oltp (1)    
input (1)    
insert update stored procedure generation (1)    
last accesses (1)    
linked servers (1)    
list (1)    
local path (1)    
matrix (1)    
merge (1)    
mkproc_createupdate (1)    
mkproc_get (1)    
multiple result sets (1)    
multiple server (1)    
naming standards (1)    
native compiled (1)    
nested loop (1)    
notification (1)    
object_id (1)    
openxml (1)    
output (1)    
palalelism (1)    
parameter (1)    
parsing (1)    
passwords (1)    
performance improvement (1)    
performance monitoring (1)    
permissions (1)    
pivottable (1)    
profiler (1)    
query tuning (1)    
remote path (1)    
replication (1)    
report (1)    
resultset (1)    
revert (1)    
review (1)    
rsexecutionlog (1)    
schemas+dtds (1)    
script (1)    
semaphore (1)    
server name (1)    
server password (1)    
server user name (1)    
servers (1)    
service broker (1)    
set options (1)    
slowly changing dimension (1)    
source code (1)    
source control (1)    
sp_depends (1)    
sp_sproc_columns (1)    
split (1)    
splog (1)    
sql (1)    
sql puzzles (1)    
sql server 2012 (1)    
sql server 2014 (1)    
sql server 6.5 (1)    
sql server data tools (ssdt) (1)    
stack (1)    
stress test (1)    
string replace (1)    
sys.dm_exec_cached_plans (1)    
sys.dm_exec_sql_text (1)    
syscolumns (1)    
syscomments (1)    
sysobjects (1)    
system (1)    
system development life cycle (1)    
system health (1)    
system tables (1)    
table field information (1)    
table metadata (1)    
tables (1)    
template (1)    
text search (1)    
token stream (1)    
try..catch (1)    
unknown groups (1)    
unused (1)    
updategrams (1)    
user-defined data types (1)    
u-sql (1)    
utility (1)    
variables (1)    
version control systems (vcs) (1)    
video (1)    
windows azure sql database (1)    
with encryption (1)    
worst practices (1)