Browse by Tags

Home ›

All Tags » Data » "T-SQL" (RSS)

Upload Excel File to SQL Server 2005 and Retrieve as link

I want users to be able to upload an Excel file using the ASP.NET File Upload Control, have the file saved into a database table (which I have not created yet), and later on, based on an ID assigned to the file, retrieve it as a hyper link that when they click on it will open the file for them. I have...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bfancett on 12-19-2008, 12:00 AM
Filed under: slq 2005, Slq Server, SQL, SQL 2005 SQL, Sql 2005 .NET, SQL 2005 ASP.NET, SQL Database design, SQL Server 2005, SQLL Serverr DTS, SQLServer, sqlserver 2005, SQLServer 2005SP2, sqLserver2005, sqlserverver, System.Array, varbinary, Visual Studio 2008, Visual Studio 2008 SP1, Web Project, "T-SQL", .NET 2.0, 2005, 2008, ADO.NET, asp.net 3.5, binary data, BLOB, c#, C# SQL, complex, convert, Data, data Acces, data access, data source, data storage, Database, DTS, DTS package, File Upload, files, LINQ Statement, LINQ toSQL, .NET SQL Server 2005, SQL 2005, SQL datatable, SQLServere2005, "SQL Server", .net 3.5, Linq, Store File to database, Stored procedures, ASP.NET C# sql, CSV, cvs, Data Type
Need foreach functionality in Stored Procedure

I have a stored proceudre that brings back 6 columns (PART, FSC, NIIN, NAME, TotalQty, ReqID). After the SELECT statement has run, I need to update one of my tables. In the table that I need to update, there is a column named ReqStatus, and this tables PK is ReqID (from above SELECT statement). Fore...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bfancett on 12-05-2008, 12:00 AM
Filed under: query, query?, slq 2005, Slq Server, SQL, SQL 2005 SQL, sql server, SQL Server 2005, sql server update, sql 2005, SQL Server 2005, Stored procedure sql, Stored Procedure update / insert, stored procedure variables, stored procedure variables WHERE clause, stored proceduredure sql, stored proceduree, Stored procedures, StoredProcedure, StoreProcedure, UPDATE, update column, Update SQL Statement, update statement, "T-SQL", "User Defined Function", 2005, asp.net c# profiles sql server, ASP.NET C# sql, c#, C# SQL, column attributes, column name, column name query, Data, Database, HAVING, "Dynamic SQL", For Each Loops, for loop, queries, SQL 2005, SqL For Each Loops, update records, "SQL Server", .net 3.5, db
Using Case Statement in Where clause for datediff function

I am trying to use a case statement in my where clause to do a datediff so that when my close_date is null it will use getdate() instead of the close_date column. With the code poste below I receive the following error: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '>'. SELECT ...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by cgreene.gsu on 07-18-2008, 12:00 AM
Filed under: slq 2005, SQL, SQL Server 2005, "T-SQL", case datetime, Data, DATEDIFF NULL, datediff sql sql2000 sql2005, DB NULL, getdate() SQL Server 2005, where, "Dynamic SQL", Select * from tablename where column1 = (), .NET SQL Server 2005, date sql, null, "SQL Server", null value column, "ASP.NET and SQL Server"