Alex Rivera | Logout

Questions tagged dynamic-sql

17 questions

Sort by: Newest Votes Active
18
votes
6
answers

Can I use MyBatis to generate Dynamic SQL without executing it?

java dynamic-sql mybatis
asked 2012-11-02T12:21:09.343
8
votes
3
answers

How to tell if SQL stored in a variable will return any rows

sql sql-server dynamic-sql
asked 2011-10-10T21:20:42.363
66
votes
7
answers

DROP FUNCTION without knowing the number/type of parameters?

sql postgresql plpgsql dynamic-sql ddl
asked 2011-10-01T20:54:07.897
9
votes
1
answers

exec sp_executesql @sql and exec (@sql) SQL Server

sql sql-server t-sql sql-server-2008 dynamic-sql
asked 2011-03-10T04:29:38.403
78
votes
8
answers

How to use table variable in a dynamic sql statement?

sql sql-server sql-server-2008 dynamic-sql table-variable
asked 2011-01-07T14:12:49.403
150
votes
6
answers

Getting result of dynamic SQL into a variable for sql-server

sql sql-server sql-server-2005 t-sql dynamic-sql
asked 2010-10-01T15:39:16.627
103
votes
4
answers

Declare Variable for a Query String

sql sql-server sql-server-2005 t-sql dynamic-sql
asked 2010-09-30T17:50:19.170
17
votes
6
answers

Ad hoc queries vs stored procedures vs Dynamic SQL

sql stored-procedures dynamic-sql adhoc-queries
asked 2010-05-29T10:19:31.920
13
votes
5
answers

Creating SQL table using dynamic variable name

sql sql-server database t-sql dynamic-sql
asked 2010-05-25T15:03:02.333
237
votes
14
answers

Truncating all tables in a Postgres database

postgresql plpgsql dynamic-sql truncate database-table
asked 2010-05-13T18:04:15.787
207
votes
8
answers

SQL update fields of one table from fields of another one

sql postgresql sql-update dynamic-sql
asked 2010-05-04T08:27:14.663
102
votes
3
answers

Why do I get "Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'." when I try to use sp_executesql?

sql sql-server t-sql dynamic-sql
asked 2010-04-30T10:41:42.363
14
votes
3
answers

What is a dynamic SQL query, and when would I want to use one?

sql sql-server-2005 dynamic-sql
asked 2010-02-03T06:03:33.063
62
votes
7
answers

Using a cursor with dynamic SQL in a stored procedure

t-sql stored-procedures dynamic-sql database-cursor
asked 2009-06-25T19:51:49.187
12
votes
5
answers

Oracle EXECUTE IMMEDIATE with variable number of binds possible?

oracle-database plsql dynamic-sql
asked 2009-06-17T15:45:04.147
10
votes
8
answers

Dynamically Changing what table to select from with SQL CASE statement

sql sql-server dynamic-sql
asked 2009-01-29T17:30:52.770
25
votes
6
answers

Generate Delete Statement From Foreign Key Relationships in SQL 2008?

sql code-generation foreign-keys dynamic-sql
asked 2009-01-27T22:20:41.660