Search Results

Search found 28052 results on 1123 pages for 't sql tuesday'.

Page 104/1123 | < Previous Page | 100 101 102 103 104 105 106 107 108 109 110 111  | Next Page >

• Modify xml element name in SQL Server

  - by sesame

  I want to change element name with following statement: SET @myDoc.modify('replace value of (/CustomerInfo)[1] with "Customer"') from <CustomerInfo>     <ID1</ID> </CustomerInfo> to <Customer>     <ID1</ID> </Customer> But failed. So how can i change it just…

  Read the article

• Examples of SQL Injections through addslashes()?

  - by nute

  In PHP, I know that mysql_real_escape in much safer than using addslashes. However, I could not find an example of a situation where addslashes would let an SQL Injection happen. Can anyone give some examples? Thanks!

  Read the article

• Storing JSON in an SQL Server database?

  - by JKirchartz

  I'm developing a form generator, and wondering if it would be bad mojo to store JSON in an SQL Server database? I want to keep my database & tables simple, so I was going to have `pKey, formTitle, formJSON` on a table, and then store {["firstName":{"required":"true","type":"text"},"lastName":{"required":"true","type":"text"}} in…

  Read the article

• Changing window title in SQL Server Management Studio

  - by Faruz

  Is there a way to change the window title of my SQL Server Management Studio to display current server I'm connected to? To know which DB I'm connected to, I have to scroll all the way up to see the name of the server and it's a pain.. Maybe there's an available plug-in or something.

  Read the article

• Case Order by using Null

  - by molgan

  Hello I have the following test-code: CREATE TABLE #Foo (Foo int) INSERT INTO #Foo SELECT 4 INSERT INTO #Foo SELECT NULL INSERT INTO #Foo SELECT 2 INSERT INTO #Foo SELECT 5 INSERT INTO #Foo SELECT 1 SELECT * FROM #Foo ORDER BY CASE WHEN Foo IS NULL THEN Foo DESC ELSE Foo END DROP TABLE #Foo I'm trying to produce the following…

  Read the article

• Creating a trigger that manipultes a field in SQL Server

  - by icemanind

  Guys, I have a table called tblNames and one of my fields in this table is called 'UpFileName'. Is it possible to create an insert trigger that would automatically replace all '%20' in the UpFileName field to underscores '_'? I'm using SQL Server 2005.

  Read the article

• SQL injection question

  - by Luke

  I have heard of sql injection, what is it and how do i stop it? Also is there anything else i should look out for ? Thanks

  Read the article

• SQL Server 2005 red herring error "The user does not have permission to perform this action"

  - by Sylvia

  We're getting the error "The user does not have permission to perform this action" during times of heavy load (regularly, when a trim job occurs). The error clears up when the service accessing sql server is restarted, so it's obviously not a real permissions problems. What kind of situations could cause an error like this, when…

  Read the article

• help translate this week query from Oracle PL/SQL to SQL Server 2008

  - by Sarah Vessels

  I have the following query that runs in my Oracle database and I want to have the equivalent for a SQL Server 2008 database: SELECT TRUNC( /* Midnight Sunday */ NEXT_DAY(SYSDATE, 'SUN') - (7*LEVEL) ) AS week_start, TRUNC( /* 23:59:59 Saturday */ NEXT_DAY(NEXT_DAY(SYSDATE, 'SUN') - (7*LEVEL), 'SAT')…

  Read the article

• Prevent SQL Server Table operations (INSERT and DELETE) on some tables

  - by stckvrflw

  While working with some random sql queries on our databases, we may not want to insert or delete items to some of the database tables by just typing their names by mistake. So how to make them locked to the "editing", to be able to work safe. Thanks.

  Read the article

• SQL Server: error when connecting

  - by atricapilla

  The application I'm using tries to connect SQL Server named instance running on a dedicated database server. Here's the error I'm getting: The TCP/IP connection to the host <instance_name>, port 1433 has failed. Error: Connection refused: connect. Is the firewall blocking my access or what? Should I dedicate a different…

  Read the article

• Meaning of Primary Key to Microsoft SQL Server 2008

  - by usr

  What meaning does the concept of a primary key have to the database engine of SQL Server? I don't mean the clustered/nonclustered index created on the "ID" column, i mean the constraint object "primary key". Does it matter if it exists or not? Alternatives: alter table add primary key clustered alter table create clustered…

  Read the article

• Power error handling inside of sql function

  - by user172062

  I have a power function call inside of a sql function. What is the correct way to handle overflow and underflow conditions since I cannot use a Try Catch inside of a function. I am also trying to avoid modifying the ARITHABORT, ANSI_WARNINGS, and ARITHIGNORE settings in the calling code. GO CREATE FUNCTION TestPow() RETURNS…

  Read the article

• Flatten date range memberships retaining only the highest priority membership (TRANSACT-SQL)

  - by shadowranger

  Problem statement: A table contains an item_id, a category_id and a date range (begin_date and end_date). No item may be in more than one category on any given date (in general; during daily rebuilding it can be in an invalid state temporarily). By default, all items are added (and re-added if removed) to a category…

  Read the article

• SQL Server differential backup to SQL statements

  - by noonex

  Is there any way to convert differential backup to SQL statements which will produce identical results when applied? Or any other solution similar to binary log in MySQL?

  Read the article

• Translate SQL query to LINQ

  - by ile

  PhotoAlbums table AlbumID Title Date Photos table: PhotoID Title Date AlbumID SELECT AlbumID, Title, Date, (SELECT TOP (1) PhotoID FROM Photos AS c WHERE (AlbumID = a.AlbumID)) AS PhotoID FROM PhotoAlbums…

  Read the article

• how to insert rows in a excel sheet into Sql server 2005 or oracle

  - by Arunachalam

  how to insert rows in a excel sheet into Sql server 2005 or oracle ? for example if i have 5000 rows in excel sheet how can i insert these rows into a table in any database

  Read the article

• SQL Server: Migrate Stored Procedures between Databases, Instances

  - by LS

  I just copied my current database to a new database to find out only the tables are copied, How do I copy all stored procs the same way in one go? I do not want to create each stored proc one by one again running create queries Thank you in advance This is in MS SQL

  Read the article

• SQL Alias as Table.column

  - by bakerjr

  hi, is it possible to alias an aggregate function in a select clause as AliasTable.AliasColumn? The reason is because I want minimum modifications in my arrays (I'm using PHP). Thanks! P.S. I'm using SQl Server 2008

  Read the article

• How to insert rows in an Excel sheet into SQL Server 2005 or oracle

  - by Arunachalam

  How to insert rows in an Excel sheet into SQL Server 2005 or oracle ? For example if I have 5000 rows in Excel sheet how can I insert these rows into a table in any database

  Read the article

• How to quote and reference MS SQL table and field names

  - by artvolk

  Good day! Despite the fact LINQ2SQL and ADO.NET Entity Framework exists there were situations when I need to revert to plain old DataSet (not typed) and friends. While writing SQL for SqlCommand: Is it needed to quote field and table names with []? Is it good to prefix table names with [dbo] I use to use this…

  Read the article

• In a stored procedure how to run a query and conditionally do something

  - by Greg

  How would I do this in a stored procedure (SQL 2005): count = select count(*) from table1 where line like '%success%' if count > 0: delete from table1 where not line like '%success%' Thanks for any help. My google skills are really failing me today :-(

  Read the article

• Other language string in SQL Server 2005

  - by balachandar

  I am trying you insert some string which is not in English (other language). when i fetch back they are not correct. They comes like "?????". But at the same time when I enter the string through the SQL Server UI (SSMS) to enter the string, it works OK. What could be the solution please?

  Read the article

• SQL hidden techniques?

  - by AlexRednic

  What are those pro/subtle techniques that SQL provides and not many know about which also cut code and improve performance? eg: I have just learned how to use CASE statements inside aggregate functions and it totally changed my approach on things. Are there others?

  Read the article

• SQL Images in different tables

  - by Adonis L

  I am storing images in a SQL database , right now I have images being stored in separate tables depending on the object the images belong to, is there any reason ( performance etc..) why I should keep it this way and not store all images in the same table?

  Read the article

< Previous Page | 100 101 102 103 104 105 106 107 108 109 110 111  | Next Page >