Search Results

Search found 99646 results on 3986 pages for 'sql server 2005 tempdb'.

Page 191/3986 | < Previous Page | 187 188 189 190 191 192 193 194 195 196 197 198  | Next Page >

• How can I add a binary device driver in Platform Builder for Windows CE 6.0?

  - by Jaime Soriano

  I need to add a device driver to a Windows CE image, I have the driver in .dll and .reg files and in a .cab package. I'm using Visual Studio 2005 with Platform Builder for Windows CE 6.0. How can I do that?

  Read the article

• null from C# getting converted into 'NULL' in Sql Server

  - by Anand

  I am trying to insert NULL value in Sql Server if I have null value in corresponding C# String object like below : String Residence = xmlDoc.Descendants("Appointment").Single().Element("StateOfResidence") == null ? null : xmlDoc.Descendants("Appointment").Elements("StateOfResidence").Single().Value; I am using Entity framework for Database access. So if Residence is null, 'NULL' gets inserted into Database instead of NULL. How can insert NULL for null ?

  Read the article

• visual studio recognizing .asp properly or suggestion for classic asp editor/iDE

  - by Neil Warner

  How do I get visual studio 2005 to work best with .asp files? I used to have this on my old PC but I can't get the settings right. I exported and important all my old settings and still no dice. alternatively I think there might be an even better choice for classic asp IDE editor. It'd be nice to have intellisense, completion, highlighting, stuff like that for ASP (vbscript) and css/html at the same time. (I'm happy not to type out css selectors) thanks

  Read the article

• SQL injection question

  - by Luke

  I have heard of sql injection, what is it and how do i stop it? Also is there anything else i should look out for ? Thanks

  Read the article

• How to quote and reference MS SQL table and field names

  - by artvolk

  Good day! Despite the fact LINQ2SQL and ADO.NET Entity Framework exists there were situations when I need to revert to plain old DataSet (not typed) and friends. While writing SQL for SqlCommand: Is it needed to quote field and table names with []? Is it good to prefix table names with [dbo] I use to use this syntax: SqlCommand command = new SqlCommand("SELECT [Field1], [Field2] FROM [dbo].[TableName]", connection); May be there is a better way? Thanks in advance!

  Read the article

• Rollback SQL Server 2012 Sequence

  - by VAAA

  I have a SQL Server 2012 Sequence object: /****** Create Sequence Object ******/ CREATE SEQUENCE TestSeq START WITH 1 INCREMENT BY 1; I have a SP that runs some queries inside a transaction: BEGIN TRAN SELECT NEXT VALUE FOR dbo.TestSeq <here all the query update code......> ROLLBACK TRAN If the transaction fails all the updates are rolledback without problem but the Sequence is not rolled back I guess because Its out of the scope of the transaction. Any clue on way to handle that? Thanks

  Read the article

• Translate SQL query to LINQ

  - by ile

  PhotoAlbums table AlbumID Title Date Photos table: PhotoID Title Date AlbumID SELECT AlbumID, Title, Date, (SELECT TOP (1) PhotoID FROM Photos AS c WHERE (AlbumID = a.AlbumID)) AS PhotoID FROM PhotoAlbums AS a I need this query written in LINQ-to-SQL. Thanks in advance

  Read the article

• Prevent SQL Server Table operations (INSERT and DELETE) on some tables

  - by stckvrflw

  While working with some random sql queries on our databases, we may not want to insert or delete items to some of the database tables by just typing their names by mistake. So how to make them locked to the "editing", to be able to work safe. Thanks.

  Read the article

• Do non-clustered indexes slow down inserts?

  - by mikeinmadison

  I'm working in Sql Server 2005. I have an event log table that tracks user actions, and I want to make sure that inserts into the table are as fast as possible. Currently the table doesn't have any indexes. Does adding a single non-clustered index slow down inserts at all? Or is it only clustered indexes that slow down inserts? Or should I just add a clustered index and not worry about it?

  Read the article

• SQL Server differential backup to SQL statements

  - by noonex

  Is there any way to convert differential backup to SQL statements which will produce identical results when applied? Or any other solution similar to binary log in MySQL?

  Read the article

• Is defragging tough on replication?

  - by Jim

  I've been told that defragging causes the log to grow tremendously. Is this true? If so, is there something better to do than defragging that will not impact the log as much? We are running SQL Server 2005 replicating between 2 sites.

  Read the article

• how to forward engineer database diagram from visio 2003 file ?

  - by dotnetcoder

  I came across some vb macros that export it to a mdb ( ms access ) file. But does not work very well when copying forward constraints , etc. I want generate schema from the database diagram for sql server 2005 database.

  Read the article

• Visual studio settings css

  - by skamale

  My css file does not show any color high lights for the css what are the studio setting to enable it.Also my css intellisence won't work. I am using visual studio 2005. kindly help

  Read the article

• How can I translate this SQL statement to a Linq-to-SQL approach?

  - by Sergio Tapia

  For example, imagine that I want to see if a user exists in my database: Select * from Users where inputID = Users.ID Then if that result brought 0 items, then the user exists, correct? How can I do something like this using a pure Linq-to-SQL class?

  Read the article

• SQL hidden techniques?

  - by AlexRednic

  What are those pro/subtle techniques that SQL provides and not many know about which also cut code and improve performance? eg: I have just learned how to use CASE statements inside aggregate functions and it totally changed my approach on things. Are there others?

  Read the article

• SQl Server - Hierarchical Data

  - by JMSA

  I use SQL Server 2000. Suppose I have two tables like the following: Area ---------------------------------- ID| Name | HierarchyLevel ---------------------------------- 1 | World | 1 2 | America| 2 3 | Europe | 2 4 | Africa | 2 5 | USA | 3 and AreaHierarchy ------------------------ ID | ParentID | ChildID ------------------------ 1 | 1 | 2 2 | 1 | 3 3 | 1 | 4 4 | 2 | 5 where AreaHierarchy.ParentID and AreaHierarchy.ChildID are FKs of Area.ID How can I find the nth parent of USA? Is it possible without looping? Probably not.

  Read the article

• SQL optimization: deletes taking a long time

  - by Will

  I have an Oracle SQL query as part of a stored proc: DELETE FROM item i WHERE NOT EXISTS (SELECT 1 FROM item_queue q WHERE q.n=i.n) AND NOT EXISTS (SELECT 1 FROM tool_queue t WHERE t.n=i.n); A bit about the tables: item contains about 10k rows with an index on the n column item_queue contains about 1mil rows also with index on n column tool_queue contains about 5mil rows indexed as well I am wondering if the query/subqueries can be optimized somehow to make them run faster, I thought that deletes were generally fairly fast

  Read the article

• How to find column names for all tables in all databases in SQL Server

  - by Salman A

  I want to find all column names in all tables in all databases. Is there a query that can do that for me? The database is Microsoft SQL Server 2000.

  Read the article

• Launching an SSRS report from asp.net web application

  - by user279521

  Hi, I have an asp.net web app and I need to launch a pdf report that is developed in SSRS using SQL 2005. The SSRS report query has been created. How can I go about launching the report?

  Read the article

• SQL Update with row_number()

  - by user609511

  i m using SQL Server 2008 R2. i want to update my column CODE_DEST with increment number CODE_DEST RS_NOM null qsdf null sdfqsdfqsdf null qsdfqsdf what i want: CODE_DEST RS_NOM 1 qsdf 2 sdfqsdfqsdf 3 qsdfqsdf i have try this: update DESTINATAIRE_TEMP set CODE_DEST = TheId FROM (SELECT Row_Number() OVER (ORDER BY [RS_NOM]) as TheId from DESTINATAIRE_TEMP) not work because of ) and this With DESTINATAIRE_TEMP As ( SELECT ROW_NUMBER() OVER (ORDER BY [RS_NOM] DESC) AS RN FROM DESTINATAIRE_TEMP ) UPDATE DESTINATAIRE_TEMP SET CODE_DEST=RN because of union

  Read the article

• SQL IN Statement using like syntax?

  - by StackUnderflow

  I would like to do something like this i.e., use wild card characters in the in clause: SELECT * FROM mytable WHERE keywords IN ('%test%', '%testing%') This is not supported in MS SQL.... Is there some other way to achieve it... Looking for something other than: SELECT * FROM mytable WHERE keywords like '%test%' or keywords like '%testing%' or.....

  Read the article

• SQL Alias as Table.column

  - by bakerjr

  hi, is it possible to alias an aggregate function in a select clause as AliasTable.AliasColumn? The reason is because I want minimum modifications in my arrays (I'm using PHP). Thanks! P.S. I'm using SQl Server 2008

  Read the article

• SQL to search duplicates

  - by Ram

  I have a table for animals like Lion Tiger Elephant Jaguar List item Cheetah Puma Rhino I want to insert new animals in this table and I am t reading the animal names from a CSV file. Suppose I got following names in the file Lion,Tiger,Jaguar as these animals are already in "Animals" table, What should be a single SQL query that will determine if the animals are already exist in the table.

  Read the article

• Native XML WebService With Authentication Basic and SSL

  - by tom

  I'm using 2005 and the Native XML WebServices. The integrated authentication via HTTP:80 works fine. But i need the basic authentication which requires SSL. So if i change the web service to ssl i always get a connection reset (101). I tried several ports 80,443,9999 with the same outcome. What is the error?

  Read the article

• How to tell visual studio that i have installed visual C# too?

  - by Rajesh Kumar

  I got visual studio 2005 express edition installed on my machine.But it did not contain any C# or web developer with it. So i later installed visual C# too. Now , I can create a C# project through visual C#. But I cant use visual studio for the same purpose. I guess there would be some mechanism to integrate visual C# with visual studio. Can anyone help me out?

  Read the article

< Previous Page | 187 188 189 190 191 192 193 194 195 196 197 198  | Next Page >