Search Results

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

Page 555/1278 | < Previous Page | 551 552 553 554 555 556 557 558 559 560 561 562  | Next Page >

• how to add existing ms sql database to app_data folder of asp.net MVC project

  - by balalakshmi

  I have an existing database in ms sql server. I am trying to create an asp.net mvc project around this db for this purpose I need to add the db to app_data folder of asp.net MVC project How do I achieve this

  Read the article

• Test sql connection without throwing exception

  - by Alexandre Pepin

  To test if i can connect to my database, I execute the following code : using (SqlConnection connection = new SqlConnection(myConnectionString)) { try { connection.Open(); canConnect = true; } catch (SqlException) { } } This works except it throws an exception if the connection failed. Is there any other way to test a Sql connection that doesn't throw an exception ? Edit : To add precision, i'm asking if there is a simple method that does that without having to open the connection and catch exceptions that can occur

  Read the article

• How can I see a login's default database?

  - by Vitali Climenco

  Hi Stakoverflow, I need to detect a login's default database. Which system table/view should I query for that in SQL Server 2005?

  Read the article

• what is the fast way for find data in sqlCE - windows mobile & C#

  - by Gold

  hi what is the fast way to find and data in sqlCE in windows-mobile (C#) ? i have database with 1000000 records. sql query ? .... or data reader ?.....or wat ?? thank's in advance

  Read the article

• DDD: Can I have my persistence layer object implement an interface that uses enum, with implicit con

  - by Maslow

  I have a domain interface public interface ITicket { ... TicketWorkflowStatus StatusId{get;set;} // Enum } but the linq-to-sql persistance layer on the database wants to use int, can I change it in the dbml so that the local type is TicketWorkflowStatus? What are my options?

  Read the article

• alternatives to SSIS

  - by Johannes Rudolph

  What is a good,stable and preferably free alternative to SQL Server Integration Services? I'm so tired of this buggy piece of software.

  Read the article

• Stored procedure modified time

  - by Ashley

  Is there a way to find out when a stored procedure or table was last modified? I tried checking the properties via SQL Management Studio, but only found the creation date. Thanks!

  Read the article

• Do make indexes containing another index make sense?

  - by Orlando Dilasso

  Given a table (id, col1, col2), does it make sense to create the following indexes: Index1 (col1) not unique Index2 (col1, col2) not unique I am faced with a legacy database that is full of those. Can I safely delete Index1? Anwser needed for SQL Server and Oracle.

  Read the article

• KPI definition asking for advice

  - by George2

  Hello everyone, I am looking for some reference/samples about how to define good KPI for education industry. I want to define KPI from school/department management perspective to measure various school performance, students/faculty/others. Any advice, referneces or documents are appreciated -- more appreciated if with the context of SQL Server 2005/2008. thanks in advance, George

  Read the article

• query " ALTER TABLE test_posts ADD sticky boolean NOT NULL default = false" = error

  - by William

  Whats wrong with my query? ALTER TABLE test_posts ADD sticky boolean NOT NULL default = false #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=false' at line 2

  Read the article

• Getting 'The argument 1 of the xml data type method "modify" must be a string literal' while inserti

  - by sam

  Trying the following code. But getting 'The argument 1 of the xml data type method "modify" must be a string literal' error. searched alot but cant find any solution for this problem SET @Path = '/@ParentNodeName/@NodeName/child::*' SET @x.modify('insert attribute status {sql:variable("@status")} as first into (' + @Path + ')[1]')

  Read the article

• Timestamp column - Can it be queried?

  - by Randy Minder

  Can a Timestamp (rowversion) column in a SQL Server table be queried? If so, how? I'd like to do something like this: Select * From MyTable Where MyTimestampColumn = "???" But am not sure what to put in for "???" Thanks - Randy

  Read the article

• SQL Server Full Text Search Special character issue

  - by ManojTrek

  Hello, I have Full Text catalog created in SQL Server 2005, when I search the text like "Bolivia's History", it returns all the result matching to that, but if I use "Bolivias History", it does not return anything, I am very new to Full Text Search stuff, any lead how to ignore the special character ("'"), in Full Text Search? Thanks in Advance, Manoj

  Read the article

• how to use an mdf in App_Data with shared hosting

  - by name

  If I create a website that uses an mdf in App_Data with the connection string: Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname; Trusted_Connection=Yes; what do I need to do to run the site in a shared hosting environment? Do I need to copy the contents of my mdf to the main SQL Server engine of my host? Is there a way to use the non-SQLExpress engine of my host and still keep my mdf in my App_Data?

  Read the article

• Oracle Sql Developer vendor code 1317

  - by Zemian

  Hi, I am using Oracle Sql Developer to browse a MySQL database. When I browse table with Columns tab(shows table definitions), some of tables will display an Error Encountered dialog that says: Vendor code 1317. Does anyone know how I can resolve this? Thanks, /Z

  Read the article

• What are the uses for Cross Join?

  - by vanslly

  A cross join performs a cartesian product on the tuples of the two sets. SELECT * FROM Table1 CROSS JOIN Table2 Which circumstances render such an SQL operation particularly useful?

  Read the article

• Asp.net web site and web service hosting

  - by Razvi

  I have a web site and a web service and I would like to host them somewhere. I need to use it mostly for testing and so that a some friends who are developing some applications to use the service have access to it. Also the service is using a MS SQL 2008 database. Could you suggest any good free or cheap web hosting service for this. I would need about 1-2 months of hosting.

  Read the article

• SqlServer Split operation

  - by Geetha

  Hi All, How to split a string in sql server. Ex: Input String: stack over flow Result: stack over flow Geetha.

  Read the article

• how to open *.sdf files ?

  - by Gold

  i used to open sdf (sqlCE) files with visual-studio ?? or sql-server ?? i really don't remember. now i can't open this sdf file with what program do i need to open it ?

  Read the article

• Open Source/ Free alternatives to Redgate Test Data Generator

  - by Perpetualcoder

  I was wondering if there are any free / open source alternatives to RedGate's Data Generator. I do not care if the tool is script based, GUI based, written in anly language/platform. I should be able to target a SQL Server or MySQL schema and have test data generated for me which gets inserted into db directly or generate scripts for insertion.

  Read the article

• Which one can have better performance - LINQ to EF or NHibernate?

  - by masoud ramezani

  I want to start working on a big project. I research about performance issues about LINQ to EF and NHibernate. I want to use one of them as ORM in my project. now my question is that which one of these two ORM can get me better performance in my project? I will use SQL Server 2008 as database and C# as programming language.

  Read the article

• What should I be afraid of when I make a site public?

  - by ggfan

  If I was going to put my site for the public's use, what are some security issues that I should be worried about? I know of SQL injections. What other hacks/injections should I be aware of?

  Read the article

• Why would SET ARITHABORT ON dramatically speed up a query?

  - by Jonathan Allen

  The query is a single select containing a lot of grouping levels and aggragate operations. With SET ARITHABORT ON is takes less than a second, otherwise it takes several minutes. We have seen this behavior on SQL Server 2000 and 2008.

  Read the article

• How to create a database and populate it during setup

  - by Philippe

  I would like to find a way to create and populate a database during asp.net setup. So, what I'm willing to do is: Create the database during the setup Populate the database with some initial data (country codes or something like that) Create the appropriate connection string in the configuration file I'm using .NET 3.5 and Visual Studio 2005, and the Database is SQL Server 2005. Thanks in advance.

  Read the article

• Sql query executing perfectly in phpmyadmin but giving warning while running on page

  - by saurav

  i don't know whats wrong with this sql query. SELECT * FROM main WHERE key LIKE '%$word%' its giving results in phpMyAdmin but giving warning while executing it in a php page. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

  Read the article

< Previous Page | 551 552 553 554 555 556 557 558 559 560 561 562  | Next Page >