Search Results

Search found 27530 results on 1102 pages for 'sql truncate'.

Page 407/1102 | < Previous Page | 403 404 405 406 407 408 409 410 411 412 413 414  | Next Page >

• Which is better practice: complex SQL statements or Recordset manipulation in Access VBA?

  - by mazi

  I'm doing some VBA development and I found creating SQLs quite efficient way of getting everything done (selecting and updating). But I got to this stage where my SQL statements contain complex Switches and WHERE conditions where I have another Selects to update appropriate records. Therefore, I create this SQLs and I simply run it via "CurrentDb.Execute strSQL" and it does everything fine. The question is, why would I declare ADODB.connections etc, set recordsets, loop through it and manipulate the data one by one?

  Read the article

• ASP.NET - Storing SQL Queries in Global Resource File?

  - by Arthur Chaparyan

  Is it a good idea to store my SQL queries in a global resource file instead of having it in my codebehind? I know stored procedures would be a better solution but I don't have that luxury on this project. I don't want queries all over my pages and thought a central repository would be a better idea.

  Read the article

• Is it poor practice to build an SQL query using WHERE 1=1 AND ...

  - by Rob

  I'm writing a script that builds an SQL query by concatenating the string and adding conditions to the WHERE clause as needed. Would it be better practice to use WHERE 1=1 so that the first condition is satisfied and the script can just concatenate an AND x = 'y' to the query, or should I write the extra code to check if a clause has been added and if not, add the AND ? Confusing question, I know. Let me know if I need to be more clear. Rob

  Read the article

• Are products like SQL Server and Oracle are "ORDBMS"?

  - by n10i

  According to wikipedia! http://en.wikipedia.org/wiki/ORDBMS IBM's DB2, Oracle database, and Microsoft SQL Server, make claims to support this technology and do so with varying degrees of success So, are these products true "ORDBMS" like PostgreSQL? or they are they are long way from it? can someone plz! point me to any link where i can read about the features still to be implemented by these RDBMS to become true ORDBMS!

  Read the article

• How can I trim certain characters from a string in sql?

  - by Matt

  I would like to trim all special characters from a string in SQL. I've seen a bunch of people who use substring methods to remove a certain amount of characters, but in this case the length on each side of the string is unknown. Anyone know how to do this? Thanks, Matt

  Read the article

• CF9's Apache Lucene vs SQL Server's full text search?

  - by Henry

  ColdFusion 9's full text search is now based on Apache Lucene. We also use SQL Server. Which one's better? Which one's easier? Thanks!

  Read the article

• How can I write a SQL count with group by clause using Propel ORM in Symfony?

  - by Failpunk

  How can I write the following SQL query using the Propel ORM? SELECT species, COUNT(*) FROM Bird GROUP BY species;

  Read the article

• Can I use @table variable in SQL Server Report Builder?

  - by edosoft

  Using MS SQL 2008 Reporting services: I'm trying to write a report that displays some correlated data so I thought to use a @table variable like so DECLARE @Results TABLE (Number int, Name nvarchar(250), Total1 money, Total2 money) insert into @Results(Number, Name, Total1) select number, name, sum(total) from table1 group by number, name update @Results set total2 = total from (select number, sum(total) from table2) s where s.number = number select from @results However, Report Builder keeps asking to enter a value for the variable @Results. It this at all possible?

  Read the article

• How to move data from VistaDB to MS SQL Server?

  - by Samnang

  Currently, I have a blog that is using VistaDB as back-end database, but later I realize that I want to MS SQL Server instead. I was wondering there is any tools that are available for migration data like this problem?

  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 automate the "generate scripts" task in SQL Server Management Studio 2008 ?

  - by Brann

  I'd like to automate the script generation in SQL Server Management Studio 2008. Right now what I do is : Right click on my database, Tasks, "Generate Scripts..." manually select all the export options I need, and hit select all on the "select object" tab Select the export folder Eventually hit the "Finish" button Is there a way to automate this task? Edit : I want to generate creation scripts, not change scripts.

  Read the article

• Will Indexing Binary Columns Improve Performance for SQL WHERE BETWEEN statements?

  - by thenonhacker

  I have a table that has a binary column that represents IP Address data. One of the queries perform a BETWEEN comparison on that binary column. If I index that column, will performance improve for the BETWEEN comparison in the SQL Statement?

  Read the article

• How to concatenate all the records in a column returned by a query into one varchar string in T-SQL?

  - by Ivan

  A query (SELECT/FUNCTION/VIEW/PROCEDURE) returns a column of varchar records. I need to concatenate them all into one single varchar line. How do I best do it in T-SQL?

  Read the article

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

< Previous Page | 403 404 405 406 407 408 409 410 411 412 413 414  | Next Page >