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*
  
2,398 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 48
Page Size: 10 · 25 · 50

Tag filtered by:  database [x]
Answer 13 May 2013   license: CPOL
You have already probably come up with something, but for anybody else who comes across this, I recommend Umbraco to do out of the box presentation (other than just "articles").See my article for how to get started: Umbrazure: Limitless Websites with Umbraco on Azure.Umbraco allows you...
databaseCMSLinks
Question 13 May 2013   license: CPOL
Hey everybodyI am in troubleI have a WPF control with a lisview with the codegroups which I can select and unselect with a checkbox on the leftside for every codegroup. every codegroup is in the same table named "CODE_DESCRIPTION". I can list now in the listview every codegroups from the...
C#ADO.NETOracleExceldatabaseInteropexport
Article 12 May 2013   license: CPOL
Implementation of relative database constraints and permissioning using triggers and shadow tables
SQLSQL-Serverdatabase
Answer 11 May 2013   license: CPOL
I agree it is almost impossible.If you have queries like select * used in your application than you cant just go and delete data ....First you need to examine your application code. This can be time consuming, but it is a good place to start. Finding all references for each column...You can...
SQL-Serverdatabase
Answer 10 May 2013   license: CPOL
I think that, given enough time, I could proof that in general case this is theoretically impossible. But I can give you the idea:http://en.wikipedia.org/wiki/Halting_problem[^].Are you getting the picture? You may have some "dead code" in your application, which uses some columns but is...
SQL-Serverdatabase
Question 10 May 2013   license: CPOL
I have interesting task. We are using a bunch of tables filled with data we don’t use anymore. Problem is I don’t have documentation for applications used in the past with our SQL Server tables so I must manually locate unused column data. Is there some tool out there to do this job for me?
SQL-Serverdatabase
Answer 8 May 2013   license: CPOL
Try reading the data with the following SQL SELECT TOP 100 percent * FROM [yourtable] ORDER BY newid()You can change the 100 percent - I just assumed you'd want the entire table.You could also drop the percent to get e.g. 100 questions.With acknowledgements to Ralph Shillington[^]
VBdatabaseVB.NETDataTable
Answer 8 May 2013   license: CPOL
My first thought is that you add a column. For each row you generate a random number and populate that column with it. Then sort by that column.Google Results for Generating a Random Number[^]
VBdatabaseVB.NETDataTable
Question 8 May 2013   license: CPOL
New to DataBase. I have a sql server database with one datatable connected to my application. I want the rows of this datatable to be sorted randomly each time the application starts. How do I do that?[Edit - further detail from OP]I'm trying to make a quiz. My datatable has four colomns...
VBdatabaseVB.NETDataTable
Answer 8 May 2013   license: CPOL
It's quite possible that the log file can be greater than the database - it really depends on the number of transactions rather than the number of records. It's ok to change MAXSIZE but you need to be really sure that you want to (you can get all sorts of issues when the transaction log fills...
SQL-Serverdatabaselog
Question 8 May 2013   license: CPOL
I created a database, putting some data, making dummy/testing connections in my vb.net projectsMy database has 9 tables 1 is for users and the other tables can have millions of data. When I try to view the Database SQL(Script Database as -> Create To -> New Query Editor Window) I found...
SQL-Serverdatabaselog
Answer 4 May 2013   license: CPOL
This post might help you :LINK
SQLC#C#4.0databaseBackup
Answer 3 May 2013   license: CPOL
HiRecently done a similar thing (But you don't say if you need a database on each workstation, or if you are using a central Database on a network server.) I installed SSE2008R2 (SQL Server 2008 R2 Express) (Free) on their Server.I used SSMA (Sql Server Migration Assistant for...
VBSQL.NETSQL-ServerVBdatabaseVB.NET
Answer 1 May 2013   license: CPOL
-Have multiview control in your page with two views.Change the view according to selected value of the Radiobutton.-When you select NEW COMPLAINT,then your second view will be displayed as below.
ASP.NETdatabaseformmailing
Question 1 May 2013   license: CPOL
I want to design a ASP.Net form for feedback/Complaint page.My requirement is:* There sholud be two radio buttons on the top of the page.(1 is for old Complaints and another is for new complaint.)* When user clicks on old complaints then a textbox will be displayed and asking for "Your...
ASP.NETdatabaseformmailing
Answer 30 Apr 2013   license: CPOL
Sorry I got Solution.By using Parametrized Query it shows output.
C#ASP.NETAccessdatabase
Question 30 Apr 2013   license: CPOL
In SQL it shows correct Result, but in MS Access 2003 no Data Shows through DataSet. But same query shows result through SQL View in MS Access.Code is :string str = "select checktime from CHECKINOUT where UserId=2 and checktime between 04/11/2013 and 04/12/2013";private DataSet DSet(string...
C#ASP.NETAccessdatabase
Answer 30 Apr 2013   license: CPOL
Thanks everyone for the solutions...This has certainly opened up my direction..Thanks again..Cheers,Nayan
databasesecurityWebServiceWinFrom
Answer 30 Apr 2013   license: CPOL
WCF might be a good option for you. You can take advantage of the attributes that WS-Security provides – it describes how to handle security issues within the SOAP messages. WS-Security assigns the signature and encryption information as well as the security tokens to the SOAP messages. Besides...
databasesecurityWebServiceWinFrom
Answer 30 Apr 2013   license: CPOL
I suggest that you look into WCF and Web Services.
databasesecurityWebServiceWinFrom
Question 30 Apr 2013   license: CPOL
Dear all, I have puzzled myself over data communications from winforms to the SQL server database. Here is the scenario:I am developing a windows application which I will be publishing via ClickOnce technology.Therefore, the client resides on user PC and the data will be...
databasesecurityWebServiceWinFrom
Question 30 Apr 2013   license: CPOL
WHAT is the e-r diagram for monitoring smart gadgets online
databaseRelationship
Answer 30 Apr 2013   license: CPOL
There are various options to you, and this is a very broad approach to things.It also depends how you want to operate.If the sites do not need 100% up to date information then you could use Data Synchronisation approaches:Choose a Data Synchronization Technology[^]If they do need...
C#SQLdatabaseSolutionproblemShared
Question 30 Apr 2013   license: CPOL
Hi everyone :)I have a Store Management System for a company that have 4 branches and each branch have 4 system clients.The 4 branches works on a central database over internet connection, the problem here is the data saving and retrieving are more slow.So there is any solution for...
C#SQLdatabaseSolutionproblemShared
Answer 29 Apr 2013   license: CPOL
Hi footballpardeep,Why you didnt ask google about it? I hope this link[^] would help you a bit.Regards,RK
SQLC#C#4.0databaseBackup
Answer 29 Apr 2013   license: CPOL
HiYou can convert your access database into SQL Server really easily, With Import option in SQL Server, you just need to create new database in your SQL Server and after that you can use Import Database option, these links can be use full...
VBSQL.NETSQL-ServerVBdatabaseVB.NET
Answer 28 Apr 2013   license: CPOL
The "proper" way to make triggers really depends on your database schema, your application, your need to audit etc etc .... for example *we* currently audit approximately 150 "sensitive" items across 20 tables ... we don't "care" about the rest. This link has discussions about several...
SQLdatabasetrigger
Answer 28 Apr 2013   license: CPOL
Most likely you have memory issues and your SQL Server is using tempdb to store data or you are running DBCC CheckDB command often (stores results in tempdb)Running bulk transactions also can cause this. Troubleshooting article - http://msdn.microsoft.com/en-us/library/ms176029.aspx[^]
database
Answer 28 Apr 2013   license: CPOL
If you just need to make triggers for a few tables I suggest installing some tool like ApexSQL Audit[^] Use it in trial mode to make audit triggers and then examine how it is done. Than just make your triggers. Nice and clean :)
SQLdatabasetrigger
Article 28 Apr 2013   license: CPOL
NoSql, JSON based, Document store database with compiled .net map functions and automatic hybrid bitmap indexing and LINQ query filters (now with standalone Server mode, Backup and Active Restore, Transactions, Server side queries, MonoDroid support)
C#.NETArchitectDBADevWebFormsBeginnerIntermediateAdvancedWeb-Development, +
Answer 26 Apr 2013   license: CPOL
You could have tried Google[^] for the solution.Refer the links below:Show Image in Listview retrieve from database in ASP.net[^]How To Retrieve Image from Database in ListView Control in asp.net 3.5 [^]How to Retrieve Images from Database into Listview using Eval()[^]--Amit
ASP.NETdatabaseListView
Question 26 Apr 2013   license: CPOL
hi all:I wrote this peace of code: name: ...
ASP.NETdatabaseListView
Answer 25 Apr 2013   license: CPOL
The only way to guarantee getting the last entered is to timestamp the records when you create them, but including a datetime column in the table. This allows you to use the ORDER BY clause in your select query, and then return the top 30 results:SELECT TOP 30 * FROM MyTable ORDER BY EnteredAt...
SQL-ServerdatabaseCommands
Answer 25 Apr 2013   license: CPOL
Basically,RDDMS is Short for relational database management system and pronounced as separate letters, a type of database management system (DBMS) that stores data in the form of related tables. Relational databases are powerful because they require few assumptions about how data is related or...
databaseMFC/C++
Question 25 Apr 2013   license: CPOL
Am new to SQL SERVER 2008How can i get the last 30 entered record on a database using Sql commands/statementsThanks in Advance
SQL-ServerdatabaseCommands
Answer 25 Apr 2013   license: CPOL
Any of the well know DB systems would suit your purpose, but you need to research them to decide which is the 'best' for your needs. SQL Compact Edition is a fairly simple one and does not require a server to run on. See https://www.google.com/search?q=database+mfc[^] for suggestions from Microsoft.
databaseMFC/C++
Question 25 Apr 2013   license: CPOL
Hello,I have created one application in MFC. when client run the exe then I need to maintain some of the activity data to in that PC. so I nee to store in some of the file or database which can not accessed by that user and only accessible by application only.One way to do this is store...
databaseMFC/C++
Answer 25 Apr 2013   license: CPOL
Refer this link to understand how to implement[Audit Trail].
SQLdatabasetrigger
Question 25 Apr 2013   license: CPOL
Few days ago I noticed our tempdb is started to grow fast. How can I see what is causing this? We didn’t do anything recently. Soon we will run out of disk space.
database
Question 25 Apr 2013   license: CPOL
What is the proper way for implementing audit triggers. I found many examples but I am still not sure what is the best way to implement. I need to track changes on few tables. Basically I need to keep track of everything. I want it nice and clean.
SQLdatabasetrigger
Answer 25 Apr 2013   license: CPOL
We can't help you with upgrading the database.For the second part of your question have a look at this comparison http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems[^]For instruction on how to use whichever one you choose refer to the supplier's website
VBSQL.NETSQL-ServerVBdatabaseVB.NET
Question 25 Apr 2013   license: CPOL
Hi everyoneI have developed a small vb .net application for friend to use in their business. I have used Access as the database which is quite easy to use. But now I want to upgrade the database from access to sql. Please help me And if my client does not want A high-end SQL-server on...
VBSQL.NETSQL-ServerVBdatabaseVB.NET
Answer 24 Apr 2013   license: CPOL
You need to create another table like thisCREATE TABLE dbo.RItems( Id1 int not null, Id2 int not null)and get all related items simple by executing this querySELECT Id2FROM RItemsWHERE Id1 = @ID
SQL-Serverdatabase
Answer 24 Apr 2013   license: CPOL
You can't use SUM on a DateTime and varchar column. If your final goal is to get sum of all datadiff records in hh:mm:ss then stored the difference in minutes as:-SELECT DATEDIFF(second,CAST('02:32:00' AS DATETIME), CAST('03:40:00' AS DATETIME))/60.0 AS MIN_DIFF;Then to do sum of...
SQL-ServerDateTimedatabase
Question 24 Apr 2013   license: CPOL
I have a column with date-time and i want to add then display all the time from the start till the end as one record:For example:DelayTime:1900-01-01 02:30:50.0001900-01-01 03:20:10.0001900-01-01 02:40:00.0001900-01-01 00:10:00.0001900-01-01 03:00:00.0001900-01-01...
SQL-ServerDateTimedatabase
Answer 24 Apr 2013   license: CPOL
select 'DelayTime: The total time of Delaye 00:00:00'
SQL-ServerDateTimedatabase
Answer 23 Apr 2013   license: CPOL
I guess you want to display only the different values in the table and you can use SELECT DISTINCT statement. The DISTINCT keyword can be used to return only different values.SELECT DISTINCT DelaytimeFROM table_name
SQL-Serverdatabase
Answer 23 Apr 2013   license: CPOL
select distinct Delaytime from table_name
SQL-Serverdatabase
Question 23 Apr 2013   license: CPOL
DelayTime:1900-01-01 00:00:00.0001900-01-01 00:00:00.0001900-01-01 00:00:00.0001900-01-01 00:00:00.0001900-01-01 00:00:00.0001900-01-01 00:00:00.0001900-01-01 00:00:00.0001900-01-01 00:00:00.0001900-01-01 00:00:00.0001900-01-01 00:00:00.0001900-01-01...
SQL-Serverdatabase
Question 23 Apr 2013   license: CPOL
I need to add related items to an existing database. I have structure like this:ID int, PKIname nvarchar(80)...Can i add anoter column and store related item ID or what is the best way to implement related items? Sometimes i need to add more than one related item. Please help
SQL-Serverdatabase
Page 1 of 48
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


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