Search Results

Search found 31931 results on 1278 pages for 'sql statement'.

Page 431/1278 | < Previous Page | 427 428 429 430 431 432 433 434 435 436 437 438  | Next Page >

• Is it necessary to create ASP.NET 4.0 SQL session state database, distinct from existing ASP.NET 2.0

  - by Chris W. Rea

  Is the ASP.NET 4.0 SQL session state mechanism backward-compatible with the ASP.NET 2.0 schema for session state, or should/must we create a separate and distinct session state database for our ASP.NET 4.0 apps? I'm leaning towards the latter anyway, but the 2.0 database seems to just work, though I'm wondering if there are any substantive differences between the ASPState database schema / procedures between the 2.0 and 4.0 versions of ASP.NET. Thank you.

  Read the article

• How do you extract just date from datetime in T-Sql?

  - by Grand Master T

  I am running a select against a datetime column in SQL Server 2005. I can select only the date from this datetime column?

  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

• 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 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

• Where does sql server stores the stored procedure 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• How can I compare tables in two different databases using SQL?

  - by chama

  I'm trying to compare the schemas of two tables that exist in different databases. So far, I have this query SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('table1') The only thing is that I don't know how to use the sys.columns to reference a database other than the one that the query is connected to. I tried this SELECT * FROM db.sys.columns WHERE object_id = OBJECT_ID('table1') but it didn't find anything. I'm using SQL Server 2005 Any suggestions? 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

• 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

• 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

• 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 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

• 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

• 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

• Why is it necessary to remove and then re-add a user to a SQL Server database after restoring it fro

  - by Craig Johnston

  Why is it necessary to remove and then re-add a user to a SQL Server database after restoring it from a file? If I don't do this, I get a "User login failed" when trying to access the database using this username from apps.

  Read the article

< Previous Page | 427 428 429 430 431 432 433 434 435 436 437 438  | Next Page >