Search Results

Search found 36756 results on 1471 pages for 'mysql real query'.

Page 629/1471 | < Previous Page | 625 626 627 628 629 630 631 632 633 634 635 636  | Next Page >

• Import and Export data from SQL Server 2005 to XL Sheet

  - by SAMIR BHOGAYTA

  For uploading the data from Excel Sheet to SQL Server and viceversa, we need to create a linked server in SQL Server. Expample linked server creation: Before you executing the below command the excel sheet should be created in the specified path and it should contain the name of the columns. EXEC sp_addlinkedserver 'ExcelSource2', 'Jet…

  Read the article

• LINQ and the use of Repeat and Range operator

  - by vik20000in

  LINQ is also very useful when it comes to generation of range or repetition of data.  We can generate a range of data with the help of the range method.     var numbers =         from n in Enumerable.Range(100, 50)         select new {Number = n,…

  Read the article

• Responsible BI for Excel, Even for Older Versions

  - by andrewbrust

  On Wednesday, I will have the honor of co-presenting, for both The Data Warehouse Institute (TDWI) and the New York Technology Council. on the subject of Excel and BI. My co-presenter will be none other than Bill Baker, who was a Microsoft Distinguished Engineer and, essentially, the father of BI at that company.  Details on the…

  Read the article

• Slow in the app, fast in SSMS

  - by DavidWimbush

  Users complain about a timeout but when you run the exact same query in SSMS it runs in a flash. Sounds familiar? I've been baffled by this before. I worked out that I was getting a different query plan in SSMS because of different SET OPTIONS but, having dealt with that, I was then stuck with parameter sniffing as the cause of…

  Read the article

• 5 minutes WIF: Make your ASP.NET application use test-STS

  - by DigiMortal

  Windows Identity Foundation (WIF) provides us with simple and dummy STS application we can use to develop our system with no actual STS in place. In this posting I will show you how to add STS support to your existing application and how to generate dummy application that plays you real STS. Word of caution! Although it is…

  Read the article

• Display root node of Hierarchical Tree using ADF - EJB DC

  - by arul.wilson(at)oracle.com

  Displaying Employee (HR schema) records in Hierarchical Tree can be achieved in ADF-BC by creating custom VO and a Viewlink for displaying root node. This can be more easily done using  EJB-DC by just introducing a NamedQuery to get the root node.Here you go to get this scenario working.Create DB connection based on HR…

  Read the article

• How to create dynamically LinkButton with Literal Control in ASP.NET

  - by SAMIR BHOGAYTA

  Step 1 : First take following control into the .aspx page. asp:UpdatePanel id="up1" runat="server" contenttemplate asp:Literal ID="lt1" Text="" runat="server" asp:PlaceHolder ID="ph1" runat="server" /asp:PlaceHolder /contenttemplate /asp:UpdatePanel Step 2 : string query = query for fill the dataset; DataSet ds = new…

  Read the article

• Speaking in St. Louis on June 14th

  - by Bill Graziano

  I’m going back to speak in St. Louis next month.  I didn’t make it last year and I’m looking forward to it.  You can find additional details on the St. Louis SQL Server user group web site.  The meeting will be held at the Microsoft office and I’ll be speaking at 1PM. I’ll be speaking on the procedure…

  Read the article

• Mass Metadata Updates with Folders

  - by Kyle Hatlestad

  With the release of WebCenter Content PS5, a new folder architecture called 'Framework Folders' was introduced.  This is meant to replace the folder architecture of 'Folders_g'.  While the concepts of a folder structure and access to those folders through Desktop Integration Suite remain the same, the…

  Read the article

• Google I/O 2010 - Next gen queries

  Google I/O 2010 - Next gen queries Google I/O 2010 - Next gen queries App Engine 301 Alfred Fuller This session will discuss the design and implications of improvements to the Datastore query engine including support for AND, OR and NOT query operators, the solution to exploding indexes and paging backwards…

  Read the article

• How to get current gnome keyboad layout from terminal

  - by ftiaronsem

  For usage in a bash script, I need to get the gnome keyboard layout the user is currently using. For example if the user sets its keyboard layout to en-us , I need a bash command that prints me this. How can I get that information? Update: setxkbmap -query is unfortunatelly not working. Below is the ouput…

  Read the article

• NDepend Evaluation: Part 3

  - by Anthony Trudeau

  NDepend is a Visual Studio add-in designed for intense code analysis with the goal of high code quality. NDepend uses a number of metrics and aggregates the data in pleasing static and active visual reports. My evaluation of NDepend will be broken up into several different parts. In the first part of the…

  Read the article

• System Slow After Uprading Ubuntu

  - by Aragon N

  i have an ubuntu network machine which has release of 10.04.1 LTS Lucid. on this system i have apache, postgresql and django. for some app. development i have to install php and php-curl... due to being on network, i have exported wmvare machine to internet and firstly i have upgraded system and then…

  Read the article

• Utility Queries–Database Files, (and Filegroups)

  - by drsql

  It has been a while since I last posted a utility query, and today, to avoid other work I am supposed to be doing, I decided to go ahead and work on another post.  Today, I went ahead and worked on a server configuration type query. One query I find I use pretty often is the following one that…

  Read the article

• What is the need of Odata when I have JSON ?

  - by punkouter

  I am trying to understand the point of Odata and when it would make sense. Right now how I work is I use ASP.NET and MVC/WebApi controller to serialize/deserialize objects into JSON and have javascript do something with it. From what I can tell the benefit of OData is being able to query directly…

  Read the article

• What Counts for A DBA - Logic

  - by drsql

  "There are 10 kinds of people in the world. Those who will always wonder why there are only two items in my list and those who will figured it out the first time they saw this very old joke."  Those readers who will give up immediately and get frustrated with me for not explaining it to them…

  Read the article

• Utility Queries–Database Files, (and Filegroups)

  - by drsql

  It has been a while since I last posted a utility query, and today, to avoid other work I am supposed to be doing, I decided to go ahead and work on another post.  Today, I went ahead and worked on a server configuration type query. One query I find I use pretty often is the following one…

  Read the article

• How to generate Visa checkout token? [on hold]

  - by Muhammad Junaid

  I am on process of creating a Visa checkout plugin but stuck in generating token Here are the token requirment: Format: Alphanumeric; maximum 100 characters in the form of token: x:UNIX_UTC_Timestamp:SHA256_hash, where UNIX_UTC_Timestamp is a UNIX Epoch timestamp SHA256_hash is an SHA256…

  Read the article

• Figuring our complex REST queries for SharePoint

  - by Sahil Malik

  SharePoint 2010 Training: more information A little while ago, I showed the REST query for a relatively complex query. Some readers have emailed me about how to figure out further queries, and especially for complex…

  Read the article

• Easy QueryBuilder - A User-Friendly Ad-Hoc Advanced Search Solution

  Constructing an easy and powerful QueryBuilder interface becomes more important for complex data grid filtering and accurate reporting services. In this article, I'll discuss how to build a query search engine using ASP.NET AJAX and dynamic SQL. The main goal is to provide an…

  Read the article

• Find out when a new domain appears in search results

  - by TerryB

  Does anyone know a way to perform the following: I want to know whenever a new domain starts appearing in the google search results for a particular query. For a given google search query, I'd like to receive an alert whenever a new domain pops up and starts appearing in…

  Read the article

• New DMV–yes… no… that’s complicated

  - by Michael Zilberstein

  Remember the excitement about new sys.dm_exec_query_profiles DMV? It promised to be a gamechanger, providing query visibility at a runtime and easily extractable information about heavy iterators in execution plan. So it has been announced but missing. Now in CTP2 it is…

  Read the article

• Sharing object between 2 classes

  - by Justin

  I am struggling to wrap my head around being able to share an object between two classes. I want to be able to create only one instance of the object, commonlib in my main class and then have the classes, foo1 and foo2, to be able to mutually share the properties of…

  Read the article

• How does Google store search trends in backend?

  - by Achshar

  Google trends shows what query has been searched how many times and some other properties of the said query. But how is this data stored in a database? Storing a new row for every search does not seem right. They also tell the query on a time graph, so they must…

  Read the article

• Google Analytics Request URI to Event advanced filter

  - by confidentjohn

  I have a query string attached to a Request URI. Whilst I can see this data within the pages report and it works, I was thinking about setting up an advanced filter to convert the request URI to an Event, with the hope this would clean up my pages report and sit…

  Read the article

< Previous Page | 625 626 627 628 629 630 631 632 633 634 635 636  | Next Page >