How do I add line breaks to a field in SQL Server Management Studio

========= QUESTION ---------How do you add a line break when editing a field in a database using SQL Server Management Studio    ========= ANSWER ---------We have not found a simple way to do this using SQL Server Management Studio (SSMS) alone. Instead, you can use the free Notepad++ text editor and add your text in [...]

By |2017-12-01T23:47:28+00:00December 31st, 2012|Computers, Documentation, Microsoft, SQL|Comments Off on How do I add line breaks to a field in SQL Server Management Studio

SQL: Insert Statement

========= QUESTION --------- How do I add a record to a table using SQL?   ========= ANSWER --------- see EXAMPLES   ========= EXAMPLES ---------  SQLTxt = "INSERT INTO 0000T_Log (Dt, Log) VALUES (#" & Now() & "#, '" & Me.CurrentStatus & "')"CurrentDb.Execute SQLTxt   ========= APPLIES TO / KEY WORDS --------- Microsoft Access SQL Insert [...]

By |2017-12-01T23:47:37+00:00September 2nd, 2011|Access, Computers, Documentation, Microsoft, SQL, VBA|Comments Off on SQL: Insert Statement

Access VBA: How to copy a table

========= QUESTION --------- How do I copy a table using VBA or SQL in Access?   ========= ANSWER --------- See EXAMPLES NOTE: the use of of the square brackets ("[" and "]") will save you a lot of grief! For instance in the example below, the date formatting having hyphens in it screws up the [...]

By |2017-12-01T23:47:49+00:00May 12th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off on Access VBA: How to copy a table

WordPress: Query posts via SQL

=========EXAMPLES:---------SELECT Last( AS LastOfname, wp_posts.post_title, wp_posts.post_content, wp_term_taxonomy.taxonomy, wp_posts.post_type, wp_posts.post_statusFROM ((wp_posts LEFT JOIN wp_term_relationships ON wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) LEFT JOIN wp_terms ON wp_term_taxonomy.term_id = wp_terms.term_idGROUP BY wp_posts.post_title, wp_posts.post_content, wp_term_taxonomy.taxonomy, wp_posts.post_type, wp_posts.post_statusHAVING (((wp_term_taxonomy.taxonomy)="category") AND ((wp_posts.post_type)="post") AND ((wp_posts.post_status)="publish")); ---------$querystr = "SELECT * FROM $wpdb->posts LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id) LEFT [...]

By |2017-12-01T23:47:50+00:00April 15th, 2011|Documentation, Internet/Web, WordPress|Comments Off on WordPress: Query posts via SQL
Go to Top