Search Results

Search found 36186 results on 1448 pages for 'sql 11'.

Page 290/1448 | < Previous Page | 286 287 288 289 290 291 292 293 294 295 296 297  | Next Page >

• SQL Server, varchar data to nvarchar data

  - by Øyvind

  I've got a database with collation Danish_Norwegian_CS_AS and lots of varchar columns. I'd like to convert all this data to unicode, but haven't found a way to convert this data yet. If I've understood correctly, the encoding used is UCS-2 little endian. For example I've got a column containing 'PÃ¥l-Trygve' which is easily converted with C# to 'Pål-Trygve' using Encoding.Default.GetString(Encoding.UTF8.GetBytes("PÃ¥l-Trygve")); Is there a way to do this conversion in the Microsoft SQL Server client?

  Read the article

• SQL CLR enabling

  - by user171523

  I would like to get some opinion on production SQL environement enabling CLR 1) What are the disadvantagies of doing something like this. 2) I also would like to know the adoption of something like this. 3) Anything best practices we need to keep in mind when we implement CLR based SP and Triggers.

  Read the article

• Run SQL script inside Visual Studio

  - by burntsugar

  I have a scripted database SQL file that I need to execute inside Visual Studio to create a new database. I am so far unable to locate any function that allows me to do this.

  Read the article

• How do I find sql server instances in a given range of IP address es

  - by Anshuman Roy

  I want to discover SQL Server instance in a given range of IP address using C#. How do I do this. Thanks in advance.

  Read the article

• sql median value of column

  - by Mike

  Is there a way in sql (or tsql) to select the median of a column of numbers? I know you can sort by the column and pick the middle value, but it would be nice if there was a built-in function

  Read the article

• Define a varbinary(max) column using sqlalchemy on MS SQL Server

  - by Mark Hall

  Hi, I'm querying an SQL Server database using SQLAlchemy and need to cast a column to varbinary(max). The thing I am struggling with is the "max" part. I can get the cast to work for any actual number (say varbinary(20)), but I cannot find how to get it to work for the "max" size of the varbinary column. Any pointers? Links? Solutions? Regards, Mark

  Read the article

• Can I use TransactionScope to do distributed transaction?

  - by Malcolm

  Hi I have a MVC app that use Linq2Sql to access a SQL DB. But I want create a distributed transaction to update another DB on different local server. Can I just wrap logic in TransactionScope class??? Malcolm

  Read the article

• SQL CHECK constraint to prevent date overlap

  - by Michael

  I have a table that describes which software versions were installed on a machine at various times: machine_id::integer, version::text, datefrom::timestamp, dateto::timestamp I'd like to do a constraint to ensure that no date ranges overlap, i.e. it is not possible to have multiple software versions installed on a machine at the same time. How can this be achieved in SQL? I am using PostgreSQL v8.4.

  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

• 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

• Transfer data from SQL Server table using query to Excel and vice-versa

  - by Abhishek Kapuria

  I want to transfer data from SQL Server table to Excel sheet using 3 tier architecture in asp.net 3.5. After user has made required changes in the Excel sheet I want Excel sheet to get uploaded and update data in the table with validation for proper data.

  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

• 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

• 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 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

• 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

• 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

• 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

• 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

• 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

< Previous Page | 286 287 288 289 290 291 292 293 294 295 296 297  | Next Page >