Search Results

Search found 38138 results on 1526 pages for 'non sql'.

Page 210/1526 | < Previous Page | 206 207 208 209 210 211 212 213 214 215 216 217  | Next Page >

• Using ROWLOCK in an INSERT statement (MS SQL)

  - by RPS

  Would it be wise to use ROWLOCK on an insert statement that is copying large amounts of data and inserting it into the same table? Ex) INSERT INTO TABLE with (rowlock) (id, name) select newid, name) from TABLE with (nolock) where id = 1 Does anybody have recommendations on how to improve this statement, as I see when MS SQL gets busy it will…

  Read the article

• Map a GoogleDocs Spreadsheet to a SQL table

  - by justSteve

  I'm looking for a generalized plan of attack at this problem: Upon saving a spreadsheet in my Google Docs account a SQL 08 table is updated. Or perhaps via spreadsheet's new 'Form' input method. But the overarching goal is letting google docs function as a front-end editor to sql. thx --steve...

  Read the article

• T-SQL selecting values that match ISNUMERIC and also are within a specified range. (plus Linq-to-sql

  - by Toby

  I am trying to select rows from a table where one of the (NVARCHAR) columns is within a numeric range. SELECT ID, Value FROM Data WHERE ISNUMERIC(Value) = 1 AND CONVERT(FLOAT, Value) < 66.6 Unfortunately as part of the SQL spec the AND clauses don't have to short circuit (and don't on MSSQL Server EE 2008). More info:…

  Read the article

• SqlMetal.exe generate linq to sql classes only for some tables

  - by loviji

  Hello, I have 2 question about sqlmetal.exe I generate Linq to Sql classes from command promt for all tables, except some tables? can I add to model some tables I want that, in some cases linq to sql classes not generated fully. thanks.

  Read the article

• OneToMany relationship appearing as OneToOne in Linq to SQL diagram

  - by Robert Morgan

  I have a OneToMany relationship in an SQL Server database. When I add the tables to my Linq to SQL diagram (DBML) the relationship comes up as OneToOne. I have other OneToMany relationships which synchronise correctly. Even If I change the cardinality to OneToMany the collection still only returns a single entity. Could…

  Read the article

• Does SQL Azure Support Relational Databases?

  - by Goober

  I keep reading that SQL Azure doesn't support relational databases; however, I just tapped into my SQL Azure Database and scripted a relational database. I even checked to see what was present using: select * from sys.objects Any thoughts?

  Read the article

• How to add a default value to an already existing column?

  - by Earlz

  I have an existing column in my SQL Server database. I have tried about everything I can think of but can not get a default value to be added to the column. What works in every other database is alter table mytable alter column mycolumn set default(now()) --mycolumn is a datetime How do I do this in SQL Server? The…

  Read the article

• How programically check if SQL Server CE is installer (System.data.sqlserverce exist)

  - by Simon

  How can I programmatically check whether SQL Server CE is installed (System.data.sqlserverce exist) in C# .Net 3.5. Can I get the version on SQL Server CE?

  Read the article

• SQL Server Reports IDE for creating reports

  - by Anton

  I have to modify SQL Server reports. It is not easy to modify directly XML report file (*.rdl). Is there any IDE for editing SQL Server Reports?

  Read the article

• Using SQL Server Analysis Services with Sybase Advantage Database Server

  - by ngm

  Is it possible to use SQL Server 2008 Analysis Services with data stored in Sybase Advantage Database Server? Either directly, or via SQL Server Integration Services.

  Read the article

• SQL Server 2008 Fulltext problem

  - by Geetha

  Hi All, After Creating Full Text Catalog and Full Text index i have tried the following query SELECT gamename FROM sample WHERE CONTAINS(name,'"f1"') Error: Msg 30046, Level 16, State 1, Line 1 SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make…

  Read the article

• something about sql-dump

  - by Yang

  hi, guys, i know that sql dump is a series of insert sql statement which reflects all the records inside the database. but may i know what is it used for? why should we dump the database records? is every database supports dumping function? Any additional background information is welcomed! Thanks in advance!

  Read the article

• SQL: convert tokens in a string or elements of an array into rows of a table

  - by slowpoison

  Is there a simple way in SQL to convert a string or an array to rows of a table? For example, let's stay the string is 'a,b,c,d,e,f,g'. I'd prefer an SQL statement that takes that string, splits it at commas and inserts the resulting strings into a table. In PostgreSQL I can use regexp_split_to_array() and split the…

  Read the article

• Using sql column names in hibernate createSQlquery result

  - by Ricardo

  Hi all, i have a couple of sql views with composite primary keys that i want to query, and since Hibernate makes it a pain to work with composite keyes, im using createSQLQuery. The problem is that this method can only return a List, and i need to refer to the colums by their index. Any chance i could do like jdbc…

  Read the article

• Synchronizing Sql Server Database with Pi System Database

  - by Vinod Reddy M.K

  Hai, I'm developing a tool to synchronize SQL Server database with a Pi system (OleDb).Each time there is a change in the Pi System I need to update the values in Sql Server Database and vice-versa.Could you please provide me with the options possible and how it can be done. Thanks, M.K

  Read the article

• Boolean logic parser for SQL

  - by d03boy

  This is going to sound crazy but does anyone have techniques that would allow me to parse boolean logic strings in Sql Server 2005 without extraordinary/rediculous effort? Here is an example: (SOMEVAR=4 OR SOMEVAR=5) AND (NOT OTHERVAR=Y) I feel like recursion would help a lot if that were possible in Sql but I'm…

  Read the article

• What are the most common SQL anti-patterns?

  - by le dorfier

  All of us who work with relational databases have learned (or are learning) that SQL is different. Eliciting the desired results, and doing so efficiently, involves a tedious process partly characterized by learning unfamiliar paradigms, and finding out that some of our most familiar programming patterns don't…

  Read the article

• Pass tenant id via sql server connection

  - by Alexey Zakharov

  Hi guys, I'm building multi tenant application with shared table structure using Microsoft SQL Server. I wonder if it possible to pass tenantID parameter via sql server connection. I don't want to create separate user account for each tenant. Currently I see two ways: via ApplicationName or WorkstationID …

  Read the article

• Decent simple SQL Server client

  - by John

  Hi, does anyone know of a very simple SQL Server client tool - that does the same basic functions as Management Studio (i.e. choose a database and run a query - doesn't need an Object Explorer, or anything fancy)? Ideally it would be great to have a single exe or zip file version that I could take around on…

  Read the article

• Final form of parametric SQL commands in ADO.NET

  - by mcoolbeth

  I am getting a syntax error when I send a parameterized query to Access from my C# program via ADO.NET. I, of course, know what SQL string I have included in my code, with the parameter names embedded inside. Does anyone know how I can look at the SQL string that is finally sent to the DBMS during after I…

  Read the article

• Sleep Command in T-SQL?

  - by skb

  Is there to way write a T-SQL command to just make it sleep for a period of time? I am writing a web service asynchronously and I want to be able to run some tests to see if the asynchronous pattern is really going to make it more scalable. In order to "mock" an external service that is slow, I want to be…

  Read the article

• SQL code editor with syntax highlighing, auto-formatting and code folding

  - by Victor Stanciu

  Hello, Is there any SQL editor that supports syntax highlighting, automatic code formatting and code folding? I found this, but it's an Eclipse plugin (I'm a NetBeans user), and cannot automatically format code, which is the most important feature I'm after. Autocompletion is not important, nor is the…

  Read the article

• In SQL SERVER 2008 ,is it possible to disable auto drop of global temp table

  - by nayeem

  Hi question1 : I am using global temp tables in sql server 2008 but once my connection is closed this temp is dropped is there any way to diable auto drop Question2 : If two connections are accesstion same global temp table and another connection is trying to delete that global temp table,does…

  Read the article

• sql server 2008 installation failure

  - by user342319

  Hi, I'm trying to install sql server 2008 express but it fails I'm using web platform installer. I recieve the following error: Install exit code for product 'SQL Server Express 2008 with Service Pack 1' is -2067529723 why ? what to do ?

  Read the article

• Setting SQL database Permissions for Visual Studio Data Config Wizard

  - by Raven Dreamer

  Hello, Stackoverflow! I'm new to SQL. I have created a new database in SQL Server Management Studio, and am now trying to attach it to a windows forms project in Visual Studio via the built in Data Configuration Wizard. Currently, whenever I try to attach the database file, I get a permissions…

  Read the article

< Previous Page | 206 207 208 209 210 211 212 213 214 215 216 217  | Next Page >