Search Results

Search found 101927 results on 4078 pages for 'ms sql server'.

Page 416/4078 | < Previous Page | 412 413 414 415 416 417 418 419 420 421 422 423  | Next Page >

• Update String Columns without Using Single Quotations - General Question

  - by peace

  UPDATE CustomerPhone SET PhoneTypeID = 7, PhoneNumber = 999-444 WHERE CustomerID = 500 AND PhoneNumber = 9-1-1; PhoneNumber is of type varchar(20) whereas PhoneTypeID and CustomerID are of type int. I'm running the above statement in SQL Server, it works fine. I wonder how come it works? I thought any string value has to be put between '...'

  Read the article

• Bulk Insert multiple records and get identity for all using ADO.NET

  - by Hasan Khan

  I want to batch insert multiple records in sql server database using ADO.NET command/sqldataadapter and get identity value generated for all the rows in a single database trip. What are my options?

  Read the article

• Refactoring SQL

  - by Mongus Pong

  Are there any formal techniques for refactoring SQL similar to this list here that is for code? I am currently working on a massive query for a particular report and I'm sure there's plenty of scope for refactoring here which I'm just stumbling through myself bit by bit.

  Read the article

• How to interact sql database in vb.net desktop application

  - by KoolKabin

  Hi guys, I am writing a desktop database application. I want my application to use SQL database. What is the best way to start.

  Read the article

• Scope of Derived Tables in SQL Server

  - by FailBoy

  I've been looking into SQL recently and exploring a bit. in regards to Temp Tables I have discovered 3 different temp table types: 1) CREATE TABLE #TempTable 2) DECLARE TABLE @TempTable 3) SELECT * FROM (SELECT * FROM Customers) AS TempTable Now I understand the scope behind the #TempTable and the @TempTable types, but what about the derived table as in example 3? Where does this derived table get stored? and if it is declared in 1 transaction, can a 2nd transaction access it, or is the scoping of Derived Tables that same as example 1 and 2?

  Read the article

• Tell SQL Server the error is "handled" in try...catch

  - by Restless Archer

  Hi. I'd like to indicate to SQL Server 2005, in my BEGIN CATCH...END CATCH block that the error is "handled"... That is, clear the error. Is that possible?? Thanks. A.

  Read the article

• Write a plugin/form for SQL server enterprise manager

  - by Daniil

  Is it possible to write a plugin or a form for SQL Server Enterprise Manager version 8? I'm doing some simple queries all the time to admin the databases. So wondering if I could write something for it.

  Read the article

• SQL Monitoring Overview

  - by andy

  Hi I currently loook after 20 odd databases in SQL server 2005 and need a tool for monitoring the performance and keep me informed if a database is running slow. Is there anything I can run within Managment studio of any other good third party tool (Pref free) that can do the job. Thanks

  Read the article

• ado sql update table with result of group by query

  - by brett

  I am trying to update records in an .mdb table with the number of records containing the same value The sql below does not work but I think gives an indication of what I am trying to achieve. UPDATE table1 AS A INNER JOIN (SELECT PH_BSP , Count(PH_BSP) AS PHCOUNT FROM table1 GROUP BY PH_BSP) AS B ON A.PH_BSP=B.PH_BSP SET A.PH_SORT = B.PHCOUNT; any ideas?

  Read the article

• SQL Query to get Count within a Stored Proc

  - by sia

  So i need to figure out how i can get a record count value and use that count as a new value to insert into a table. Ex: In My Stored Procedure @Count int What im looking for @Count to equal "select top (1) _fieldName from _someTable order by _fieldName Desc" Finally insert into _newTable (_fieldName) values (@Count) End I dont have to use a variable, just trying to demonstrate what im really trying to do. My SQL knowledge is pretty limited so no laughing, or smirking! ;)

  Read the article

• Update thousands of records in a DataSet to SQL Server

  - by MSIL

  I have half a million records in a data set of which 50,000 are updated. Now I need to commit the updated records back to the SQL Server 2005 Database. What is the best and efficient way to do this considering the fact that such updates could be frequent (though concurrency is not an issue but performance is)

  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 [TableWithRowId] WHERE rowid % 2 = 1), [EvenRows] as (SELECT *, RowId-1 As OddRowId FROM [TableWithRowId] WHERE rowid % 2 = 0) SELECT [OddRows].UserId, [OddRows].UserName, [OddRows].LogDate, [OddRows].LogTime, [EvenRows].LogDate, [EvenRows].LogTime FROM [OddRows] LEFT JOIN [EvenRows] ON [OddRows].RowId = [EvenRows].OddRowId

  Read the article

• Composite keys as Foreign Key?

  - by paulio

  I have the following table... TABLE: Accounts ID (int, PK, Identity) AccountType (int, PK) Username (varchar) Password (varchar) I have created a composite key out of ID and AccountType columns so that people can have the same username/password but different AccountTypes. Does this mean that for each foreign table that I try and link to I'll have to create two columns? I’m using SQL Server 2008

  Read the article

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

  - by AmRoSH

  I have Table and i want to copy data from row to another and vice 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

• Get tree representation from t-sql stored procedure

  - by alex

  Hi, I want to get tree representation answer from my t-sql stored procedure. How can I do it ? Does .NET have a predefined types for working with xml-answers from stored procedures ?

  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 18:00 1 2/2/01 21:00 2/2/01 22:00 2 2/2/01 05:00 2/2/01 22:00 3 getdate() gives 2/2/2000 21:40 so i need to get value1 2 and 3 thanks in advance

  Read the article

• Sql Server: all object dependencies

  - by Gjorgji

  Hi, Is there any place where I can find all possible object dependencies in Sql Server? What I mean by "object dependency" is a list of object that one object can depend on. For example, TABLE can depend on SCHEMA, TYPE, TABLE, FUNCTION, etc.

  Read the article

• how can i have a unique column in many tables

  - by Behrooz

  hi. I have ten or more(i don't know) tables that have a column named foo with same datatype. how can i tell sql that values in all the tables should be unique. I mean If(i have value "1" in table1) I should NOT be able to have value "1" in table2

  Read the article

• sql inner join problem

  - by Luke

  The following SQL query isn't working. I think the error is on the first line. SELECT SUBSTRING(tbl_news.comment, 1, 250) as tbl_news.comment, tbl_news.id, tbl_news.date, tbl_news.subject, tbl_users.username FROM tbl_news INNER JOIN tbl_users ON tbl_news.creator = tbl_users.id ORDER BY date DESC

  Read the article

• retrieving description item from sql server table column

  - by Pablo

  is it possible to retrieve by using connection.getschema() the description item from a sql server table column, just like it's possible to retrieve the column name, data type, is nullable, column default value, etc?

  Read the article

• Have PL/SQL Outputs in Real Time.

  - by martilyo

  Is it possible to have Outputs from PL/SQL in real time? I have a pretty huge package that runs for more than an hour and I'd like to see where the package is at a particular time. Anyways, I currently do this with a log table, which gets filled up with hundreds of log descriptions per run, I'm just curious if this is possible. Thanks!

  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 solution for classic ADO.NET - I don't really have the go-ahead to switch this code over to something like LINQ.

  Read the article

• Wb service interface for SQL reporting service

  - by SonOfOmer

  Hi everyone, I want to make web service that will be interface for SQL reporting service. I really do not know much about that, I need some guidelines in order to solve this. Any help or suggestion would be helpful. Thanks a lot.

  Read the article

• SQL CE ORMs for .NET CF

  - by Andy White

  Hopefully this isn't a duplicate, but does anyone know of any (good) ORMs that work with SQL Compact Edition, and can run in the .NET Compact Framework (e.g. Windows Mobile 5-6.x)?

  Read the article

• SQL Server Merge statement issue

  - by George2

  Hello everyone, I am learning and using SQL Server 2008 new Merge statement, merge statement will compare/operate source table and destination table row by row ("operate" I mean operations performed for when matched or not-matched conditions). My question is whether the whole merge process will be one transaction or each row comparison/operation will be one transaction? Appreciate if any document to prove it. thanks in advance, George

  Read the article

< Previous Page | 412 413 414 415 416 417 418 419 420 421 422 423  | Next Page >