Search Results

Search found 17501 results on 701 pages for 'stored functions'.

Page 301/701 | < Previous Page | 297 298 299 300 301 302 303 304 305 306 307 308  | Next Page >

• The Best Way to shred XML data into SQL Server database columns

  - by eddiegroves

  What is the best way to shred XML data into various database columns? So far I have mainly been using the nodes and value functions like so: INSERT INTO some_table (column1, column2, column3) SELECT Rows.n.value('(@column1)[1]', 'varchar(20)'), Rows.n.value('(@column2)[1]', 'nvarchar(100)'), Rows.n.value('(@column3)[1]', 'int'), FROM @xml.nodes('//Rows') Rows(n) However I find that this is getting very slow for even moderate size xml data.

  Read the article

• Visual Studio different colour for constants, function names etc. ?

  - by Nick Brooks

  I know that you can change text editor colours but all the things I want to customized in one group "Identifiers". Is there a way to break that group into "Variables","Constants","Functions" and things like that so I can customize colours for those things separately?

  Read the article

• Is it more efficient (Performance) to store the CFC in application variables OR instance the CFC on the page call?

  - by Mitchell Guimont

  Hello, I'm working on a ColdFusion dynamic website. For this website, there are a lot of CFCs and a lot of functions within each CFC. Would it be more efficient to store an instance of the CFC in an application variable, then to instance each CFC separately on each page load. For each page, at most 2 separate CFCs get called. I'm also interested in how performance will be effected when requests increase (Stress). Thanks!

  Read the article

• SQL Server Compact Edition - Create Database Tables

  - by Lennie De Villiers

  Hi, I got it right to create a SQL Server CE database table using the code below: string connectionString = "DataSource=\"test.sdf\"; Password=\"mypassword\""; SqlCeEngine en = new SqlCeEngine(connectionString); en.CreateDatabase(); But how do I create my database tables and insert data? I've got the SQL created statements stored in the application Resource location.

  Read the article

• Most concise way to convert from date format: yyyy[3 digit day of year] to SQL datetime

  - by Seth Reno

  I'm working with an existing database where all dates are stored as integers in the following format: yyyy[3 digit day of year]. For example: 2010-01-01 == 2010001 2010-12-31 == 2010356 I'm using the following SQL to convert to a datetime: DATEADD(d, CAST(SUBSTRING( CAST(NEW_BIZ_OBS_DATE AS VARCHAR), 5, LEN(NEW_BIZ_OBS_DATE) - 4 ) AS INT) - 1, CAST('1/1/' + SUBSTRING(CAST(NEW_BIZ_OBS_DATE AS VARCHAR),1,4) AS DATETIME)) Does anyone have a more concise way to do this?

  Read the article

• MySQL - Calculate the net time difference between two date-times while excluding breaks?

  - by John M

  In a MySQL query I am using the timediff/time_to_sec functions to calculate the total minutes between two date-times. For example: 2010-03-23 10:00:00 - 2010-03-23 08:00:00 = 120 minutes What I would like to do is exclude any breaks that occur during the selected time range. For example: 2010-03-23 10:00:00 - 2010-03-23 08:00:00 - (break 08:55:00 to 09:10:00) = 105 minutes Is there a good method to do this without resorting to a long list of nested IF statements?

  Read the article

• Concept of creating static Map

  - by chetan

  I want to create a Map object that can lose value only if we explicitly delete it from map. I have created Map object like public static Map<Long,String> listUser =new HasMap<Long,String>(); but every time class object is created new instance of Map is also created that contain null value. I want to create a Map instance that contain value we stored before.

  Read the article

• How do I access the same bucket using multiple domains on Amazon S3?

  - by user205865

  I would like to parallelize requests to the resources stored on Amazon's S3 service by accessing them with different domains. I realize that I could just make multiple buckets and make sure the content is always the same. This is annoying however. Everytime I upload something, I have to do it 5 times. Thanks.

  Read the article

• dynamically generated Elements are not appended in document correctly in IE.

  - by basit74

  I have written a Javascript calender, that is dynamically generated by Javascript. But if does not functions in IE. here is the link to my script. http://asexpress.de/calender/ We one looks at IE Developer tool, the newly generated contents are there but do not show in browser. Any help please.

  Read the article

• Improve SQL Server 2005 Query Performance

  - by user366810

  I have a course search engine and when I try to do a search, it takes too long to show search results. You can try to do a search here http://76.12.87.164/cpd/testperformance.cfm At that page you can also see the database tables and indexes, if any. I'm not using Stored Procedures - the queries are inline using Coldfusion. I think I need to create some indexes but I'm not sure what kind (clustered, non-clustered) and on what columns. Thanks

  Read the article

• How could I iterate the values in ArrayList in java from java script?

  - by i2ijeya

  I have stored a bulk of objects in an ArrayList and I have set that in the request. Now I want to retrive the values in the Arraylist from my java script. Please help me with the solution

  Read the article

• How to render View from a string?

  - by Fleents

  I have a string like this, stored in the database: < %@ Control Language="C#" Inherits="System.Web.Mvc.ViewUserControl" % < %= Html.Encode("< strong hello< /strong ") % How can I render this to the page?

  Read the article

• problem to Get Date, month Year separately From database in Php File ?

  - by aamir Fayyaz

  i want to separate date, month, time, hour, min ,sec getting from database, for count down timer, in data base stored date is 2010/10/10: me using this code : $m=date('m',$row['Date']); $d=date('d',$row['Date']); output is month=31 date = 12....

  Read the article

• How to relink existing shared library with extra object file

  - by awy

  I have existing Linux shared object file (shared library) which has been stripped. I want to produce a new version of the library with some additional functions included. I had hoped that something like the following would work, but does not: ld -o newlib.so newfuncs.o --whole-archive existinglib.so I do not have the source to the existing library. I could get it but getting a full build environment with the necessary dependencies in place would be a lot of effort for what seems like a simple problem.

  Read the article

• Is it possible to symbolically reference a Perl CORE module?

  - by Blaise Roth

  I know I could easily do something like sub sin { sin($_[0]); } and symbolically reference that for every function I need to symb ref, but I'd just like to know if there's a way to do something like {$foo}(123); vs. &{$foo}(123); which works, but not for core functions. Thanks.

  Read the article

• Convert.ToSingle() for float data Type

  - by Asim Sajjad

  I have used many of the Convert.To..... functions for conversion , but I didn't understand one thing that for every datatype they have provide a Convert.To function but not for float datatype, in order to convert to float you need to use Convert.ToSingle() , why is this so ?

  Read the article

• How exactly does fopen(), fclose() work?

  - by user625672

  Hi, I was just wondering about the functions fopen, fclose, socket and closesocket. When calling fopen or opening a socket, what exactly is happening (especially memory wise)? Can opening files/sockets without closing them cause memory leaks? And third, how are sockets created and what do they look like memory wise? I'm also interrested in the role of the operating system (Windows) in reading the sockets and sending the data.

  Read the article

• django forms overwrite data when saved

  - by dana

  If a have a form, with the data from a user, let's say a CV, and i save the data from the form into a database, but i don't want that a CV from the same user to be stored in the database more than once(when edited form instance) I want it to be overwritten every time it is saved by one same user. How can i do it? thanks a lot

  Read the article

• GSP rendering programatically

  - by tuler

  Suppose I have a gsp snippet stored in my database. How do I programatically merge it with a data model to produce a string.

  Read the article

• How do I make an Android library for static linking that includes resources?

  - by Jim Blackler

  I am successfully linking some of my code stored in a .jar-based library to my Android app. The .jar code references Android library content just fine. The problem is I need to include 'res' resources in the library but can't work out how to do this. Any suggestions?

  Read the article

• In perl, can I call a method before executing every function in a package?

  - by hermanningjaldsson

  I am writing a module and I want a specific piece of code to be executed before each of the functions in it. How do I do that? Is there no other way than to just have a function-call at the beginning of every function?

  Read the article

• Share your conky tips / scripts / .conkyrc

  - by Chad Birch

  I've just started tinkering with conky, and I'm hoping the StackOverflow crowd can share some of the cool things they've done with this tool. Scripts and .conkyrc files specifically geared towards developers would be especially good to see. Some good examples of developer-centric functions would be repository-monitors or heck, even something that monitors StackOverflow. Screenshots of what the functionality actually looks like would be appreciated as well.

  Read the article

• How do I tell cmake to do these two steps to use winpcap?

  - by Gtker

  Quoted from here: If your program uses Win32 specific functions of WinPcap, remember to include WPCAP among the preprocessor definitions. If your program uses the remote capture capabilities of WinPcap, add HAVE_REMOTE among the preprocessor definitions. Do not include remote-ext.h directly in your source files. Has anyone managed to use winpcap with cmake?

  Read the article

• RTTI and Portability in C++

  - by Joshua

  If a compiler doesn't "support" RTTI, does that mean that the compiler can not handle class hierarchies that have virtual functions in them? Or have I been misunderstanding the literature about how RTTI isn't portable, and the issues lie elsewhere?

  Read the article

• jQuery each doesn't have a callback-possibility?

  - by Martti Laine

  Hello I have a loop created with each, check this example: $('.foo').each(function(i){ //do stuff }); Is there any possibility to run a functions when this loop has ended? Couldn't find it on docs or Google. I can make it work without this kind of solution, but it's always good to search for and use the simpliest methods. Martti Laine

  Read the article

< Previous Page | 297 298 299 300 301 302 303 304 305 306 307 308  | Next Page >