What do you want to save?
Add Code snippet
New code examples
-
C# 2021-09-17 00:29:03
in clause db2 c#
string[] tags = new string[] { "ruby", "rails", "scruffy", "rubyonrails" }; const string cmdText = "select * from tags where '|' + @tags + '|' like '%|' + Name + '|%'"; using (SqlCommand cmd = new SqlComm... Add solution -
SQL 2021-09-16 21:07:02
SQL Date Format
-- Oracle:TO_DATE(string, format) SELECT TO_DATE('2012-06-05', 'YYYY-MM-DD') FROM dual; SELECT TO_DATE('05/06/2012 13:25:12', 'DD/MM/YYYY HH24:MI:SS') FROM dual; -- SQL Server: CONVERT(data_type, string, style). Cf source link for style codes. SELECT CONV... Add solution -
SQL 2021-09-16 09:03:02
sql to_date
-- Oracle:TO_DATE(string, format) SELECT TO_DATE('2012-06-05', 'YYYY-MM-DD') FROM dual; SELECT TO_DATE('05/06/2012 13:25:12', 'DD/MM/YYYY HH24:MI:SS') FROM dual; -- SQL Server: CONVERT(data_type, string, style). Cf source link for style codes. SELECT CONV... Add solution -
SQL 2021-09-10 07:02:03
how to count number of columns in a table in oracle
-- Oracle SELECT count(*) FROM ALL_TAB_COLUMNS WHERE OWNER='owner_name' AND TABLE_NAME = 'table_name'; -- SQL Server / MySQL SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'schema_name' AND TABLE_NAME = 'table_name'; Add solution -
Other 2021-09-09 18:36:03
iterate through names of columns in result set pdo
//Connect to MySQL using PDO. $pdo = new PDO("mysql:host=$host;dbname=$database", $user, $password); //Create our SQL query. $sql = "SELECT * FROM my_table_name LIMIT 20"; //Prepare our SQL query. $statement = $pdo->prepare($sql);... Add solution -
SQL 2021-09-07 05:57:02
authentication in sql server
Windows mode and Mixed Mode – SQL and Windows. Click Start> Programs> Microsoft SQL Server and click SQL Enterprise Manager to run SQL Enterprise Manager from the Microsoft SQL Server program group. Then select the server from the Tools men... Add solution