I use INFORMATION_SCHEMA.PARAMETERS for getting information about a stored procedure parameter now. I need to know the default values of parameters. Is there a solution for getting the default value of the parameters of a given stored procedure? Answer Parse the SQL code if you are doing it via SQL commands&#…
Tag: sql
Oracle: DBMS_UTILITY.EXEC_DDL_STATEMENT vs EXECUTE IMMEDIATE
Which are the differences between DBMS_UTILITY.EXEC_DDL_STATEMENT and EXECUTE IMMEDIATE? Answer Fundamentally they do the same thing, which is to provide a mechanism to execute DDL statements in PL/SQL, which isn’t supported natively. If memory serves me well, the EXEC_DDL_STATEMENT was available in the…
Storing IPv6 Addresses in MySQL
As has been requested in “ipv6-capable inet_aton and inet_ntoa functions needed”, there is currently no MySQL function for storing IPv6 addresses. What would be the recommended data type/function for …
SQL query: make a report for all products
I need help to build SQL query. I have 2 tables table PROJECT and PRODUCT, which has this fields: PROJECT: PROJECTCODE PROJECTNAME PRODUCT: ITEMCODE ITEMNAME PROJECTCODE REPLACEDBYCODE The …
Display a ConnectionString dialog
I’m trying to create a program in C# that should be able to create, backup and restore a SQL Server database. For this, the user needs to be able to setup a connection string to the desired SQL Server (and database). I would like to use the same dialog as for example Visual Studio for creating the conne…
How to show SQL query log generated by a RSpec test?
I am writing a spec for my rails 3 application. I want to test that db transactions are really working. It would be really helpful to be able to see the sql queries being generated my app while being driven by the spec. Is there a way to see the queries just like in the rails console? I’m using Rails
What is the difference between CLOB and NCLOB?
Can you state any difference between the CLOB and NCLOB? Answer A CLOB stores character data encoded in the database character set. A NCLOB stores character data encoded in the national character set will show you the database and national character sets of your database.
how to use single quotations inside a transact sql statement
i want use single quotations inside a transact sql statement, then execute that statement. for example my query is: now i want use like this: this not work, and this error occurred : Invalid column name ‘1’ I know problem is quotations in left and right side of the 1 this is a sample and i want us…
MySQL – specific columns on join?
When making a join (inner, left outer, right outer or whatever), how can I specify which columns on the table to join into the original table? Consider the following example: This would select FirstName from user, but select everything from Provider. How can I specify which parts of Provider should be include…
Solution for: Store update, insert, or delete statement affected an unexpected number of rows (0) [closed]
I found a solution for people who get an exception: Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were …