Search Results

Search found 28900 results on 1156 pages for 'sql 2005'.

Page 302/1156 | < Previous Page | 298 299 300 301 302 303 304 305 306 307 308 309  | Next Page >

• Using .net Datetime in sql query

  - by Patrick

  I have a DateTime object I want to compare against an sql datetime field in a where clause. I'm currently using: "where (convert( dateTime, '" & datetimeVariable.ToString & "',103) <= DatetimeField)" But I believe datetimeVariable.ToString will return a different value depending on the culture where the system is running. How would you handle this so it is culture independent?

  Read the article

• SQL (MySQL) vs NoSQL (CouchDB)

  - by christopher-mccann

  I am in the middle of designing a highly-scalable application which must store a lot of data. Just for example it will store lots about users and then things like a lot of their messages, comments etc. I have always used MySQL before but now I am minded to try something new like couchdb or similar which is not SQL. Does anyone have any thoughts or guidance on this?

  Read the article

• Questions on SQL Server 2008 Full-Text Search

  - by Eddie

  I have some questions about SQL 2K8 integrated full-text search. Say I have the following tables: Car with columns: id (int - pk), makeid (fk), description (nvarchar), year (int), features (int - bitwise value - 32 features only) CarMake with columns: id (int - pk), mfgname (nvarchar) CarFeatures with columns: id (int - 1, 2, 4, 8, etc.), featurename (nvarchar) If someone searches "red honda civic 2002 4 doors", how would I parse the input string so that I could also search in the "CarMake" and "CarFeatures" tables?

  Read the article

• Frequency Table by user in SQL

  - by Roberto

  Very basic SQL question (DB is MySQL): I want a table of number of transactions by users. User ID Transaction count 1 43 2 213 3 0 4 23 5 0 In a table I have the two relevant records (user_id and buy_count). How could I get the table I want? Thanks, Roberto

  Read the article

• SQL Backup files, distinguish partial and full backup files

  - by ccook

  I have scheduled backups running through SQL Agent, with Full Backups nightly, and differential backups hourly. Is there a way to determine which of the backup files is the Full backup, and which is the latest differential? Intuitively, it would seem the largest backup within 24 hours is the full, and the latest smaller backup is the partial. However, this isn't robust. Is there a way to probe the backup file to check the backup type? (Preferably in c#)

  Read the article

• SQL Server authentication - limit access to database to only connect through application

  - by Mauro

  I have a database which users should not be able to alter data in unless they use the specific app. I know best practice is to use windows authentication however that would mean that users could then connect to the database using any other data enabled app and change values which would then not be audited. Unfortunately SQL 2008 with its inbuilt auditing is not available. Any ideas how to ensure that users cannot change anything unless its through the controlling app?

  Read the article

• SQL reporting services beginner.

  - by SonOfOmer

  Hi everyone I am not clear with SQL reporting services can someone pls give me breef explanation or post some tutorial with examples and concept explanations. ] Thanks a lot.

  Read the article

• Search & Replace SQL

  - by Shonna

  I am messing around with one of my databases.. is there away for me to search for a string in ALL the tables.. and replace it with another everywhere it occurs? I am looking for SQL

  Read the article

• SQL:Placing Column values in variables using single query

  - by Shyju

  In SQL server,How can i place the value of more than one column in variables using one query Ex : My query is : SELECT ET.ID,ET.Description,ET.DefaultTemplateText FROM TBL_EMAILTEMPLATE ET WHERE ET.NAME='OneWeekReminder' I want to place the Column values in variables. Thanks in advance for the help

  Read the article

• SQL query on table that has 2 columns with a foreign id on the same table

  - by spyk

  Hello all, I have a table let's say in the form of: match(id, hometeam_id, awayteam_id) and team(id, name). How do I build my SQL query in order to get a result table in the form of (match_id, hometeam_name, awayteam_name), since they both (hometeam_id, awayteam_id) reference the same table (team)? Thank you

  Read the article

• Using Full-Text-Search in order to find partial words (SQL SERVER 2008)

  - by dig

  Hello, I'm trying to build a facebook like search for my software. I'd like to query the table customers. I've set up a FULLTEXT Index and tried the next query SELECT * FROM Customer where CONTAINS(*,'*ann*') The query does return all the customers named Ann, but it doesn't return all the customers name Anne. Is there a way to create prefix search on SQL SERVER 2008 using FTS? Thanks.

  Read the article

• sqlserver2008 reports

  - by user98454

  Hi Is SQL server 2008 reports works in adobe reader 5.1? How can i test that one? What is Microsoft report viewer?

  Read the article

• Does this PHP function protect against SQL injection?

  - by George Edison

  I have this function I'm using and I want to be sure that it fully protects against SQL injection attacks: function MakeSafeForQuery($string) { // replace all of the quote // chars by their escape sequence $ret = str_replace("\\","\\\\",$string); $ret = str_replace("'","\\'",$ret); $ret = str_replace("\"","\\\"",$ret); return $ret; } Am I missing anything serious?

  Read the article

• Retrieve data using Dynamic Query and Linq to SQL

  - by GigaPr

  Hi I have a really complicated dynamic query that i want to use to retrieve data from the database I am working in .net 3.5 sql server 2008 i created a stored procedure that accepts a varchar(max) as input parameter and does execute (@SqlQuery) it executes but does not return anything I really would like to use LINQ as all my project is implemented using linq Any Idea how to do it what is the problem?

  Read the article

• Does SQL standard allows whitespace between function names and parenthesis

  - by goran

  Checking few RDBMS I find that things like SELECT COUNT (a), SUM (b) FROM TABLE are allowed (notice space between aggregate functions and parenthesis). Could anyone provide a pointer to SQL standard itself where this is defined (any version will do)?

  Read the article

• Using SQL for localization instead of RESX files in ASP.NET

  - by user313994

  Hi, I'm thinking of developing the following but wondering if it already exists out there: I need a SQL based solution for assigning and managing localization text values for an asp.net site instead of using RESX files. This helps maintain text on the site without having to take it down for deployment whenever an update is required. Thanks.

  Read the article

• Setting SQL Relationships For LINQ Queries

  - by Soo

  I have two tables that I'm trying to create a relationship between so I can write nice LINQ queries that don't require join. Widgets WidgetId WidgetDescription Orders OrderId WidgetId OrderDate What I want to be able to do is create a LINQ query that does something similar to: var result = from x in db.Widgets Where x.Orders.OrderDate == "5/11/2010" select x; I can't seem to get intellitext to pick up the other database despite creating a relationship in SQL server. Are there any additional steps I need to take to make this work?

  Read the article

• Number query in sql

  - by Nisha

  I have table in sql as User Account 1 25 1 31 1 35 1 44 1 50 1 59 and output need in as three columns 1 25 31 1 35 44 1 50 59

  Read the article

• Keyword search on all columns of multiple tables in sql server

  - by hiralshah

  Dear all, We are maintaining the profile information’s (like profile first name, last name, address, city, state, age, religion, occupation, education, etc….) from tbl_profie table in sql server. The users can search profiles using any keywords like Example 1: MBBS, Delhi, India Example 2: MBA, Delhi, cricket Example 3 : London, Hindu Tbl_profile table defending some parent table like Tbl_city, Tbl_state, Tbl_country, Tbl_occupation, Tbl_education tables, etc. So how to fetch user search results from Tbl_profile and profiles related tables using user’s keyword with easiest way.

  Read the article

• PL SQL Where Clause with Column/Field name being a datatype

  - by Dale

  Quick question playing with PL SQL it seems that the tables column was named as the data type NUMBER so trying to perform a query fails since the column is being recognized as a datatype instead of a column name. Anyone know how to get around this without modifying the schema?

  Read the article

• Install SQL express; msm file

  - by Jacek

  Where can I download sql server 2008 msm file from ?? I need to insall it with my software ?? Thanx :) Jacek

  Read the article

• Append SQL table name with today's date

  - by Ricardo Deano

  Hello all. I understand that I can change a sql table using the follow sp: EXEC sp_rename 'customers', 'custs' How would I go about appending this so that the new table has today's date as a suffix? I've attempt variations on the below theme with little success!! EXEC sp_rename 'customers', 'customers +(CONVERT(VARCHAR(8),GETDATE(),3))' Any help greatly appreciated.

  Read the article

• I don't find the sql request

  - by user301089

  Hi everybody, Here it's my problem I've a list of the following measure : src1 dst2 24th december 2009 src1 dst3 22th december 2009 src1 dst2 18th december 2009 I would like to have just the latest measures with a sql request - 2 first lines in my case because the pairs(src and dst) aren't the same. I try to use DISTINCT but I have just the 2 first columns and I will all columns. I try too GROUP BY but I hadn't success. Anyone can help me ? Thx Narglix

  Read the article

• php 5.3.2 + MS SQL (can`t connect)

  - by Dezigo

  I allways used php 5.2.3 version ,but now I updated php to 5.3.2 version. I have problem with mssql,I can`t connect to mssql server. I have downloaded a sql server driver for php 1.1 There are a lot of files, i used 'php_sqlsrv_53_ts_vc9' Put it on php/ext directory 'php_sqlsrv_53_ts_vc9' I have added - extension=php_sqlsrv_53_ts_vc9.dll (in php.ini),but it`s give an error Call to undefined function mssql_connect() in C:\webserver\www\MSSQl\db_mssql.class.php on line 26

  Read the article

• Transparent PNG not working in SQL Server Image field

  - by Midhat

  Hi I have tried uploading a transparent PNG image to a SQL server image field, and retrieving it using the DynamicData ImageHandler. The Transparent areas in the image appear white upon rendering. Please advise about any solutions

  Read the article

< Previous Page | 298 299 300 301 302 303 304 305 306 307 308 309  | Next Page >