Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
67,324 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 1,347
Page Size: 10 · 25 · 50

Category filtered by:  Database & SysAdmin [x]
Forum Message 13 May 2013  
I wouldn't do that. It's against the "Rules" of normalization. You don't want to make a row dependant on another row in the same table. Think of all the fuzz to update the table when you find out som
Database & Sysadmin » Database
Forum Message 13 May 2013  
Bikash Prakash Dash wrote:You have to provide any value for that No you have to provide the correct key, any key will corr
Database & Sysadmin » Database
Forum Message 13 May 2013  
Primary key value cant be null. You have to provide any value for that.
Database & Sysadmin » Database
Forum Message 13 May 2013  
Firstly, you have to download the Oracle Database Software. go to oracle.com and download the software. I suggest to download 11g R2 windows version. It's more easier to install on windows than on
Database & Sysadmin » Database
Forum Message 13 May 2013  
Hi, Check the Script SELECT M.ID,(ROW_NUMBER() OVER(PARTITION BY M.EmpID ORDER BY M.EmpID)) 'RowNumber', M.EmpID, M.Leave_Year, M.Taken, M.Credit, (SELECT SUM((ISNULL(Balance,0
Database & Sysadmin » Database
Forum Message 13 May 2013  
Hi All, In DB2, i have used XMLAGG built in function in order to convert Rows to Column String Concatenation. Since lot of records are available in the table, performance wise it was too slow. Whet
Database & Sysadmin » Database
Forum Message 13 May 2013  
Can you explain more in details your case? I Love T-SQL
Database & Sysadmin » Database
Forum Message 13 May 2013  
EmpID Leave_Year Taken Credit Balance 435 2014 0 22 22 435 2013 10 22 12 435 2012 24 22 0 435 2011 20 22 2 435 2010 23 22 0 435 2009 21 22 1 I
Database & Sysadmin » Database
Forum Message 13 May 2013  
Several screens (or one very functional one) to view the data in a variety of ways like by Phase, by ESXHost, by Application. I think if we have several drop downs for filtering then that would work;
Database & Sysadmin » Database
Forum Message 12 May 2013  
Thank you very much. I just needed a clarification for not under-estimating my decision over my superior. Thank you very much.
Database & Sysadmin » Database
Forum Message 12 May 2013  
I don't see any issues with this approach, the dedicated view may be useful if reconciliation is required or you are going to use an OLAP system but not for you current requirements.
Database & Sysadmin » Database
Forum Message 12 May 2013  
Member 9912091 wrote:Doesnt BOOK generate same/new PUBLISHER_CODE from PUBLISHER table since its a foreign key? No - you have to retrieve it
Database & Sysadmin » Database
Forum Message 12 May 2013  
Dear all, I require your opinion on what approach is good and/or practical for the following scenario. There is a web application which queries data from SQL server. For example: User
Database & Sysadmin » Database
Forum Message 12 May 2013  
Hi all. I have run into a problem with inserting values into table. I have 2 tables: PUBLISHER with fields: PUBLISHER_CODE (Primary Key) and PUBLISHER_NAME. BOOK table fields: PUBLISHER_CODE (Pri
Database & Sysadmin » Database
Forum Message 12 May 2013  
I'm using Oracle SQL Developer Data Modeler[
Database & Sysadmin » Database
Forum Message 12 May 2013  
Thanks! :)
Database & Sysadmin » Database
Forum Message 11 May 2013  
See if this helps: Dashboard in Visual Basic[
Database & Sysadmin » System Admin
Forum Message 11 May 2013  
Eddy Vluggen wrote:Not "NOW", I'm at work. You rude bastard. Help his my now! Michael Ma
Database & Sysadmin » System Admin
Forum Message 11 May 2013  
Instead of using 1 in Eddys query use count(*), this will tell you how many records match the name. You should study database design as you may run into some of the basic errors made by newbies. Pr
Database & Sysadmin » Database
Forum Message 11 May 2013  
Yeah, what Eddy said. But, provided you have a unique index on the column (and you should), it may be more efficient simply to try the INSERT and catch the exception -- you have to do that anyway.
Database & Sysadmin » Database
Forum Message 11 May 2013  
Member 9912091 wrote:I want to compare a username entered into a textbox with the existing usernames in the ACCOUNT tableSELE
Database & Sysadmin » Database
Forum Message 11 May 2013  
Hi all. I am busy writing a program, in Microsoft Visual Web Developer, and have a database was several tables. The one I am focusing on now is the ACCOUNT table. This table contains username, passwor
Database & Sysadmin » Database
Forum Message 11 May 2013  
Yeah it didnt work. However I realised that this script didnt have any code to create tables so I used a different script with "CREATE TABLE" code in the query and it worked! thanks
Database & Sysadmin » Database
Forum Message 10 May 2013  
See if it helps: Copy Table With Data From One Database to Another in SQL Serve
Database & Sysadmin » Database
Forum Message 10 May 2013  
Did you refresh the Object Explorer after creation? Personal Blog: A Software Programmer Twitter:
Database & Sysadmin » Database
Forum Message 10 May 2013  
Hi All, If any one tell me by which i can transfer table from one sql server database to another sql server database.
Database & Sysadmin » Database
Forum Message 10 May 2013  
This could be an odd question, but, you tried Quote:SELECT * From Foo WHERE Type = 'Sales Tax ([%])' Cause, when your using '=' comman
Database & Sysadmin » Database
Forum Message 10 May 2013  
As Jörgen Andersson said, cte is faster cause there's no IO on disk, it's just memory. when you declare an #Temporary, you really create the table on your tempdb, that means that you have to write
Database & Sysadmin » Database
Forum Message 10 May 2013  
Hi all. I am using Microsoft SQL Server 2008 Management Studio. I have been trying to create a database (containing tables etc) from a query file (Delivery.sql). In the Object explorer I right-clic
Database & Sysadmin » Database
Forum Message 10 May 2013  
JohnBlocker wrote:When parsing user input that has SQL reserved characters Parsing how? What application/language are you doing thi
Database & Sysadmin » Database
Forum Message 10 May 2013  
Karthik_J, Coimbatore wrote:Microsoft SQL Server 2012 introduces 14 new built-in functions. And you posted this to demonstrate that you ca
Database & Sysadmin » Database
Forum Message 10 May 2013  
My bad, I think my brain went to sleep before the rest of me did. Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln
Database & Sysadmin » Database
Forum Message 10 May 2013  
Please read[
Database & Sysadmin » Database
Forum Message 10 May 2013  
Hi there, I just want to get some opinions on which tool to use to diagram an ER Picture of a DB model having approx 900 tables, but .... I have tried a few (Erwin, Aqua Data Studio, Powerdesigner
Database & Sysadmin » Database
Forum Message 10 May 2013  
Microsoft SQL Server 2012 introduces 14 new built-in functions. These new functions are: Conversion functions > PARSE > TRY_CONVERT > TRY_PARSE Date and time functions
Database & Sysadmin » Database
Forum Message 10 May 2013  
JohnBlocker wrote:Even if I omit the parenthesis around the % sign, it does not find the rows. So this: SELECT * From Foo W
Database & Sysadmin » Database
Forum Message 9 May 2013  
I am not sure I understand. The % character does not appear in any field names, or table names. The data type of both fields, named "Type" and "SubType" are text, and that text data can contain a % ch
Database & Sysadmin » Database
Forum Message 9 May 2013  
Access isn't SQLServer. You're not supposed to use brackets either. I would strongly recommend renaming the offending fields. More info here[
Database & Sysadmin » Database
Forum Message 9 May 2013  
And we can use of it form programming (dataset dt=new,....) and from toolbox in the visual studio,right?
Database & Sysadmin » Database
Forum Message 9 May 2013  
DataAdapters enable the disconnected paradigm.
Database & Sysadmin » Database
Forum Message 8 May 2013  
You should use Where Clause at End of Statement Like SELECT * FROM dbo.OutputPromptItem JOIN dbo.OutputPrompt ON dbo.OutputPromptItem.PromptId=dbo.OutputPrompt.Promp WHERE Segm
Database & Sysadmin » Database
Forum Message 8 May 2013  
On SQLServer you can think of the CTE as an inline view, while the temporary table will be materialized and can be indexed. mehdi.sabet wrote:which of
Database & Sysadmin » Database
Forum Message 8 May 2013  
I am using an Access 2000 database file. When parsing user input that has SQL reserved characters, I put [] around any reserved characters I find. This works fine, except when dealing with %s. I ha
Database & Sysadmin » Database
Forum Message 8 May 2013  
Is it correct we can fill a dataset with connected objects(connection,command,dataadapter) and without them(with data source window)? if yes so we are using of the connected objects to fill a disconne
Database & Sysadmin » Database
Forum Message 8 May 2013  
I would not include DataAdapter in the "connected" category. The "connected" paradigm is still appropriate for many applications, but less so with distributed applications. DataAdapters cause me
Database & Sysadmin » Database
Forum Message 8 May 2013  
//for each row of gridview CheckBox chk; for (int i = 0; i
Database & Sysadmin » Database
Forum Message 7 May 2013  
Hi everyone I have a question,is it correct connected data objects consist of connection,command,reader and dataadapter(why we need to DataAdapter in a connected model?),transaction,.... disconnect
Database & Sysadmin » Database
Forum Message 7 May 2013  
I'd go for the PowerShell option mentioned here[
Database & Sysadmin » Database
Forum Message 7 May 2013  
mehdi.sabet wrote:what diffrence betwwen in two below tableThe first will only work on Sql2005+, since that's when the Common Table Expressio
Database & Sysadmin » Database
Forum Message 7 May 2013  
what diffrence betwwen in two below table with cteStudent(ID,Name,Family) AS ( select ID,Name,Family from tblStudent ) select * from cteStudent S
Database & Sysadmin » Database
Page 1 of 1,347
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web04 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid