Search Results

Search found 27497 results on 1100 pages for 'sql joke'.

Page 313/1100 | < Previous Page | 309 310 311 312 313 314 315 316 317 318 319 320  | Next Page >

• Alter View not recognizing column

  - by Chris

  I have scripts for adding columns to tables which worked. When I run scripts to alter views with the new column the script fails because the columns are not recognized Msg 207, Level 16, State 1, Procedure UniqueTempDispositions, Line 76 Invalid column name 'servicerequestid'. Msg 207, Level 16, State 1, Procedure UniqueTempDispositions, Line 47…

  Read the article

• What can be a cookie? How to set with OUTPUT? RETURNVALUE?

  - by Ronnie Chester Lynwood

  hello. i think i got some problems with setting a cookie data. for this code: Set cmdDB = Server.CreateObject("ADODB.Command") With cmdDB .ActiveConnection = ADOConM .CommandText = "usp_jaljava_member_select" .CommandType = adCmdStoredProc .Parameters.Append…

  Read the article

• LINQ to SQL does not update when data has changed in database

  - by aximili

  I have this problem where after a field (say Field3 in table MyTable) is updated on the database, MyTable.Field3 (in C#) is still returning the old value. I suspect there is some caching...? How do I force it to: Read the value from the database? OR Update the value in the MyTable class? Or is there anything I miss? …

  Read the article

• SQL Joins on varchar fields timing out

  - by CL4NCY

  Hi, I have a join which deletes rows that match another table but the joining fields have to be a large varchar (250 chars). I know this isn't ideal but I can't think of a better way. Here's my query: DELETE P FROM dbo.FeedPhotos AS P INNER JOIN dbo.ListingPhotos AS P1 ON P.photo = P1.feedImage INNER JOIN dbo.Listings…

  Read the article

• Data validate tools (ETL tools) for SQL server

  - by Stan

  I have some data in Excel and need to import into database. Is there any tool that can validate and maybe clean the data? Does Red Gate have such tool? The input will be Excel. Given table constraints, eg. CHECK, UNIQUE KEY, datetime format, NOT NULL. Desire output should be as least shows which lines are having…

  Read the article

• Adjust SQL query to DB2

  - by Guy Roth

  Part of a complex query that our app is running contains the lines: ...(inner query) SELECT ... NULL as column_A, NULL as column_B, ... FROM ... This syntax of creating columns with null values is not allowed in DB2 altough it is totally OK in MSSQL and Oracle DBs. Technically I can change it to: '' as…

  Read the article

• Linq to SQL - Return top n rows

  - by jinsungy

  I want to return the TOP 100 records using Linq.

  Read the article

• Sql Shorthand For Dates

  - by vigilant

  Is there a way to write a query equivalent to select * from log_table where dt >= 'nov-27-2009' and dt < 'nov-28-2009'; but where you could specify only 1 date and say you want the results for that entire day until the next one. I'm just making this up, but something of the form: select * from…

  Read the article

• How to create item templates for SQL files, for Visual Studio Database Projects

  - by jonathanconway

  It's possible to define your own custom templates for normal project types, such as templates for C# files, for a Class Library project. What about a 'Database Project' scenario? I would like to define a standard template for adding a stored procedure, which uses the company's conventions for all stored…

  Read the article

• backup ms sql using asp.net

  - by kusanagi

  i have virtual hosting with mssql. i don't have physical access to mssql. i want to make backup and download it. how can i do it from asp.net page?

  Read the article

• TSQL Shred XML - Is this right or is there a better way (newbie @ shredding XML)

  - by drachenstern

  Ok, I'm a C# ASP.NET dev following orders: The orders are to take a given dataset, shred the XML and return columns. I've argued that it's easier to do the shredding on the ASP.NET side where we already have access to things like deserializers, etc, and the entire complex of known types, but no, the boss…

  Read the article

• Strange execution times in t-sql

  - by TonyP

  Hi All I have two stored procedures, the first one calls the second .. If I execute the second one alone it takes over 5 minutes to complete.. But when executed within the first one it takes little over 1 minute.. What is the reason ! Here is the first one ALTER procedure…

  Read the article

• linq-to-sql combine child expressions

  - by VictorS

  I need to create and combine several expressions for child entity into one to use it on "Any" operator of a parent. Code now looks like this: Expresion<Child, bool> startDateExpression = t => t.start_date >= startDate; Expression<Child, bool>…

  Read the article

• sql-server: how can I know my storedprocedure is optimum in performance

  - by RedsDevils

  Hi all, I would like to know how to measure/know that one's storedprocedure is optimum in performance. That storedprocedure can be inserting/deleting/updating or manipulating data in that procedure. Please describe the way/approach how to know performance in…

  Read the article

• SQL Join Problem

  - by Harley

  Table one contains ID|Name 1 Mary 2 John Table two contains ID|Color 1 Red 1 Blue 2 Green 2 Blue 2 Black I want to end up with is ID|Name|Red|Blue|Green|Black 1 Mary    Y      Y 2 John      …

  Read the article

• pl/sql object types "ORA-06530: Reference to uninitialized composite" error

  - by mutoss

  hi, i have a type as follows: CREATE OR REPLACE TYPE tbusiness_inter_item_bag AS OBJECT ( item_id NUMBER, system_event_cd VARCHAR2 (20), CONSTRUCTOR FUNCTION tbusiness_inter_item_bag RETURN SELF AS RESULT ); CREATE OR REPLACE…

  Read the article

• Controlling Trigger Execution When Bulk Importing Data

  - by Vishwa

  Hi In bulk insertion only in the last record trigger is executing. If I bulk insert 10 records the trigger is running only for the 10th record. But I need trigger to run on all 10 records. Please help me with an example

  Read the article

• How to refactor this database to allow sync. with smart clients?

  - by Anton Zvgny

  Howdy, I have inherited the following database: http://i46.tinypic.com/einvjr.png (EDIT: I cannot post images, so here goes the link) This currently runs 100% online thru an Asp.Net web app , but some employees will need to have offline access to…

  Read the article

• .NET and Closing SQL Server connections

  - by user307076

  I am having a hard time figuring out why the following constructor will not close connnections. When I view the active connections. Here is the code that I have. Public Sub New(ByVal UserID As Integer) Dim oConn As New…

  Read the article

• Linq sql Attach, Update Check set to Never, but still Concurrency conflicts

  - by remdao

  In the dbml designer I've set Update Check to Never on all properties. But i still get an exception when doing Attach: "An attempt has been made to Attach or Add an entity that is not new, perhaps having been loaded from…

  Read the article

• SQL housekeeping tasks on Herkoku

  - by Chris Beeson

  Hi, I'm not sure how to do this... I have a database which contains a messages and categories tables. The categories table has a field which has a count of the number of messages related to it. Sometimes however I…

  Read the article

• SQL Query - Get Sums from Two Different Levels of Hierarchy

  - by Matthew Jones

  A Project has multiple Tasks, which has multiple Assignments Projects (1-n) - Tasks (1-n) - Assignments A field on the Tasks table is Planned Hours. A field on the Assignments table is Assigned Hours. How do I get…

  Read the article

• Remove and split data into multiple columns in select statement.

  - by Muhammad Kashif Nadeem

  I have data like following table I want to remove Titles ( Mr. Miss, Dr etc) from name and want to split data into First name and last name if two names exists. I want this in select statement. I can remove title…

  Read the article

• Visual Studio 'SQL Server 2008 Server Project' vs. 'Sql Server 2008 Database project' ?

  - by user193189

  I can't see to find a quick explanation of the differences so I can figure out which to use. One is for a server one is for a Database? Im not sure what that means.. Basically we are doing a new web app and I…

  Read the article

• SQL 2008: Using separate tables for each datatype to return single row

  - by Thomas C

  Hi all I thought I'd be flexible this time around and let the users decide what contact information the wish to store in their database. In theory it would look as a single row containing, for instance; name,…

  Read the article

< Previous Page | 309 310 311 312 313 314 315 316 317 318 319 320  | Next Page >