SQL Server :: Time Change In Sql / Query?

Jul 19, 2010 04:52 AM

i need change time in sql ... but i dont query.. please any one give me query..how to change timing in sql...

ADVERTISEMENT

C# - When Using Sql Server Profiler Each Time Change Tab There Is A Query For Each Grid In Each Tab Sent To The Database?

Aug 24 10 at 10:18

I'm using ASPxPageControl and in each page I have a couple of grids. When Im using Sql Server Profiler each time I change Tab there is a query for each grid in each tab sent to the database. Is it possible not to load data for each grid while changing tabs ?

View 2 Replies View Related

How To Calculate Time As User Can Change Server Time

Apr 08, 2010 08:43 PM

I am trying to implement a license in which we will provide a license file which will be placed on the server root directory.This license file contain encrypted strings which have ServerName, Concurrent Sessions , Timeperiod.n this i have two issue.How could i calculate time as user can change server time.How could i maintain the concurrent login sessions [because i can't catch the event hen user close the browser].I will welcome any tehcnique otehr then javascript solution.[even polling] but i can't save session information in database

View 2 Replies View Related

Different Execution Time For Same Query - SQL Server?

Jan 28 at 6:23

I have a query:

Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12)

When I am executing this query, it is taking 1-2 seconds to execute, but when I am using the same query in stored procedure, the below query is taking more than 5 minute:

If(Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12))
BEGIN
-- CREATE TEMPORARY TABLE [Say: #temp1]
#temp1 => Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12)
inserting the same value in the temp table
drop #temp1
END

what could be the reason of this? and how can I resolve this? I am running the SP from asp.net

View 3 Replies View Related

How To Change Server Time

Dec 20 10 at 19:22

I need to change server time from asp.net page. Is it possible?

View 3 Replies View Related

SQL Server :: Run Time Sql Query Error / Invalid Format Specification - How To Fix It

Oct 29, 2010 01:34 PM

I have a stored procedure where i am creating a run time query.

Stored procdure compiled successfully. But when parameter is passed its have an error.

[code]....

Its have a Error like this.

Invalid format specification: '% (RTRIM(LTRIM(baln))) % '.'.

when i am trying to execute it with bold parameter.

exec USP_GetRedemptionBYPlayer 'baln',null,null,null

View 5 Replies View Related

SQL Server :: DataAdapter/SQLDataReader Takes Lot Of Time For Executing A Query?

Aug 31, 2010 03:36 AM

I have a webpage with 6 drop down lists. User can start with selecting any drop down list first, and then proceed in any order. 1. Assume when the 1st dropdown is selected first, rest 5 drop downs (except 1st) are filtered/updated based on the selected value in the 1st dropdown.2. Assume user selects the 4th dropdown second, rest 5 drop downs (except 4th) will be filtered/updated but the condition would be based on both 1st drop down and 4th drop down. But while filtering the first drop down, only the 4th drop down is used as filter (self-filter will be ignored).

The code works fine but I see a very bad performance hit in time when the user selects the fourth dropdown after selecting three drop downs. I tried using both SQLDataAdapter and SQLDataReader but neither used to solve the issue. The code takes a lot of time on one line in either of the code (which is highlighted below). When I run the query in SQLServer Mgmt Studio, the query completes in a few seconds.

[Code]....

View 5 Replies View Related

SQL Server :: Multitable Query After A Dropdownlist Item Change?

Aug 10, 2010 04:20 PM

Im trying to get gridview to update always when changing to different value in dropdownlist. I get my dropdownlist values from database, so for example I have 3 choices there (name1,name2,name3)The problem is that I need to get results for that gridview from 3 different tables. I know how to query those in behind-code file and bind it to a gridview for example..but I dont know how to get it work if I have it also binded on dropdownlist where it should get the name* valuebefore being able to print the results from 3 different tables to the gridview depending of the name* value..And I can't have both DataSource and DataSourceId defined on just 1 gridview..I am using Sqlserver database, asp.net 3.5 with c#

View 3 Replies View Related

Web Forms :: String.Format (DateTime) - Time To Show MY Time Not Server's Time - Manipulate Or Include A Time Zone?

Dec 08, 2009 03:57 PM

LastGeneratedLabel.Text =
String.Format("{0:G}", stats.LastGenerated);

However, the server is on the west coast and I am on the east coast. So, naturally, I want the time to show MY time, not their server's time. How would I manipulate this or include a time zone? That, or add 3 hours to the time?

View 5 Replies View Related

Linq Query Does Not Display Result The First Time But The Second Time?

Feb 10, 2009 09:13 AM

I have a page and a button, when the user click the button a linq query result is displayed. The weird thing is that when the user access that page for the first time nothing hapend when he click the button, But if he reload the page and then click the button it works.

View 5 Replies View Related

Forms Data Controls :: Each Time The Page Is Refreshed This Time Would Change?

Nov 13, 2009 11:44 AM

I have a simple gridview that is using a select statement to retrive data from my table including the getdate() value. i.e there is a record of the data and time each record was placed on the system. I would like to create a calculated field in my gridview that tells the user the amount of time the record has been on the system in days,hours,mins..i.e[ Date/Time record created] - [ Date/Time Now]...each time the page is refreshed this time would change..how can this be done?

View 3 Replies View Related

Find The Time Difference Between Server Time And Client Side Time?

Oct 22, 2009 06:18 PM

i have a web app where i need to find the time difference between server time and client side time. i know i can use DateTime.Now() to get the server time.

View 2 Replies View Related

DataSource Controls :: Can't Find Query's / By Right Clicking On Database Created A Query In Server Explorer?

May 17, 2010 05:07 PM

By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.

View 10 Replies View Related

SQL Server :: Sub Query In Cross Table Query To Create Statistics

Mar 02, 2011 08:28 PM

I am trying to create statitics for game downloads and am having dificulty with a sub part of my query. the goup by command is not having the disired result and i think i have been looking at it too long to see what i am doing wrong. [Code]....

At the moment it is producing each result in many rows when only 4 rows should appear. its the download column that is doing it. needs to be sub queried or something to display total in relation to month,gameid,userid.

Month-download-GameID-UserID

1 1
1 1

1 1
1 1

View 2 Replies View Related

SQL Server :: Query Slow In Loading / Trying To Display Query Result?

Feb 01, 2011 07:24 PM

I am trying to display this query result in an aspx page.

It is very slow in loading. Here is the query. The inner query inside the outer quesry is the problem.(Please see the underlined part in the query) - (If I remove that part it is very fast.)

select

top 500

--This column is the issue
,Governing_Class=( case when exists (select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.appid and tqc.class_code not in('8742' ,'8810','7380')
order by tqcm.premium_amt desc
)
then ( select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.
appid
order by tqcm.premium_amt desc
)
......... From tables

View 7 Replies View Related

Databases :: Oracle Query Convert To Sql Server Query

Sep 03, 2010 07:23 AM

I am a biggner in SQL DB . but i started a complicated and painfull work in SQL SERVER 2008. the problem convert Oracle hierarchical query to SQL query. the query

SELECT DISTINCT
LEVEL LVL,
SCH.NSCHEDULE_SL,
SCH.NSCHEDULE_SL_FM,
SCH.CSHED_CNAME
FROM FA_SCHEDULES SCH
WHERE LEVEL = 1
AND NSCHEDULE_SL_FM IS NULL
AND NBRANCH_SL = 2
CONNECT BY PRIOR SCH.NSCHEDULE_SL_FM = SCH.NSCHEDULE_SL
AND NBRANCH_SL = 2

View 1 Replies View Related

Security :: Time In LastLoginDate Field Ahead Of Local Server Time 3 Hours?

Mar 25, 2010 06:13 PM

In my asp.net application I user Microsoft Membership to manage site access security and find the time saved into LastLoginDate is ahead of local time (Eastern Time Zone) 3 hours. What is wrong with it and how to ajust it to local time by application system only such as changing some properties od application?

View 2 Replies View Related

User From Different Contries Creat Blogs, The Displayed Time For Respective Blog Will Be A Server Time?

Jun 16 09

I have one web site and server that is hosted on "Pacific Standard Time" Zone .

When a user from different contries creat blogs the displayed time for respective blog will be a server time.the code below is what i am using for conversion..

TimeZoneInfo PTZone = TimeZoneInfo.FindSystemTimeZoneById( "Pacific Standard Time" );
lbl_createonvalue.Text = TimeZoneInfo.ConvertTime( DateTime.Parse( incident.CreatedOn.ToString() ), PTZone, TimeZoneInfo.Local ).ToString( "MM/dd/yyyy" );

But i want Date Time to be displayed on respective timezones.Is there any Javascript that can handel conversion at client side or any other code that works good for my scenario?

View 3 Replies View Related

The ShowTime Function Returns Server Time Or Client's Time

May 12, 2010, 05:38

Here is a bunch of code from a certain site;

Code:
<script type="text/javascript">

function ShowTime() {
[Code]....

the ShowTime function returns server time or client's time.However, I know that javascript executes in the client side.

View 3 Replies View Related

Security :: How To Add Query String In URL At Run Time

Jul 18, 2010 10:21 AM

[URL]UserFiles/ArticlesFiles/633574997433655321_Raja_images.jpg when I click any of secure page like (user page , admin or user ) and I am not login then it will show me in url like this http://localhost:59847/FormsAuthenticationAdvanced/login.aspx?ReturnUrl=/FormsAuthenticationAdvanced/secure/securepage.aspx
& displays login form. After login it will redirect me to that respective page which I clicked ( like if secure page is clicked before login then after login it will redirect me to secure page ).

View 1 Replies View Related

Databases :: How To Get Query Execution Time

Sep 02, 2010 11:17 AM

I need to find out the query execution time from the front end .Where should I insert the code for that.

I am using the bleow query:

OracleConnection con = new
OracleConnection(ConnStr);
con.Open();
OracleCommand cmd =
new
OracleCommand("Stored_Proc",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add();
....................
................
OracleDataAdapter
oda = new
OracleDataAdapter
(cmd);

View 2 Replies View Related

MVC :: LINQ Query Very Slow (only The First Time)?

Dec 17, 2009 06:45 AM

I'm facing performance problems in my MVC application. The view is displaying a table with 150 rows, the data is collected in the controller. In the controller function, I'm using LINQ to SQL to get the data from tables stored in MS SQL 2005 server.Loading of the view takes far too long, approx. 10 seconds. The same when I reload the page - 10 seconds again. Now the stange thing:

[code]...

The LINQ call seems to take a long time only the first time I call it inside the controller funtion, a second, third etc. call is much faster.My first guess was that there is something cached, so the second call is much faster. But when I reload the view, the cache seems no longer exist because it takes 10 seconds again.

View 4 Replies View Related

SQL Server :: How To Copy Result Query To Another Query

Nov 04, 2010 02:21 PM

i have tow query in one stored procedure

first query and the second one every of them return only value

i want to copy the result of tow values in a new row in new table

as i want to check on this tow values in ado.net

i want to get only this tow values as a row not first and secon query

only a row has result of first and second query results

[Code]....

View 3 Replies View Related

SQL Server :: Select Second Query If First Query Returns Nothing?

Oct 14, 2010 12:39 PM

How can I SELECT second if first SELECT returns nothing?

View 8 Replies View Related

How To Fire Query On Specific Time Like Trigger

Mar 10 at 5:41

How It Possible Unpublished Record On Base Specific Time Like 22-03-2011 11:01 Pm All Record Are Unpublished It Is Possible From Sql Server Side.

View 2 Replies View Related

DataSource Controls :: Sql Query With Time Formate

Jun 15, 2010 01:53 AM

i have one sql query probem

i have table with following fields

id , event_start_time , event_end_time values is

1 , 10:00:00 AM , 1:15:00 PM

2 , 2:15:00 PM , 5:30:00 PM

both event_start_time , event_end_time has datatype is Date/Time

now i need to write a query that is

lbltime.text="7:43:45"

select * from qry_daily_events where event_start_time>= '" & LblTime.text & "' and event_end_time <= '" & LblTime.text & "'"

but i m getting data type mismatch error and i try to conver but i m not get it.

View 3 Replies View Related

Databases :: Takes A Lot Of Time To Execute A Query?

Dec 14, 2010 04:27 AM

I have table for past four years. It had a records for around 10 Lacks it was taking lot of time to execute so i removed recordes from the table. Table size was reduced to 29 thousand. Still when i execute a query from my application it takes more than 2 minutes to return.

View 4 Replies View Related

Access :: Select & Update Query At The Same Time?

Nov 29, 2010 09:17 PM

Currently I run 2 separate queries to update + retrieve a tickent number. What happens if there're 2 users clicking on the same button at the same time? Could somehow two updates being run first and then both users get back the same ticket number?

string mySql = "UPDATE TicketCounter SET TicketNumber = (TicketNumber + 1)";
OleDbConnection myConnection = new OleDbConnection(accessConnStr);
OleDbCommand myCmd = new OleDbCommand(mySql, myConnection);
myCmd.Connection.Open();
myCmd.ExecuteNonQuery();
mySql = "SELECT TicketNumber FROM TicketCounter"
myCmd.CommandText = mySql;
OleDbDataReader myReader = myCmd.ExecuteReader();

View 4 Replies View Related

DataSource Controls :: Query With DataSet To Get Every Time Next 20 Records

Apr 29, 2010 06:56 AM

I am using dataset which contains some records I want to query with dataset to get every time next 20 records. I don't want to do it throught loop is there any way that I can get next 20 records everytime.

View 5 Replies View Related

SQL Reporting :: Write Query In Run Time In SSRS 2005

Jan 09, 2011 04:50 AM

i want to write query in run time in SSRS.is it possible??...

View 1 Replies View Related

How To Change C# Trackbar Query

Aug 18, 2009, 03:22

[URL]

I have found a custom Track Bar.

Now say the "GTrackBar6". Can the value box be set in the middle of the Trackbar? What I notice that the Value Box can only be set in one side. Which code should I change if I want to put it in the middle of the Trackbar?

View 2 Replies View Related

SQL Server :: How To Convert Time To Military Time

Oct 29, 2010 07:58 PM

I have a datetime column in my table. It has a value like this for example: 4/27/2010 7:34:00 PM. I would like to display the time part of the column in military time. So this datetime column would appear as: 4/27/2010 19:34

Is this possible?

View 2 Replies View Related

How To Change Page On Time

Mar 31, 2010 09:52 AM

I have 5 pages and need to have the next page loaded after 20 seconds and so on, and rotate continuously.

Ideally I would like to have a sitemap xml and loop through to get the next page, but as I have so few pages (they show different dynamic data) i dont mind hardcoding the page names.

Where do i find a timer object?

View 2 Replies View Related

Change Single URL Query String Value?

Sep 28 10 at 14:42

I have an ASP.NET page which takes a number of parameters in the query string:

search.aspx?q=123&source=WebSearch

This would display the first page of search results. Now within the rendering of that page, I want to display a set of links that allow the user to jump to different pages within the search results. I can do this simply by append &page=1 or &page=2 etc.

Where it gets complicated is that I want to preserve the input query string from the original page for every parameter except the one that I'm trying to change. There may be other parameters in the url used by other components and the value I'm trying to replace may or may not already be defined:

search.aspx?q=123&source=WebSearch&page=1&Theme=Blue

In this case to generate a link to the next page of results, I want to change page=1 to page=2 while leaving the rest of the query string unchanged.

Is there a builtin way to do this, or do I need to do all of the string parsing/recombining manually?

View 4 Replies View Related

Custom Server Controls :: Change In Nested Property Does Not Change Code?

Dec 15, 2009 06:19 AM

This might not be a VS-problem, but I think I am using VS wrong!?

I am writing a Web Server Control. I Created a property "Title" as label:

[Code]....

The control is insertet in the ASP.NET page as this:

[Code]....

When I expand the Title property in VS' property window, and indsert the text value in the text property of the Title property, nothing is shown in the code. I would have expected code to change to somthing like:

<cc2:TestControl ID="TestControl1" runat="server" Src="ep.jpg" Title-text="My title" />

If I however manually insert the abowe in the object, it works fine, and it will also be inserted in the text-property of the Title-property in the property window. It just does'nt work the other way around.
I can also access the Title property by refering to "TestControl1.Title.text" and it works fine.

So - what do I do to be able to insert the text-property (and other properties of the Title-label) via the property window?

View 4 Replies View Related

Web Forms :: Dropdownlist Result Set Query Shows Multiple Time How To Set Single

Nov 12, 2010 10:09 AM

I Pieces
NA 400

View 7 Replies View Related

How To Change To Just Display The Date And No Time

Mar 04, 2009 12:49 PM

I have a report in VS2005 and the field uses the following to display the date:

=First(Fields!RequisitionDeliveryDate.Value, "Reports_FieldPOReports")

Which works fine, but it displays the date as: "4/30/2009 12:00:00 AM" how can this be changed to just display the date and no time. It's being pulled from a smalldatetime DB field.

View 4 Replies View Related

DataSource Controls :: Change Columns Name After SQL Query ( For Xml Raw)?

Apr 15, 2010 06:11 AM

this is my sample script

[Code]....
after execute this script which returns a column name "XML_F52E2B61-18A1...." can I change this column name?like this

select EMPNO AS EmployeeName -- we can use AS to change column name
from EMPLOYEE

View 1 Replies View Related

Query - Use A Checkbox To Change The Results Of A SqlDataSource?

Feb 2 at 21:09

I'm using Visual Web Developer 2010 Express. This is my first attempt at creating a .NET page. I have a Gridview on a page that displays the results of a GridQuery. This works. I have a checkbox control(cb_Filter) on the same page that if checked, should add to the where clause of the GridQuery, (where Column5 IS NULL). How do I check the state of the check box so it will run the query with or without the "filter".

View 2 Replies View Related

Query To Change Listbox Selection Mode?

Mar 1 10 at 18:48

I have an ASP.NET page with a listbox whose selection mode is set to multiple by default. I would like to set its selection mode to single on a button click.

Code snippet of my attempt:

$('#testBtn').click(function(){
$('#testListBox').attr("SelectionMode","Single");
});

It is not working though. What am I doing wrong here and how to get it to work?

View 1 Replies View Related





Banners
Copyrights 2005-14 www.BigResource.com, All rights reserved