Search Results

Search found 28249 results on 1130 pages for 'sql injection'.

Page 421/1130 | < Previous Page | 417 418 419 420 421 422 423 424 425 426 427 428  | Next Page >

• How can I handle emailed job control files for SQL Server?

  - by ganesh

  How can I detect control files from any mailbox, scan that file, decrypt it and queue it as a job using job manager in SQL Server?

  Read the article

• How to install Visual Studio 2008 and MS SQL Server 2008 in Ubuntu ?

  - by Vicheanak

  Hi guys, I would like to install Visual Studio 2008 and MS SQL Server 2008 on Ubuntu OS which I have in my PC, however, I don't know how. May I have some tips please? Thanks.

  Read the article

• Is it possible to use SQL XML to insert, and get output from each record?

  - by nbolton

  I would like to perform a SQL XML insert (on MSSQL), and in this case I need to insert a list of files into the DB (this is simple enough). However, there's an auto generated PK column (ID), and I need the ID for each newly created filename without performing a 2nd query. Is this possible? I guess it doesn't matter if the result is/isn't XML, but the input certainly has to be.

  Read the article

• Where does sql server stores the stored proecdure 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

• Which user account to assign as owner when attaching an SQL Server database?

  - by FreshCode

  This is a simple database security & performance question, but I've always used either a special user (eg. mydbuser), or Windows' built-in NETWORK SECURITY account as the owner when attaching databases to my SQL Server instances. When deploying my database to a production server, is there a specific user I should stick to or avoid? I would think that using an account with a set password could open the database up to a potential security issue.

  Read the article

• How to find size of a data type in pl/sql (oracle 9i)?

  - by Vineet

  hi, I want to find the size of any data type in pl/sql,for eg DECLARE x boolean; I want to find size of like X,is there any function like (sizeof() in C) or any how i can find it.Please let me know!

  Read the article

• Is the max limit of 4 GB on sql server 2005 express .mdf + .ldf or for .mdf only ?

  - by HotTester

  Is the max limit of 4 GB on sql server 2005 express .mdf + .ldf or for .mdf only ? Kindly clarify. Thanks.

  Read the article

• Why does SQL Server 2008 suggest I have the primary key column as an included column in an index

  - by Raine

  SQL Server 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

• What is the correct SQL for a trigger to copy a record to an identical table?

  - by Owen

  I have two tables TABLE1 and TABLE2 with identical structures. I need a trigger to copy a record after insert from TABLE1 to TABLE2. What's the proper SQL for this?

  Read the article

• SQL CE, SQLite. What are the differences between them?

  - by acidzombie24

  What is the difference between SQL CE and SQLite? In what situation would i choose one over the other?

  Read the article

• In SQL, can we always write an inner join statement as a main query and subquery?

  - by Jian Lin

  In SQL, can we always write an inner join statement as a main query and subquery? 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?

  Read the article

• how to show only even or odd rows in sql server 2008 ?

  - by Gold

  hi i have a table MEN in sql server 2008 that contain 150 rows. how i can show only the even or only the odd rows ? thank's in advance

  Read the article

• How do I add a record only if it doesn't already exist in SQL Server?

  - by menacheb

  Hi, I have a project in C# with a Sql-server Database. In that database I have a table named 'Process' and columns named 'process_name', 'Full_Name' and 'Version' (all of the type:nvarchar(50)). I want to write a query wich will add the new process, only if it doesn't exist in the table yet. How can I do that? Many thanks,

  Read the article

• SQL: ... WHERE X IN (SELECT Y FROM ...) ...

  - by Craig Johnston

  Is the following the most efficient in SQL to achieve its result: SELECT * FROM Customers WHERE Customer_ID NOT IN (SELECT Cust_ID FROM SUBSCRIBERS) Could some use of joins be better and achieve the same result?

  Read the article

• Does Hibernate log the values that it assigns to placeholders in prepared SQL statements?

  - by Derek Mahar

  Does Hibernate log the values that it assigns to placeholders in prepared SQL statements? How can configure Log4j so that it writes these values to my log files?

  Read the article

• SQL SERVER Query result in CSV format is possible?

  - by gopal

  Hi, Is it possible to get the query result in .CSV file format from SQL SERVER 2000 and above versions? If so can we use this feature from an asp.net application to get the result in CSV format? If so how can we do this?

  Read the article

• How to use Linq To Sql to get Users who has more than 2 photos?

  - by Mike108

  The scenario is I want to get the users who has more than 2 photos. There are two table: [Users] (UserId, UserName) [UserPhotos] (PhotoId, PhotoName, UserId) and UserId is a Foreign Key. A user may have none photo in the [UserPhotos] table. How to use Linq To Sql to get List who has more than 2 photos?

  Read the article

• LINQ to SQL .Count takes way to much process time and decreases performances.

  - by soldieraman

  LINQ to SQL .Count takes way to much process time and decreases performances. I am doing a recursive loop and for one child (lets call it parent) I have to check the number of children under it to make a decision if it should be included or not. The Count is too slow 8 ms :( for 120 parent records. Any ideas to make it quicker.

  Read the article

• How to distinguish between the first and rest for duplicate records using sql ?

  - by Biswanath

  Hi, These are the input table and required output table. Input table ID Name ------------- 1 aaa 1 ababaa 2 bbbbbb 2 bcbcbccbc 2 bcdbcdbbbbb 3 ccccc Output table ID Name Ord ----------------------------- 1 aaa first 1 ababaa rest 2 bbbbbb first 2 bcbcbccbc rest 2 bcdbcdbbbbb rest 3 ccccc first First and Rest is based on the occurrence of an ID field. Is there a way to write a SQL query to achieve this ? P.S. - This question is somewhat similar to what I am looking for.

  Read the article

• How do I insert records into 2 SQL tables sharing a dependency when I don't commit until the end?

  - by Cunning Lingus

  I keep finding myself in this situtation: I have an ASP.NEt 2.0 app. I have to insert into 2 tables in SQL. There is a dependency between the tables. I insert a record the first using a transaction. Then I move onto the 2nd table. But, because the first isn't committed yet the second one throws a error.

  Read the article

• sql server: looking for table usage through out database...

  - by dotnet-practitioner

  How would I figure out what type of sql code such as procs, functions, views etc. are interacting with my table called TABLE1 through out a given database. Sample code would be very helpful for me. thanks

  Read the article

• how to get time (hh:mm:ss) from sql query ?

  - by Gold

  hi i have Database with date field. i see the time like: 1900-01-01 13:38:00.000 how i can see it like: 13:38 ? (i work on sql server 2008) thank's in advance

  Read the article

• What SQL query should I perform to get the result set expected?

  - by texai

  What SQL query should I perform to get the result set expected, giving the first element of the chain (2) as input data, or any of them ? table name: changes +----+---------------+---------------+ | id | new_record_id | old_record_id | +----+---------------+---------------+ | 1| 4| 2| | -- non relevant data -- | | 6| 7| 4| | -- non relevant data -- | | 11| 13| 7| | 12| 14| 13| | -- non relevant data -- | | 31| 20| 14| +----+---------------+---------------+ Result set expected: +--+ | 2| | 4| | 7| |13| |14| |20| +--+ I know I should consider change my data model, but: What if I couldn't? Thank you in advance!

  Read the article

• SQL Exception: A truncation error was encountered trying to shrink VARCHAR '...' to length x

  - by Tom Brito

  I know really little about sql, can anyone give me a deeper explanation (or references) of what do this exception means? Possible related question: http://stackoverflow.com/questions/1016901/truncate-a-varchar-to-specific-length-in-derby-automatically

  Read the article

• How to write or append to text file using sql?

  - by aron

  Hello, in short i need to convert following C# code into SQL stored procedure foreach (var e in Entity) { if (File.Exists(e.Filename)) File.AppendAllText(e.Filename,e.Content); else File.WriteAllText(e.Filename, e.Content); }

  Read the article

< Previous Page | 417 418 419 420 421 422 423 424 425 426 427 428  | Next Page >