Search Results

Search found 8267 results on 331 pages for 'insert into'.

Page 30/331 | < Previous Page | 26 27 28 29 30 31 32 33 34 35 36 37  | Next Page >

• Generate several sql insert from an sql select sentence

  - by blgnklc

  How can I generate some insert sql sentences using a specific select query. Are there any tool from Ms Sql Server 2008? or else?

  Read the article

• Does an insert made in a transaction is visible by SELECT before transaction is commited

  - by 20c

  I need a confirmation. Client 1 insert rows in a table inside a transaction. Client 2 request this table with a SELECT. If on this client isolation level is set to READ COMMITTED, can you confirm that the SELECT won't returns the rows that aren't yet committed by Client 1. Thanks

  Read the article

• How to insert a float into a SQL table in the right locale

  - by SoMoS

  Hello, I have to insert float values into different SQL Servers. Each one can have different locales so in one it the representation could be "42,2" and at another one "42.2" or whatever. How should i construct the query so it works in any SQL Server? Do i need to detect the locale of the server before constructing the query or what? Thanks in advance mates.

  Read the article

• Insert the lowest possible unique positve integer in an atomic fashion in MySql

  - by Jason Christa

  Say I have a table with a unique positive integer field. I currently have rows with id's of [1, 2, 3, 4, 5, 8, 12, 35]. Is there a insert query that I could write that would assign the id field to the lowest unique positive integer (in this case 6)? It would have to do this atomically so there isn't the possibility of concurrent inserts wiping out each other or failing.

  Read the article

• Returning the PK during a linq to sql insert

  - by Blankman

  I want to return the PK ID when I insert a new user via linq to sql. how can I do this? i.e. is there anything built in or do I have to do 2 queries?

  Read the article

• Not able to execute trigger at bulk insert in sql

  - by Vishwa

  Hi In bulk insertion only in the last record trigger is executing. Example : if i bulk insert 10 records the trigger is running only for the 10th record. But I need trigger to run on all 10 records. Please help me with an example

  Read the article

• Insert text into WPF textbox at caret position

  - by Roice

  How can I insert text into a WPF textbox at caret position? What am I missing? In Win32 you could use CEdit::ReplaceSel(). It should work as if the Paste() command was invoked. But I want to avoid using the clipboard.

  Read the article

• How to round current time in teradata and insert into timestamp(6) feilds

  - by user3471254

  I have a table with date fields of timestamp(6) fields . create table test_time ( t1 timestamp(6) format 'mm/dd/yyyy hh:mm:si' , ); I want to insert into this table with current date and time rounded. i.e. say for example if the current date time is 08/07/2014 10:34:56 then the value in the table should be 08/07/2014 10:00:00 . (or) if current data and time is 08/07/2014 10:54:56 then also the value should be 08/07/2014 10:34:56

  Read the article

• Rails each loop insert tag every 6 items?

  - by dustmoo

  Hello Stack Anon, I have X number of image objects that I need to loop through in a view and want to create a new div every 6 objects or so (for a gallery). I have looked at cycle but it seems to change every other record. Does anyone know of a way to insert code into a view every 6 times? I could probably do it with nested loops but I am kinda stumped on this one. Thanks!

  Read the article

• Getting can't modify frozen string when using string.insert

  - by Richard

  Hi, This is a quick question. I have the following ruby code, which works fine. def add_zeros number, zeros number = number.to_s zeros_to_add = zeros - number.length zeros_to_add.times do number = "0#{number}" end number end But if I replace number = "0#{number}" With number.insert(0, "0") Then I get TypeError: can't modify frozen string, does anyone know why this is?

  Read the article

• Check if row exists, if not add it [MySQL]

  - by Steven

  I need to add a row to a MySQL database table but only if the row doesn't already exist. My database server just went down so I can't test this, but will this work as expected? INSERT INTO `blocks` (`block_file`,`settings_group`) VALUES ('announcements','announcement_settings') WHERE NOT EXISTS (SELECT `block_file`,`settings_group` FROM `blocks` WHERE `block_file`='announcements' AND `settings_group`='announcement_settings') It seems like sound logic. Is this a valid query or is there a better way of doing this?

  Read the article

• MySQL float values jumping around on insert?

  - by dubayou

  So i have a SQL table setup as such CREATE TABLE IF NOT EXISTS `points` ( `id` int(11) NOT NULL auto_increment, `lat` float(10,6) NOT NULL, `lng` float(10,6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; And im inserting stuff like INSERT INTO `points` (`lat`, `lng`) VALUES ('89.123456','-12.123456'); Gives me a row with lat and lng being 89.123459 and -12.123455 Whats up?

  Read the article

• Insert Picture into SQL Server 2005 Image Field using only SQL

  - by Germstorm

  Using Ms SQL Server 2005 and Management Studio how do I insert a picture into an Image type field of a table? Most importantly how do I verify if it is there?

  Read the article

• Insert a newline character every 64 characters using Python

  - by biffabacon

  Using Python I need to insert a newline character into a string every 64 characters. In Perl it's easy: s/(.{64})/$1\n/ How could this be done using regular expressions in Python? Is there a more pythonic way to do it?

  Read the article

• RTF.Insert(Index,String) doesn't work

  - by mr-developer

  i'm wondering why doesn't this work ? it gives me the exception that the "File Format Is Not Valid" richTextBoxPrintCtrl1.Rtf = richTextBoxPrintCtrl2.Rtf.Insert(richTextBoxPrintCtrl1.SelectionStart, myString);

  Read the article

• Row insertion order entity framework

  - by Wouter

  I'm using a transaction to insert multiple rows in multiple tables. For these rows I would like to add these rows in order. Upon calling SaveChanges all the rows are inserted out of order. When not using a transaction and saving changes after each insertion does keep order, but I really need a transaction for all entries.

  Read the article

• How insert 2 different forms on the same page in Django

  - by xRobot

  I have to insert 2 forms in the same page: 1) Registration form 2) Login form . So if I use this in the views.py: if request.method == 'POST': form = registrationForm(request.POST) if form.is_valid(): form.save() return render_to_response('template.html', { 'form': form, }) I will get error by submitting one of two forms. How can I distinguish the 2 forms submitting in the views ?

  Read the article

• How to insert a float into a SQL table in the right locale (in .Net)

  - by SoMoS

  Hello, I have to insert float values into different SQL Servers. Each one can have different locales so in one it the representation could be "42,2" and at another one "42.2" or whatever. How should i construct the query so it works in any SQL Server? Do i need to detect the locale of the server before constructing the query or what? Thanks in advance mates.

  Read the article

• Javascript insert parameter inside string

  - by amemak

  Hi, I want to ask if there is a way to insert variable inside another string which is part of another statement. For example: function SomeFunction(field) { var someVariable = document.getElementById('<%=' + field + '.ClientID %'); } But I've got an error: Error 6 'string' does not contain a definition for 'ClientID' Thank you.

  Read the article

• Javascript to make input field in edit mode(insert mode)

  - by user234194

  How is it possible to make a input field editable in javascript. I mean onFocus putting it in insert mode so that values can be overwritten. Any suggestions ???

  Read the article

• how to insert check box value in PHP?

  - by jaydp

  hi, I Have multiple checkbox. when i insert checkbox value in database at time i have problem so,please ask me answer. Thanks!

  Read the article

• How to insert / retrieve a file stored as a BLOB in a MySQL db using python

  - by Phage

  I want to write a python script that populates a database with some information. One of the columns in my table is a BLOB that I would like to save a file to for each entry. How can I read the file (binary) and insert it into the DB using python? Likewise, how can I retrieve it and write that file back to some arbitrary location on the hard drive?

  Read the article

• Insert Image in richTextBoxControl

  - by Rahat

  What is the best way to insert an image programatically into the RichTextBox control in C# Winforms? If the method is using Clipboard then what is the optimized way to keep the Clipboard original data (i.e. the data state before placing my image on the Clipboard) available to be replaced after my temporary usage of Clipboard for inseting my image in Rich Text Box Control.

  Read the article

• T-SQL OPENQUERY to MySQL - Insert ID

  - by n0chi

  I am using OPENQUERY to do an insert from MSSQL 2005 to MySQL. How do I get at the last inserted id on the MySQL db back into my MSSQL procedure?

  Read the article

• Insert text at cursor in a content editable div

  - by nijikunai

  I have a contenteditable div where I need to insert text at the caret position, This can be done in IE by document.selection.createRange().text = "banana" Is there a similar way of implementing this in Firefox/Chrome? (I know a solution exists here , but it looks sorta clumsy) Thank you!

  Read the article

< Previous Page | 26 27 28 29 30 31 32 33 34 35 36 37  | Next Page >