Search Results

Search found 27339 results on 1094 pages for 'sql dmv'.

Page 253/1094 | < Previous Page | 249 250 251 252 253 254 255 256 257 258 259 260  | Next Page >

• Select all rows where a varchar column converts to a decimal

  - by Blankman

  I have a varchar column that has generally has a decimal value, but some times there is some garbage text characters in that field. Is it possible to filter in the WHERE clause for rows that sucessfully convert to a decimal value? I am using sql-server 2005

  Read the article

• retrieve image from sql server in picturebox

  - by user3116296

  I have saved a picture in sql server and now i can not to retrieve image and set it's in picturebox with linq. why byte[] x become null? private void dataGridViewUser_CellClick(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = dataGridViewUser.CurrentRow; byte[] x=(byte[])row.Cells["Image"].Value; …

  Read the article

• Import Excel to sqlserver 2005 using Sqlbulkupload

  - by Jayesh

  Hi all, I want to upload excel file using SqlBulkCopy into sql server 2005 table. My excel file size is 43MB. When i am uploading this file it will display error message that "The request filtering module is configured to deny a request that exceeds the request content length.". My web.config file setting is <httpRuntime…

  Read the article

• Getting max. screen resolution with Group By

  - by Quandary

  Question: I have a website where I gather browser statistics. I have an SQL table (T_Visits), with the following columns: uniqueidentifier Visit_UID, uniqueidentifier User_UID, datetime Visit_DateTime, float Screen_w, float Screen_h, float Resolution = Screen_w * Screen_h varchar resolutionstring = screen_w + ' x ' +…

  Read the article

• How to disambiguate a sequence in sql?

  - by Martin

  I have a table of data which represents a series of events that persons do over time, sometimes people do the same thing several times in a row. How to select a result using MS SQL 2008 that shows only disambiguated sequences of those events? Source data: Person Event Time 1 2 1 1 2 20 1 2…

  Read the article

• Finding all tables and fields on "many" side of relations with a certain table

  - by bzamfir

  in Sql Server 2005, I have a master table, and several other tables which are related to this master through several one to many relations. How can I find all tables and fields which are in relation with the primary key in the master table, on "many" side? I know I can extract this by querying views from…

  Read the article

• Running SQL Profiler in the background

  - by cfdev9

  I want to leave sql profiler running all the time logging any queriy that runs for longer than 5 seconds. It's simple enough to start this using the profiler tool on my PC but how do I create it so it runs in the background on the server?

  Read the article

• Avoiding SQL Injection in SQL query with Like Operator using parameters?

  - by MikeJ

  Taking over some code from my predecessor and I found a query that uses the Like operator: SELECT * FROM suppliers WHERE supplier_name like '%'+name+%'; Trying to avoid SQL Injection problem and parameterize this but I am not quite sure how this would be accomplished. Any suggestions ? note, I need a…

  Read the article

• Copy row to another row in same table and vise versa Sql Server

  - by AmRoSH

  I have Table and i want to copy data from row to another and vise versa and i have the rows IDs. is there any query to do that because i don't want make it by .net code i think sql query is easier than that. thanks

  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

• what does 'legend' mean in sql?

  - by every_answer_gets_a_point

  im doing some practice sql problems one of the questions is: Prepare a shipping statement for customer 'C001' it should show the date, the legend 'Delivery' and the total value of the products shipped on each day. 'delivery' is not a table nor is it a column in any table. what does…

  Read the article

• How to Implement Excel COMBIN function in SQL

  - by Umar Siddique

  How can i implement Excel COMBIN function in SQL 2005, either in a store procedure or in a function. About COMBIN function in Excel follow this Link. Thanks.

  Read the article

• Convert sql query

  - by nisha

  I have used this query in sql,pls convert this query to use for access database. Table structure is UserID,Username,LogDate,LogTime WITH [TableWithRowId] as (SELECT ROW_NUMBER() OVER(ORDER BY UserId,LogDate,LogTime) RowId, * FROM @YourTable), [OddRows] as (SELECT * FROM…

  Read the article

• SQL server globalization

  - by Nijesh patel

  When using arabic language, data is stored in database with ? (question mark) sign instead of real arabic characters in SQL server. Suggest me solution if anybody have idea.

  Read the article

• TSQL, How to get smalldatetime's time between two smalldatetime's times ?

  - by eugeneK

  I have Table with two smalldatetime columns, where one is startTime and other one is endTime. I need to select all values from table which between times of both columns compared to getdate()' time. I'm using SQL-Server 2005. example startDate endDate value1 2/2/01 16:00 2/2/01…

  Read the article

• SQL - First row inserted every day for the past X days

  - by okie.floyd

  A tough SQL question (I'm using postgres by the way). I need the first row inserted every day for the past X days. one of my columns is a timestamp, which i hold the time inserted, and another column is the row id. If it's not possible to get the first row inserted every day, i at least…

  Read the article

• Sql server messed up degree symbol

  - by user228058

  Some of the degree sysmbols in my sql server database are displaying like this: 173-¦F. When I do a search for that - SELECT * FROM PRoduct WHERE description LIKE '%-¦%', it does not bring them up. How can I find (and replace) such characters?

  Read the article

• Save Sql Recordset into the Flat text file?

  - by mahesh kumar

  Hi, i need to dump my sql query result into the text file. i have created the following query, DECLARE @cmd VARCHAR(2048) SET @cmd = 'OSQL -localhost -CRN370 ' + ' -UCRN370 -PCRN370' + ' -Q"SELECT TOP 5 GageId FROM EwQMS370..msgages"' + ' -oc:\authors.txt' EXEC master..xp_cmdshell…

  Read the article

• SQL Invalid Object Name 'AddressType'

  - by salvationishere

  I am getting the above error in my VS 2008 C# method when I try to invoke the SQL getColumnNames stored procedure from VS. This SP accepts one input parameter, the table name, and works successfully from SSMS. Currently I am selecting the AdventureWorks AddressType table for it to pull…

  Read the article

• Linq@sql Is it possible to excute sql query with Linq2Sql for a type not defined in codegen

  - by Malcolm

  Hi, I have an app and I have come to a point where I need to build a sql statement up dynamically. Is there a way to execute it and return a type that has not been defined via the designer with Linq2Sql?? Malcolm

  Read the article

• vb6 ADODB TSQL procedure call quit working after database migration

  - by phill

  This code was once working on sql server 2005. Now isolated in a visual basic 6 sub routine using ADODB to connect to a sql server 2008 database it throws an error saying: "Login failed for user 'admin' " I have since verified the connection string does work if i replace the body of…

  Read the article

• Java Servlet connecting to SQL Server tutorial?

  - by phill

  Can anyone recommend a tutorial on how to write a Java Servlet which connects to MS SQL server and manages data? I'm trying to write something which pulls products out of one database and inserts them into a stored procedure located on another database. Thanks in advance.

  Read the article

• Execute SQL Task error -

  - by sharadov

  I get the following error when I call a stored proc within an execute sql task in SSIS. "Description: Executing the query "Exec up_CallXXX" failed with the following error: "Incorrect syntax near '13'.". Possible failure reasons: Problems with the query, "ResultSet" property not set…

  Read the article

• SQL Server Index Naming Conventions

  - by Eric Ness

  Is there some standard way to name indexes for SQL Server? It seems that the primary key index is named PK_ and non-clustered indexes typically start with IX_. Are there any naming conventions beyond that for unique indexes?

  Read the article

• SQL Server Express - Trying to add Network Service but it doesn't allow me to

  - by Ardman

  I have been trying to fix this solution for the last day. I'm trying to add NETWORK SERVICE as a user to the SQL Server Express installation on the server. Everytime I get the error 'User does not have permission to perform this action.'. Any ideas?

  Read the article

< Previous Page | 249 250 251 252 253 254 255 256 257 258 259 260  | Next Page >