Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Dynamic SQL Rss

   Items 1 to 20 of 28    Older >>
 

Hassle free parameters in dynamic sql.

An alternative solution to passing parameters to sp_executesql.  Read more...
Rating: |  Discuss |   Briefcase | 1,436 reads

Create a Comma Delimited CSV File from Any Table/View with Debugging

Dynamically build a comma delimited CSV file using the BCP utility from any table or view in your database with a useful code debugging parameter.  Read more...
By Paul Andrew 2013/12/03 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 3,939 reads

Right or Wrong, Dynamic SQL AND a Cursor

I'm no big fan of dynamic SQL or cursors, however there are times where they do the job.   Read more...
By Kurt Zimmerman 2013/11/08 | Category: transaction logs
Rating: |  Discuss |   Briefcase | 1,682 reads

How to Design, Build and Test a Dynamic Search Stored Procedure

Learn how to design, build and test a dynamic search SP in just a few simple but methodical steps.  Read more...
By Dwain Camps 2013/11/05 | Source: SQLServerCentral.com | Category: sql catch all query
Rating: |  Discuss |   Briefcase | 10,610 reads

Executing Dynamic SQL

By Kshitij Satpute 2013/09/26 | Category: dynamic sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,759 reads

Loginless Database Users and Dynamic SQL

Implement Loginless Database Users to maintain data security and preserve interface when dynamic SQL is being used within a stored procedure.  Read more...
By Orlando Colamatteo 2013/09/10 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 6,461 reads

Create a Comma Delimited CSV File from Any Table/View with Debugging

Dynamically build a comma delimited CSV file using the BCP utility from any table or view in your database with a useful code debugging parameter.  Read more...
By Paul Andrew 2013/12/03 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 3,939 reads

Dynamically Drop a User From Your SQL Instance

Dynamically drop a user from each database on an SQL instance by their server login SID, then remove there server login as well. Plus some helpful printable information when ran.  Read more...
By Paul Andrew 2013/08/09 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: (not yet rated) |  Discuss |   Briefcase | 678 reads

Finding Objects on Your SQL Instance

Find objects in any database on your SQL instance.  Read more...
By Paul Andrew 2013/07/30 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 1,446 reads

Best practice recommendations for writing Dynamic SQL

Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over...  Read more...
By Kenneth Fisher 2013/06/13 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,732 reads

Check Candidate Columns for NOT NULL Constraints

This script reports table columns that allow NULL values but that currently have no NULL values, making them candidates for adding a NOT NULL constraint.  Read more...
By Charles Jacobus 2013/01/23 | Source: SQLServerCentral.com | Category: data integrity
Rating: |  Discuss |   Briefcase | 639 reads

Finding Dynamic SQL's Dependencies

The script finds dependencies of Dynamic SQL based on a table containing T-SQL Queries, DB's and Linked Servers in which it can be executed.  Read more...
By Arthur Gimpel 2012/10/15 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 904 reads

Basics of XML and SQL Server, Part 3: Transform and Shred XML in SSIS

This SSIS package performs multiple XSL transformations on an XML document, then shreds the transformed document and inserts its data into a SQL Server table.  Read more...
By Stan Kulp 2012/03/21 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 2,901 reads

Use Dynamic SQL to Improve Query Performance

This article by Jonathan Roberts demonstrates how to use dynamic SQL and overcome its downsides.  Read more...
By Jonathan Roberts 2012/02/17 (first published: 2010/05/20) | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 26,340 reads

Methods For Converting a Stored Procedure

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.  Read more...
By Eli Leiba 2011/04/08 (first published: 2009/10/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,783 reads

Using Dynamic SQL in Stored Procedures

Dynamic SQL allows stored procedures to “write” or dynamically generate their SQL statements. The most common use case for dynamic SQL is stored procedures with optional parameters in the WHERE clause. These are typically called from reports or screens that have multiple, optional search criteria. This article describes how to write these types of stored procedures so they execute well and resist SQL injection attacks.   Read more...
By Additional Articles 2011/03/22 | Source: SQLTeam.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 6,522 reads

Using Certificates to Sign Stored Procedures

How to sign stored procedures with certificates, this is useful if the procedures use dynamic SQL.  Read more...
By Jonathan Roberts 2010/06/21 | Source: SQLServerCentral.com | Category: certificates
Rating: |  Discuss |   Briefcase | 7,628 reads

Use Dynamic SQL to Improve Query Performance

This article by Jonathan Roberts demonstrates how to use dynamic SQL and overcome its downsides.  Read more...
By Jonathan Roberts 2012/02/17 (first published: 2010/05/20) | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 26,340 reads

Script Table or View structure

This code will let you script a Table or Views structure for source control.   Read more...
By Pratap Prabhu 2010/02/02 | Source: SQLServerCentral.com | Category: scripting
Rating: |  Discuss |   Briefcase | 2,095 reads

Methods For Converting a Stored Procedure

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.  Read more...
By Eli Leiba 2011/04/08 (first published: 2009/10/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,783 reads
   Items 1 to 20 of 28    Older >>
 
Tags
t-sql (7)    
stored procedures (3)    
cursor (2)    
metadata (2)    
parameters (2)    
search (2)    
sp_executesql (2)    
temporary tables (2)    
autogenerate (1)    
bcp utility (1)    
blogs (1)    
c# (1)    
certificates (1)    
create database (1)    
csv file (1)    
data integrity (1)    
database design (1)    
debugging t-sql (1)    
dependencies (1)    
execute (1)    
execute  statement (1)    
insert update select (1)    
integration services (ssis) (1)    
loop (1)    
maintenance (1)    
master database (1)    
nested loop (1)    
normalization (1)    
objects (1)    
openrowset (1)    
pivot (1)    
report (1)    
scripting (1)    
security (1)    
splog (1)    
sql catch all query (1)    
sql dynamic search query (1)    
sql injection (1)    
structure (1)    
sys.dm_sql_referenced_entities (1)    
system view (1)    
table (1)    
table variables (1)    
transaction logs (1)    
vb.net (1)    
while loop (1)    
xml (1)    
xslt (1)