Search Results

Search found 79317 results on 3173 pages for 'sql error messages'.

Page 305/3173 | < Previous Page | 301 302 303 304 305 306 307 308 309 310 311 312  | Next Page >

• Concatenating Date Values - SQL Injection

  - by Kyle Rozendo

  Hi All, We currently receive parameters of values as VARCHAR's, and then build a date from them. I am wanting to confirm that the method would stop the possibility of SQL injection from this statement: select CONVERT(datetime, '2010' + '-' + '02' + '-' + '21' + ' ' + '15:11:38.990') Another note is that the actual parameters being passed…

  Read the article

• Linq to SQL - Invalid attempt to call FieldCount when reader is closed

  - by Justin

  Hey, Has anyone seen this error before when making a Linq to SQL call? Invalid attempt to call FieldCount when reader is closed Here's the code: public static MM GetDeviceConfiguration(long ipAddress) { string sprocName = ConfigurationBL.ReadSproc("ReadDeviceConfiguration"); return…

  Read the article

• TransactionScope() in Sql Azure

  - by Rick Make

  Does Sql Azure support using TransactionScope() when performing inserts? Below is a code snippet of what I am trying to do. using (var tx = new TransactionScope(TransactionScopeOption.RequiresNew, new TransactionOptions() { IsolationLevel = IsolationLevel.ReadCommitted })) { using (var db =…

  Read the article

• Extract words from sentence(s) using TSQL(SQL SERVER 2005) [ SET BASED SOLUTION]

  - by Newbie

  I have the following input. INPUT: TableA ID Sentences --- ---------- 1 I am a student 2 Have a nice time guys! What I need to do is to extract the words from the sentence(s) and insert each individual word in another table OUTPUT: SentenceID WordOccurance Word…

  Read the article

• Windows Scheduler OR SQL Server Job for sending out digest e-mails

  - by wgpubs

  Will be sending out e-mails from an application on a scheduled basis. I have an EmailController in my ASP.NET MVC application with action methods, one for each kind of notification/e-mail, that will need to be called at different times during the week. Question: Is Windows Scheduler (running on a Server…

  Read the article

• Saving FlowDocument to SQL Server

  - by David Veeneman

  I need to save WPF FlowDocuments to SQL Server. What is the best format for doing that? String? Blob? Does it matter in a document less than 5K words or so?

  Read the article

• T/SQL Efficiency and Order of Execution

  - by Kyle Rozendo

  Hi All, In regards to the order of execution of statements in SQL, is there any difference between the following performance wise? SELECT * FROM Persons WHERE UserType = 'Manager' AND LastName IN ('Hansen','Pettersen') And: SELECT * FROM Persons WHERE LastName IN ('Hansen','Pettersen') AND UserType =…

  Read the article

• SQL Like keyword in Dynamic Linq

  - by Erwin

  Hi fellow programmer I want to use SQL's Like keyword in dynamic LINQ. The query that I want to make is like this select * from table_a where column_a like '%search%' Where the column_a can be dynamically changed to other column etc In this dynamic LINQ var result = db.table_a.Where( a=>…

  Read the article

• free sql code editor?

  - by every_answer_gets_a_point

  i am breaking my eyes trying to write sql code in ms access. is there a free editor out there?

  Read the article

• SQL Database Mirroring and your web application

  - by Khou

  You have two servers when you perform a SQL Server database mirroring You have 1 primary database and 1 mirror database Do you need to make any changes to web application to tell it that your using database mirroring? If not how does your web application know which database to use when the…

  Read the article

• Does facebook fql contain the sql like operator?

  - by vondip

  Hi all, I am building a small facebook app. Trying to search for values in an auto compelte manner. Is it possible to use sql's like operator in fql?

  Read the article

• Undo Database Restore in SQL Server 2008

  - by Vivek Chandraprakash

  I accidentally restored a SQL Server 2008 database with a wrong backup. Is there any way to undo this and restore to previous version?

  Read the article

• Creating a secure SQL Server 2008 database environment

  - by user279521

  I am in the process of setting up a corporate SQL Server 2008 database. The data on this machine will be related to financial services. There will be low level traffic (not like your average investment broker's website). However, a secure data environment is very crucial. What would I need…

  Read the article

• How do I drop SQL Databases? sp_delete_database_backuphistory woes

  - by rlb.usa

  I want to delete some SQL Databases on my server, but I'm having problems. My login has the roles: public dbcreator serveradmin When I right click the database and hit Delete, it says that Delete backup history failed for server 'MYSERVER' (Microsoft.SqlServer.Smo) Additional …

  Read the article

• How to update Sharepoint list using SSIS?

  - by Sushant

  Hi, I am using SSIS to transfer data from MS SQl server as data source and Sharepoint list as data destination. Now, I need to fire an update command on the sharepoint list. Please guide me to implement this.

  Read the article

• linked server issue in SQL Server

  - by George2

  Hello everyone, I am using SQL Server 2008 with linked server feature. I noticed there are a lot of providers for linked server which could be found from SSMS, like SQLNCLI10, OLE DB, etc. How to know which provider a specific linked server instance is using? thanks in advance, George

  Read the article

• specify content type of an attachment in sql server sp_send_dbmail

  - by SecretWiz

  How can I specify the content type of an attachment when sending emails using sp_send_dbmail? The content type is specified as application/octet-stream for Zip, PDF files. But I need to change it to application/zip, application/pdf. The "file_attachments" parameter takes absolute paths of…

  Read the article

• Undo Database Restore in Sql 2008

  - by Vivek Chandraprakash

  I accidentally restored a sql 2008 db with a wrong backup. Is there any way to undo this and restore to previous version? Pls help. -Vivek

  Read the article

• Script output to file when using SQL-Developer

  - by Laurent K

  I have a select query producing a big output and I want to execute it in sqldeveloper, and get all the results into a file. Sql-developer does not allow a result bigger than 5000 lines, and I have 100 000 lines to fetch... I know i could use SQL+, but let's assume I want to do this in…

  Read the article

• Hangs with LINQ-SQL Server and TransactionScope

  - by Zian Choy

  I'm encountering a hang when the program tries to access the fruit database. I've already enabled network access MSDTC on both my development computer and the SQL Server server. Code: (pardon the code coloring...SO's misinterpreting my VB .NET) Using ts As New TransactionScope …

  Read the article

• Using ASP.NET MVC, Linq To SQL, and StructureMap causing DataContext to cache data

  - by Dragn1821

  I'll start by telling my project setup: ASP.NET MVC 1.0 StructureMap 2.6.1 VB I've created a bootstrapper class shown here: Imports StructureMap Imports DCS.Data Imports DCS.Services Public Class BootStrapper Public Shared Sub ConfigureStructureMap() …

  Read the article

• Visual Studion 2008 App_Data defaults

  - by Dennis Keith

  Is it possible to use the App_Data folder in conjunction with SQL Server 2005? When I try it specifies Express even though I have changed the ToolsOptionsDatabaseData Connections to the correct server. I have downloaded SQLEXPR32_x86_ENU.exe Version 10.0.1600.22 file…

  Read the article

• LINQ to SQL select distinct from multiple colums

  - by Morron

  Hi, I'm using LINQ to SQL to select some columns from one table. I want to get rid of the duplicate result also. Dim customer = (From cus In db.Customers Select cus.CustomerId, cus.CustomerName).Distinct Result: 1 David 2 James 1 David 3 Smith 2 James 5…

  Read the article

• How to find ALL descendants using HierarchyID for SQL Server

  - by Luke101

  I need to find all descendants of a category using HierarchyID for SQL Server. I know how to find direct childs but I would like to find childs of childs of child..etc. Is there a way to do this using the hierarchyID.

  Read the article

• Ad hoc queries vs stored procedures vs Dynamic SQL

  - by Kristaps

  Ad hock queries vs stored procedures vs Dynamic SQL. Can anyone say pros and cons? Best regards, Kristaps

  Read the article

< Previous Page | 301 302 303 304 305 306 307 308 309 310 311 312  | Next Page >