Search Results

Search found 47861 results on 1915 pages for 'sql update'.

Page 467/1915 | < Previous Page | 463 464 465 466 467 468 469 470 471 472 473 474  | Next Page >

• Visual Studio 2010's SQL Schema & Data Compare - Can it be accesed from code?

  - by RichardJohnn

  The other day I tried out VS2010's SQL compare tools and thought they were awesome. I am wondering if there is any way to harness these tools in code written in VS 2010.

  Read the article

• which RDBMS or other tool provides good SQL syntax error messages?

  - by zzz

  I use MySQL and it gives no meaningful error messages beyond "syntax wrong close to something or other". This is in sharp contrast to the sort of nice, clear error messages we are used to getting from java compiler and similar. So, are there RDBMS or sql validation tools that provide clearer, meaningful error messages?

  Read the article

• Command line Script for cleaning VS project + backing up SQL + zipping??

  - by tbone

  Does anyone happen to have some sort of a nice command line script they use that could do something like: Clean VS project (delete \bin folder contents, etc) Backup SQL Server database Zip all files up

  Read the article

• what the IIS featuer need to install or change in pc have windows 7 home to work sql server 2005 ss

  - by bassam

  what the IIS featuer need to install in pc have windows 7 home to work sql server 2005 (32 bit) ssrs not work i change all windows featuer in the PC what i need to install in pc

  Read the article

• Is it possible to use SQL XML to insert, and get output from each record?

  - by nbolton

  I would like to perform a SQL XML insert (on MSSQL), and in this case I need to insert a list of files into the DB (this is simple enough). However, there's an auto generated PK column (ID), and I need the ID for each newly created filename without performing a 2nd query. Is this possible? I guess it doesn't matter if the result is/isn't XML, but the input certainly has to be.

  Read the article

• How to install Visual Studio 2008 and MS SQL Server 2008 in Ubuntu ?

  - by Vicheanak

  Hi guys, I would like to install Visual Studio 2008 and MS SQL Server 2008 on Ubuntu OS which I have in my PC, however, I don't know how. May I have some tips please? Thanks.

  Read the article

• how to determine date when service pack was applied to SQL Server instance?

  - by Oliver

  For an instance of SQL Server 2005/2008, how can one determine the date and time when a service pack was applied to the instance? Is there a system table or view that stores that information?

  Read the article

• SQL: Is there a more efficient way to calculate elapsed hours, minutes, seconds?

  - by hamlin11

  I'm using Computed Columns to provide me with the following information: Hours, Minutes, and Seconds between a Start DateTime and Finish DateTime (Where Minutes and Seconds are between 0 and 59 and Hours can be any value 0 or greater) Computed Column for Seconds: datediff(second,[Start],[Finish]) % 60 Computed Column for Minutes: floor(datediff(second,[Start],[Finish]) / 60.0) % 60 Computed Column for Hours: floor(datediff(second,[Start],[Finish]) / 3600.0) Here's the table for reference Note: I'm also calculating TotalElapsedSeconds, TotalElapsedMinutes, and TotalElapsedHours in other computed columns, but those are easy. I just feel like I might be missing out on a nice built in function in SQL.

  Read the article

• Which user account to assign as owner when attaching an SQL Server database?

  - by FreshCode

  This is a simple database security & performance question, but I've always used either a special user (eg. mydbuser), or Windows' built-in NETWORK SECURITY account as the owner when attaching databases to my SQL Server instances. When deploying my database to a production server, is there a specific user I should stick to or avoid? I would think that using an account with a set password could open the database up to a potential security issue.

  Read the article

• How can I handle emailed job control files for SQL Server?

  - by ganesh

  How can I detect control files from any mailbox, scan that file, decrypt it and queue it as a job using job manager in SQL Server?

  Read the article

• Is the max limit of 4 GB on sql server 2005 express .mdf + .ldf or for .mdf only ?

  - by HotTester

  Is the max limit of 4 GB on sql server 2005 express .mdf + .ldf or for .mdf only ? Kindly clarify. Thanks.

  Read the article

• Updating an entity with linq to sql, do I call attach first?

  - by Blankman

  My code looks like: Entity e = new Entity(); e.name = "..."; e.blah = 234; MyDb.UpdateEntity(e); public static void UpdateEntity(Entity e) { using(MyDatacontext dc = new MyDataContext()) { dc. ????????? } } So what do I do here to update the entity? note: i just called it entity here, its something else in my project.

  Read the article

• In SQL Server, how do I know what transaction mode I'm currently using?

  - by Yousui

  Hi guys, In SQL Server, how do I know what transaction mode I'm currently using? Such as autocommit, explicit, or implicit. And how can I change one mode to another using tsql? Great thanks.

  Read the article

• How to find size of a data type in pl/sql (oracle 9i)?

  - by Vineet

  hi, I want to find the size of any data type in pl/sql,for eg DECLARE x boolean; I want to find size of like X,is there any function like (sizeof() in C) or any how i can find it.Please let me know!

  Read the article

• Where does sql server stores the stored proecdure code?

  - by NoProblemBabe

  I once needed the lines of the stored procedures, to be able to trace whether i have a reference to some function, procedure or table, or sometimes to try to find something inside of the sp's code. Where does the sql server stores the procedures's code?

  Read the article

• Why does SQL Server 2008 suggest I have the primary key column as an included column in an index

  - by Raine

  SQL Server 2008 is telling me to include the Primary Key in an index in the Included Column field. I thought the PK was automagically returned with all indexes?

  Read the article

• What is the correct SQL for a trigger to copy a record to an identical table?

  - by Owen

  I have two tables TABLE1 and TABLE2 with identical structures. I need a trigger to copy a record after insert from TABLE1 to TABLE2. What's the proper SQL for this?

  Read the article

• how to show only even or odd rows in sql server 2008 ?

  - by Gold

  hi i have a table MEN in sql server 2008 that contain 150 rows. how i can show only the even or only the odd rows ? thank's in advance

  Read the article

• In SQL, can we always write an inner join statement as a main query and subquery?

  - by Jian Lin

  In SQL, can we always write an inner join statement as a main query and subquery? For example, select * from gifts g where g.giftID in (select giftID from sentGifts); can do a join and show the gifts sent in the sentGifts table, but it won't be able to show the sentTime because that is inside the subquery?

  Read the article

• How to use Linq To Sql to get Users who has more than 2 photos?

  - by Mike108

  The scenario is I want to get the users who has more than 2 photos. There are two table: [Users] (UserId, UserName) [UserPhotos] (PhotoId, PhotoName, UserId) and UserId is a Foreign Key. A user may have none photo in the [UserPhotos] table. How to use Linq To Sql to get List who has more than 2 photos?

  Read the article

• SQL CE, SQLite. What are the differences between them?

  - by acidzombie24

  What is the difference between SQL CE and SQLite? In what situation would i choose one over the other?

  Read the article

• How do I add a record only if it doesn't already exist in SQL Server?

  - by menacheb

  Hi, I have a project in C# with a Sql-server Database. In that database I have a table named 'Process' and columns named 'process_name', 'Full_Name' and 'Version' (all of the type:nvarchar(50)). I want to write a query wich will add the new process, only if it doesn't exist in the table yet. How can I do that? Many thanks,

  Read the article

• SQL: ... WHERE X IN (SELECT Y FROM ...) ...

  - by Craig Johnston

  Is the following the most efficient in SQL to achieve its result: SELECT * FROM Customers WHERE Customer_ID NOT IN (SELECT Cust_ID FROM SUBSCRIBERS) Could some use of joins be better and achieve the same result?

  Read the article

• SQL SERVER Query result in CSV format is possible?

  - by gopal

  Hi, Is it possible to get the query result in .CSV file format from SQL SERVER 2000 and above versions? If so can we use this feature from an asp.net application to get the result in CSV format? If so how can we do this?

  Read the article

• Does Hibernate log the values that it assigns to placeholders in prepared SQL statements?

  - by Derek Mahar

  Does Hibernate log the values that it assigns to placeholders in prepared SQL statements? How can configure Log4j so that it writes these values to my log files?

  Read the article

< Previous Page | 463 464 465 466 467 468 469 470 471 472 473 474  | Next Page >