Tracking Forums, Newsgroups, Maling Lists
Home Submit Tracker Forums
  Advanced Search
  HOME    TRACKER    ASP.NET


Advertisements:










SQL Server :: Time Change In Sql / Query?


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


View 5 Replies (Posted: Jul 19, 2010 04:52 AM)

Sponsored Links:

Related Forum Messages For ASP.NET category:
C# - When Using Sql Server Profiler Each Time Change Tab There Is A Query For Each Grid In Each Tab Sent To The Database?
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 ?

Posted: Aug 24 10 at 10:18

View 2 Replies!   View Related
How To Calculate Time As User Can Change Server Time
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

Posted: Apr 08, 2010 08:43 PM

View 2 Replies!   View Related
Different Execution Time For Same Query - SQL Server?
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

Posted: Jan 28 at 6:23

View 3 Replies!   View Related
How To Change Server Time
I need to change server time from asp.net page. Is it possible?

Posted: Dec 20 10 at 19:22

View 3 Replies!   View Related
SQL Server :: Run Time Sql Query Error / Invalid Format Specification - How To Fix It
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

Posted: Oct 29, 2010 01:34 PM

View 5 Replies!   View Related
SQL Server :: DataAdapter/SQLDataReader Takes Lot Of Time For Executing A Query?
I have a webpage with 6 drop downlists. 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]....

Posted: Aug 31, 2010 03:36 AM

View 5 Replies!   View Related
SQL Server :: Multitable Query After A Dropdownlist Item Change?
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#

Posted: Aug 10, 2010 04:20 PM

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?
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?

Posted: Dec 08, 2009 03:57 PM

View 5 Replies!   View Related
Linq Query Does Not Display Result The First Time But The Second Time?
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.

Posted: Feb 10, 2009 09:13 AM

View 5 Replies!   View Related
Forms Data Controls :: Each Time The Page Is Refreshed This Time Would Change?
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?

Posted: Nov 13, 2009 11:44 AM

View 3 Replies!   View Related
Find The Time Difference Between Server Time And Client Side Time?
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.

Posted: Oct 22, 2009 06:18 PM

View 2 Replies!   View Related
DataSource Controls :: Can't Find Query's / By Right Clicking On Database Created A Query In Server Explorer?
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.

Posted: May 17, 2010 05:07 PM

View 10 Replies!   View Related
SQL Server :: Sub Query In Cross Table Query To Create Statistics
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

Posted: Mar 02, 2011 08:28 PM

View 2 Replies!   View Related
SQL Server :: Query Slow In Loading / Trying To Display Query Result?
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

Posted: Feb 01, 2011 07:24 PM

View 7 Replies!   View Related
Databases :: Oracle Query Convert To Sql Server Query
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

Posted: Sep 03, 2010 07:23 AM

View 1 Replies!   View Related
Security :: Time In LastLoginDate Field Ahead Of Local Server Time 3 Hours?
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?

Posted: Mar 25, 2010 06:13 PM

View 2 Replies!   View Related
User From Different Contries Creat Blogs, The Displayed Time For Respective Blog Will Be A Server Time?
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?

Posted: Jun 16 09

View 3 Replies!   View Related
The ShowTime Function Returns Server Time Or Client's Time
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.

Posted: May 12, 2010, 05:38

View 3 Replies!   View Related
Security :: How To Add Query String In URL At Run Time
[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 ).

Posted: Jul 18, 2010 10:21 AM

View 1 Replies!   View Related
Databases :: How To Get Query Execution Time
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);

Posted: Sep 02, 2010 11:17 AM

View 2 Replies!   View Related
MVC :: LINQ Query Very Slow (only The First Time)?
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.

Posted: Dec 17, 2009 06:45 AM

View 4 Replies!   View Related
SQL Server :: How To Copy Result Query To Another Query
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]....

Posted: Nov 04, 2010 02:21 PM

View 3 Replies!   View Related
SQL Server :: Select Second Query If First Query Returns Nothing?
How can I SELECT second if first SELECT returns nothing?

Posted: Oct 14, 2010 12:39 PM

View 8 Replies!   View Related
How To Fire Query On Specific Time Like Trigger
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.

Posted: Mar 10 at 5:41

View 2 Replies!   View Related
DataSource Controls :: Sql Query With Time Formate
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.

Posted: Jun 15, 2010 01:53 AM

View 3 Replies!   View Related
Databases :: Takes A Lot Of Time To Execute A Query?
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 2minutesto return.

Posted: Dec 14, 2010 04:27 AM

View 4 Replies!   View Related
Access :: Select & Update Query At The Same Time?
Currently I run 2 separate queries to update + retrievea 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();

Posted: Nov 29, 2010 09:17 PM

View 4 Replies!   View Related
DataSource Controls :: Query With DataSet To Get Every Time Next 20 Records
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.

Posted: Apr 29, 2010 06:56 AM

View 5 Replies!   View Related
SQL Reporting :: Write Query In Run Time In SSRS 2005
i want to write query in run time in SSRS.is it possible??...

Posted: Jan 09, 2011 04:50 AM

View 1 Replies!   View Related
How To Change C# Trackbar Query
[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?

Posted: Aug 18, 2009, 03:22

View 2 Replies!   View Related
SQL Server :: How To Convert Time To Military Time
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?

Posted: Oct 29, 2010 07:58 PM

View 2 Replies!   View Related
How To Change Page On Time
I have5 pages and need tohave 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?

Posted: Mar 31, 2010 09:52 AM

View 2 Replies!   View Related
Change Single URL Query String Value?
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?

Posted: Sep 28 10 at 14:42

View 4 Replies!   View Related
Custom Server Controls :: Change In Nested Property Does Not Change Code?
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?

Posted: Dec 15, 2009 06:19 AM

View 4 Replies!   View Related
How To Change To Just Display The Date And No Time
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.

Posted: Mar 04, 2009 12:49 PM

View 4 Replies!   View Related
DataSource Controls :: Change Columns Name After SQL Query ( For Xml Raw)?
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

Posted: Apr 15, 2010 06:11 AM

View 1 Replies!   View Related
Query - Use A Checkbox To Change The Results Of A SqlDataSource?
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".

Posted: Feb 2 at 21:09

View 2 Replies!   View Related
Query To Change Listbox Selection Mode?
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?

Posted: Mar 1 10 at 18:48

View 1 Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved