Search Results

Search found 28900 results on 1156 pages for 'sql 2005'.

Page 444/1156 | < Previous Page | 440 441 442 443 444 445 446 447 448 449 450 451  | Next Page >

• How to convert a C# Queue into a binary datatype to be stored as a SQL Blob?

  - by Soham

  Hi All, How do I convert a C# Queue into a binary variable, so that I can store it as a blob in SQL? Help appreciated! Soham

  Read the article

• Will performance of a SQL server degrade if the DB can't fit in the memory?

  - by Carl Hörberg

  Will the performance of a SQL server drastically degrade if the database is bigger than the RAM? Or does only the index have to fit in the memory? I know this is complex, but as a rule of thumb?

  Read the article

• How can I get a JSON object from a SQL Server table?

  - by jlech

  I have a view that I want to be converted into JSON. What is the SQL that I can use to produce on the server the JSON string needed to be returned?

  Read the article

• Setting up a linked server to another server which isn't in a domain without using SQL authenticatio

  - by Telos

  Server A (SQL2005) is in our primary domain, but server B (SQL2000) is just in a windows workgroup. We are not allowed to join it to the domain, or bad things happen... We also can't enable SQL authentication on server B. We've got domain accounts for A, and matching local accounts on server B. I can connect to B from my local PC or A using SSMS and a domain login, but I can't get the linked server to connect. Any ideas how to do this?

  Read the article

• How to SELECT the last 10 rows of an SQL table which has no ID field?

  - by Edward Tanguay

  I have an MySQL table with 25000 rows. This is an imported CSV file so I want to look at the last ten rows to make sure it imported everything. However, since there is no ID column, I can't say: SELECT * FROM big_table ORDER BY id DESC What SQL statement would show me the last 10 rows of this table? The structure of the table is simply this: columns are: A, B, C, D, ..., AA, AB, AC, ... (like Excel) all fields are of type TEXT

  Read the article

• Linq to SQL: How to delete using only the primary key?

  - by Jeremy

  How do I delete a record using Linq to SQL using only the primary key, without having to retrieve the exsting record from the database?

  Read the article

• Can you create a linked server in SQL Server and then refer to it with an alias

  - by Craig HB

  Can you create a linked server in SQL Server 2008 and then refer to it with an alias. So, I create a linked server to "SalesServer", but I give it the alias "Sales", so I can use it like this: SELECT * FROM Sales.DB1.dbo.DailySales

  Read the article

• In SQL, can we always write an inner join statement as a main query and subquery if we only want to

  - by Jian Lin

  In SQL, can we always write an inner join statement as a main query and subquery or vice versa if we only want to find the intersection? 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. But if all we care is to find the intersection, without caring what is being displayed, then we can always convert one to the other?

  Read the article

• How to insert hyperlink into access database via sql?

  - by CSharperWithJava

  I have a fairly simple MS Access Database that contains some metadata about a bunch of documents and a hyperlink field that links to the document on our network drive. However, when I use a SQL INSERT statement to populate the hyperlink field, the value I give it only becomes the display text, not the actual link. How can I make the value a functional hyperlink? I'd think that the hyperlink data type would actually create hyperlinks. I'm using Access 2002 SP3.

  Read the article

• How rigid is the max size of a VARCHAR in SQL Server?

  - by thinknow

  i.e. if I create a VARCHAR(50) field, what happens if I try to assign it a value that's 100 characters long? Will SQL Server let me do this? Is it somehow less efficient?

  Read the article

• How about performance of linq to sql, Entity Framework and NHibernate?

  - by Abonec

  I was learning this ORM because think this is good technology for most projects. But most employers required acquirement of ADO.NET and SQL. This ORM not will use in high-loaded system (like popular web-sites)? In which types of projects this ORM will be useful? Are highly loaded projects using ORM?

  Read the article

• Is it possible to use SQL Server Compact Edition in an Open Source project?

  - by Sergi

  I am aware of other solutions like System.Data.Sqlite or Firebird through Dblinq, but since nothing beats SQL Compact Edition (integration-wise) with Visual Studio, I would like to use it and to know if its license allows its usage in Open Source projects. Thanks.

  Read the article

• Which is faster in SQL, While loop, Recursive Stored proc, or Cursor?

  - by Casey

  Which is faster in SQL, While loop, Recursive Stored proc, or Cursor? I want to optimize the performance in a couple of spots in a stored procedure. The code I'm optimizing formats some strings for output to a file.

  Read the article

• How to find out whether sql server login has any user mapped to using SMO.

  - by Ybbest

  I need to write a function to delete the login in the database if it does not have any users to map to using SQL Server Management Objects (SMO). How can I achieve this ?

  Read the article

• How to automatically generate documentation of stored procedures of SQL Server 2008?

  - by gilbertc

  How to automatically generate documentatation of stored procedures of SQL Server 2008 like doxygen does to codes? I read about hyperSQL but it doesn't work nice with Windows. Thanks! Gil.

  Read the article

• Can someone give me some basic XSS and sql injection scripts? (not what it seems)

  - by ggfan

  I am testing out my scripts to see if they will prevent xss and sql injections. Can someone provide me with some basic but good scripts that would "hack" into my programs. I want to test my scripts before it goes online.

  Read the article

• How do I check if a Linq to SQL entity has grandchildren?

  - by EdenMachine

  How can I find out if a Linq to SQL entity has grandchildren or not? Pseudo-code below: Return From p In dc.Processes Where p.Signers.Count > 0 and p.Signers.Signatures.Count > 0 Obviously I can't run the code above but I need to make sure that all the returning Processes have at least one Signer and that all of those Signers have at least one Signature. TIA!

  Read the article

• Can a sql server aggregate udf be passed in multiple parameters?

  - by Burg

  I am trying to write an aggregate udf for using Sql Server 2008 and C# 3.5 that implodes an aggregation of data. The kind of syntax I am looking for is: SELECT [dbo].[Implode]([Id], ',') FROM [dbo].[Table] GROUP BY [ForeignID] where the second parameter is the delimiter for the aggregate function. And example return value would be something like: 1,4,56 Is there a way to have multiple parameters in an aggregate udf?

  Read the article

• In sql server, is there any way to check whether the schema change will impact on the stored procs?

  - by ziang

  In SQL Server, is there any way to check whether the changes in the schema will impact Stored Procedures (and/or Views)? For example a change of the column name in one table, may break some Stored Procedures; how to check the impacted stored procs?

  Read the article

• How can I connect to SQL Server using (local)\INSTANCE_NAME?

  - by Brandon

  I have a developer that is having trouble connecting to a SQL Server instance by entering the server name (local)\HIS_SERVER_INSTANCE into Visual Studio-Server Explorer. If he replaces (local) with his machine name, it connects fine. I have had similar issues before but they seemed to fix themselves. Does anyone know a fix for this?

  Read the article

• Why does Sql 2008 suggest I have the Primary Key Column as an Included Column in an Index

  - by Raine

  Sql 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

• Good test database on Windows to play around with data retrieval operations in SQL?

  - by ovr

  I need a test database to practice joins and other kinds of data retrieval operations in SQL. What's a good free test database and RDBMS system to use on Windows?

  Read the article

• Linq to SQL: how get row security between write access??

  - by Francisco

  I would like to allow two threads to write in a table at the same time (I know the problem of updating the same row, but this would be a story apart). I need that in behalf of speed up the operations in my aplication (one thread could write in row X while another could do the same in row X+n instead of waiting the first to finalize). So, can I block rows instead of tables with Linq to SQL? Thanks.

  Read the article

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

  - by Mike108

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

  Read the article

• Eclipse Galileo SQL Editor: is there a code formatter (tidy) function?

  - by Jason Tholstrup

  I do like the SQL editor now bundled with Eclipse but I can't seem to find a way for it to format my code like eclipse will with my java. Did I miss something, or does anybody have any alternatives? Thanks ====EDIT==== I'd also be happy if there was an alternate plug-in that someone could recommend.

  Read the article

< Previous Page | 440 441 442 443 444 445 446 447 448 449 450 451  | Next Page >