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*
  
13,939 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


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

Tag filtered by:  SQL [x]
Question 13 May 2013   license: CPOL
My web application is not working properly on proxy server.Please help me!
ASP.NETSQL
Article 13 May 2013   license: CPOL
NY Trivia Quiz w/backend Database migration to Azure cloud
ASP.NETSQLC#C#4.0jQueryAzureCloudCSS3HTML5
Article 13 May 2013   license: CPOL
SQL Server 2000, 2005, 2008, 2008 R2, 2012 Character String Data Types and Functions with Sample SQL Statements. Quick reference, Data Type Tables, Function Tables
SQL2000SQL2005SQLSQL-ServerDBADevBeginnerIntermediateSQL-ServerSQL2008, +
Article 13 May 2013   license: CPOL
An obscured communication protocol based on color and textured shapes.
C#JavascriptSQL.NETIntermediate.NETMVCjQueryAppFabricAzure, +
Answer 13 May 2013   license: CPOL
Hey Kwesi, the "Logical" in FoxPro is a "bit" in SQL.See here[^]
ASPSQL
Question 13 May 2013   license: CPOL
I have a FoxPro Database print out sheet of the database Table Definition. I am making that same table in asp.net using the SQL table. On the FoxPro Table I have:Field: 1 FieldName: NoticeType:LogicalWidth:1My question is:What can I use in place of...
ASPSQL
Answer 13 May 2013   license: CPOL
If you type "ORA-06550" in google (or any other ORA error) you'll get the explanation. In this case, not much of help as it seems to be a generic error. My guess is that it might be because you add prm3 twice (not sure though): //btw is "paramters" a typ-o ? ...
.NET1.0.NET1.1SQL2005C#ASPASP.NETSQL.NET.NETSQL-Server, +
Question 13 May 2013   license: CPOL
In my code am getting following error.ORA-06550: line 1, column 7:PLS-00306: wrong number or types of arguments in call to 'SAVE_DATA'ORA-06550: line 1, column 7:PL/SQL: Statement ignoredWhat will be the reason for this?code am using is, List listparamters =...
.NET1.0.NET1.1SQL2005C#ASPASP.NETSQL.NET.NETSQL-Server, +
Article 13 May 2013   license: Ms-PL
How to take an existing Windows 8 and Windows Phone 8 Modern app and extend it to the web.
C#JavascriptSQL.NETCloud
Answer 13 May 2013   license: CPOL
You need to set up the new column with identity(1,1), temporarily disable the auto-generate while you populate it with the data from the old DB, and then going forward it should work ...Have a look at SET IDENTITY_INSERT[^] to get you started
SQL
Question 12 May 2013   license: CPOL
Hi everyone , I am working on a database merging concept in this i am having many of the table column identity (1,1) . Now my problem is while merging the old DB the Id starts from number but not from beginning its then identity seeding by 1 . Now i have create a new table in new DB...
SQL
Article 12 May 2013   license: CPOL
Implementation of relative database constraints and permissioning using triggers and shadow tables
SQLSQL-Serverdatabase
Article 12 May 2013   license: CPOL
Create a simple cms project starting with bootstrap based layout
C#ASP.NETJavascriptCSSSQLWindows.NETVisual-StudioHTMLDev, +
Article 12 May 2013   license: CPOL
Umbrazure streamlines development and hosting ASP.NET websites atop Umbraco 6 on Azure.
C#ASP.NETSQLAdvancedMVCAzureCloudCMSumbraco
Answer 12 May 2013   license: CPOL
Have you tried using Skip() and Take() methods ?Skip(n) will jump the n number of records and Take(n) will return n many records.for example you could tryvar subjects = db .Subjects .Where(s=> s.subjectNoted == false) .OrderBy(s=> s.idSubject) .Skip(1) ...
C#SQLADO.NET
Question 12 May 2013   license: CPOL
Hello, i m doing a c# project with ADO .NET data entity model, i have a table Subjects with columns (idSubject(int), nameSubject(nvarchar), subjectNoted(bit/boolean). I'm getting from the table the first subject that have `subjectNoted==false` then i change the value to `==true` after clickin a...
C#SQLADO.NET
Answer 12 May 2013   license: CPOL
You need to define stored procedure[^].CREATE PROCEDURE GetNthUserByStatus @stat INT, @nth INTASBEGINSELECT idUser, nameUser, statusUserFROM ( SELECT idUser, nameUser, statusUser, ROW_NUMBER() OVER(ORDER BY idUser) AS RowNo FROM [Users] WHERE statusUser =...
C#SQLADO.NET
Question 12 May 2013   license: CPOL
I'm developping an application with C# and ADO.Net entity data model. I have a table Users in SQL Server database with 3 columns (idUser, nameUser, statusUser). How can i retrieve the second or the third or the Nth user of the table that have statusUser == 0?
C#SQLADO.NET
Answer 12 May 2013   license: CPOL
If you want the 2nd record, how about this....SELECT TOP 1 *FROM myTableWHERE ID NOT IN ( SELECT TOP 1 ID FROM myTable ORDER BY ID )ORDER BY ID
C#SQLADO.NET
Article 12 May 2013   license: CPOL
.NET Framework Cultures with Culture Specific Formats and Mapping with SQL Server Language. CultureInfo, DateFormat, Number Format, Currency Format, Percent Format, Infinity Format etc.
.NET1.0.NET2.0.NET3.0.NET3.5C#VBSQL.NETDevBeginner, +
Question 12 May 2013   license: CPOL
I'm developping an application with c# and ADO .NET entity data model. I have a table Articles(idArticle, nameArticle, statusArticles). I want to retrieve the first article where statusArticle=false, and update her value to true. Someone can help me with this code please: private void...
C#SQLADO.NET
Answer 12 May 2013   license: CPOL
My mistake. I should have used."Select count(*) from [users] where [userid]=@uid and [password]=@pword"since I used Convert.ToInt32(cmd.ExecuteScalar())>= 1 which requires numeric result.1, 2 and 3 worked after I fixed my error in my select query.
SQLVBselectionVB.NETParameterquery
Question 12 May 2013   license: CPOL
Hi I'm new to vb.net.I'm having error input string is not in the correct format. I already used different codes for adding a parameter in sql select query.I would like to ask what is the best way of adding a parameter in a VB.net select query?Thanks in advance. Dim strsql As String...
SQLVBselectionVB.NETParameterquery
Answer 11 May 2013   license: CPOL
here is the code:using (YourDatabaseContext context = new YourDatabaseContext()){ User firstUser = context.Users.FirstOrDefault(u => u.statusUser == 0); if (firstUser != null) { lblUserName.Text = firstUser.nameUser; }}
C#SQLADO.NET
Question 11 May 2013   license: CPOL
i'm developping an application with ADO .Net entity data model, i have a table Users, with 3 columns (idUser, nameUser, statusUser), from an sql db. What is the code to, select the first user of the table that have (statusUser = 0), and show her name in a label?
C#SQLADO.NET
Article 11 May 2013   license: CPOL
Learn how to get started in Windows Azure by following the progress of an actual web application as it is constructed.
C#ASP.NETSQLMVCAzure
Answer 11 May 2013   license: CPOL
BIDS is only provided with the (not free) Standard, Enterprise and Developer Editions.Refer: SQL Server Highlights[^]
SQL
Question 11 May 2013   license: CPOL
Hi I want to get some training on SSIS,SSRS,SSAS and therefore I want to install SQL Server Business Intelligence Development Studio. How to get SQL Server Business Intelligence Development Studio installed into my machine freely to home computer?I have vista OS with X86 based PC.
SQL
Answer 10 May 2013   license: CPOL
Hi try this,CAST(@your_param AS nvarchar(15))
SQL
Tip/Trick 10 May 2013   license: CPOL
SQLBeginnerIntermediate
Answer 10 May 2013   license: CPOL
You can do it by using 3rd party tools such as ApexSQL Restore[^] or SQL Virtual Restore[^] You can read and extract data from virtual database made from backup file and work vith virtual database like it is live database.
C#SQLServer
Question 10 May 2013   license: CPOL
What is the quickest way to save SQL Server table data to a file and import to existing table with same name and structure?
SQLTables
Article 10 May 2013   license: CPOL
Simple survey web app using the latest Microsoft technologies.
ASP.NETSQLHTMLDevIntermediateC#.NETC#4.0AzureCloud, +
Tip/Trick 10 May 2013   license: CPOL
List out reports from Reprting Server.
SQLReports
Answer 10 May 2013   license: CPOL
There is no simple way to achieve that, because of lot of reasons, for example:1) route summary is stored as a text2) route points are duplicated (for example C).See below example (read comments)--declare master tableDECLARE @Ops_Route_Master TABLE (RouteId varchar(15),...
SQLStoredprocedure
Answer 10 May 2013   license: CPOL
Something like this should work (adding text as parameter): private void testToolStripMenuItem_Click(object sender, EventArgs e) { string text = @"This text ""contains"" double quotes"; InsertText(text); } private void...
C#SQL
Question 10 May 2013   license: CPOL
i need to insert text like "sometext" . here double quotes also need to insert when i enter the text in text box
C#SQL
Answer 9 May 2013   license: CPOL
It is possibly related to optimiser behaviour,that is why we have decided to use another view to get faster results.
SQLview
Question 9 May 2013   license: CPOL
heyy..I have use SSRS report .. IN that I want to sum of first fields in a group(collection date) .. I wrote a expression but it doesn't work ( got error)....here is:1. =sum(first(Fields!Amount.Value).ToString())2. =sum(first(Fields!Amount.Value),"collection date")IS any...
ASP.NETSQLSSRSReports
Answer 9 May 2013   license: CPOL
Try this...1.select x,y,z from view1 WITH (Index(Index_x)) where x in (select x from table1 WITH (Index(Index_y)) where y='1234')2.select x,y,z from view1where exists (select * from table1 where y='1234' and table1.x=view1.x)Happy Coding!:)
SQLview
Answer 9 May 2013   license: CPOL
This SQL should work for you.select x,y,z from view1 inner join table1 on ((view1.x = table1.x) and (table1.y='1234'))
SQLview
Question 9 May 2013   license: CPOL
We have a view table and selecting from view is normally taking too much time. for example: select x,y,z from view1 is taking too much time to load. This one is ok.if you query:select x,y,z from view1 where x in ('abc') queries in seconds.if you query:select x,y,z from view1 where x in...
SQLview
Answer 9 May 2013   license: CPOL
change set @sql ='update MedicalListMedicationType set MedicationType = #tempTable.Name WHERE MedicationType_ID = #tempTable.Id left outer join #tempTable on #tempTable.Id= MedicationType_ID'withset @sql ='update mt set mt.MedicationType = #tempTable.Namefrom MedicalListMedicationType...
SQL
Question 9 May 2013   license: CPOL
create table #tempTable (Id varchar(200), Name nchar(100) ) DECLARE @bulkinsert NVARCHAR(2000)declare @paths nvarchar(3000) Set @paths ='D:\ftp\PAYH\MedicationTypeInfo.csv'SET @bulkinsert = N'BULK INSERT #tempTable FROM ''' + @paths + N'''...
SQL
Technical Blog 9 May 2013   license: Apache
Random notes on MDX filtering
SQL
Answer 9 May 2013   license: CPOL
Its the sequence of the statements nothing else!
ASP.NETSQLSQL-ServerVisual-StudioVS2010
Answer 9 May 2013   license: CPOL
What is the error? Try catching an exception rather than just "Bad". That is meaningless. Also, you could step through the code and see where it jumps to the catch.Actually, it kinda looks like you may have to specify the columns like insert into leaevcover (col1, col2, etc) values...
ASP.NETSQLSQL-ServerVisual-StudioVS2010
Article 9 May 2013   license: CPOL
Time to automate the sign-in and sign-out process at the pre-school. Get it online, real-time and in the cloud
C#ASP.NETSQL.NETSQL-ServerMobileArchitectDevIntermediateC#, +
Question 9 May 2013   license: CPOL
I have project that reads incoming emails. For each email coming in I create a new thread to process the conversation. Part of the thread is writing to a database table. In testing, it seems to fail every so often and the EXECUTE line citing Multi-step issues, but I cannot reproduce it easily,...
SQLADO.NETVBVB.NET
Answer 9 May 2013   license: CPOL
Try this:SELECT t1.username, t2.attributeFROM userAttributes AS t1 INNER JOIN Attributes AS t2 ON t1.attrFK = t2.attrIDWHERE t1.username = @username[EDIT #1 - missing attributes]SELECT attribute AS MissingAttributeFROM Attributes WHERE attrID NOT IN ( SELECT t2.attrFK AS...
SQL
Page 1 of 279
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


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