I am importing images names from a file into a database by using the code below. When I import the image names, I aslo want to add a date of "June 12, 2009" in the DATE column. Finally, I do not want to import any duplicates. Is there something I can change in this code to make that happen?
declare @cmd varchar(1000)
set @cmd = 'dir "D:imagesREVIVE" /b'
if (object_id('ImageTable..tblimages') is not null)
begin
insert into tblimages (imgname)
execute xp_cmdshell @cmd
delete e
from tblimages e
where ISNULL(e.imgname, '') = ''
select *
from tblimages
end
else
create table tblimages ([id] int identity(1,1), imgname varchar(1000))
insert into tblimages (imgname)
execute xp_cmdshell @cmd
delete e
from tblimages e
where ISNULL(e.imgname, '') = ''
select *
from tblimages
I have a simple asp.net web forms page that does an insert to my sql server db. My server was running slow at the time and I pressed Insert button several times because I didn't think it took but it did all 3 times.So I have duplicates from that one interaction. How would I prevent this?
et me know which control is used to insert date of birth in to sql server database and it saved in which format(as date or datetime).If it is datetime then how to convert as date.
I have got the following exception when try to select data from SQL Server or inserting data in in with a C# windows application. I am passing the date in where clause of select query in single quotes like this '16/03/2011' The exception message is shown below:
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Is there any perfect solution for inserting and selecting date from sqlserver database irrelevant to the operating system. i.e. that works on both Italian and English OS.
I am selecting the date field in the 'dd-mm-yyyy' format by using SQL Codes(103,105...).While inserting I want the userto insert the date in same format(dd-mm-yyyy) but it will not happening as in SQL Server we need to insert the date in'mm-dd-yyyy' format.Pls send me insertion query in sql to achieve this.Pls respond me ASAP.
I want to read date field from Excel sheet and insert it into SQL Server2005.When I read date field it gives me a number say '40160' when the date feild is "08/01/2010"
How should to Read a date field from Excel Sheet Cells?
I have some issues about retrieveing and storing date information to my database (ms sql server 2005).My data column is a DateTime, and i have set my web.config globalization culture is set to "en-gb"
When i retrieve date from the datebase it appears as dd/MM/yy, that's fine. But i cannot insert a new date as same format?! It will only accept MM/dd/yy or yy/mm/dd.Right now i'm using this code to correct the error:
[Code]....
Is it possible to change the date format on the database or something, so i dont need to use this code?
I am writing code to insert values from an xml file. I check for a duplicate before inserting and delete if there is a match. Is there a more effecient way to prevent duplicates before insert a record? my code: private void LoadFData() { SqlConnection oConn = new SqlConnection(ConnectionString); SqlCommand oCommand = new SqlCommand(); oCommand.Connection = oConn; oCommand.CommandType = CommandType.Text; oConn.Open(); // Load committee master files string[] strFiles = System.IO.Directory.GetFiles("fff", "ffff.dta", System.IO.SearchOption.AllDirectories); for (int i=0; i
How to create Jobs, I am using SQL 2005, i need a query which should get current date and compare current date with date in table and Send Email according to Job scheduled.
How to get the date at which a record is created in SQL?..i.e, if i add a record to a database table db1 at 8/10/2010 11:30, I want to get the datetime, i.e 8/10/2010 11:30..;.Also let me know how to compare datetime values..
if(8/10/2010 11:30 >8/10/2010 10:30) will work or not?
but if there were no "hits" for a particular date range in the last week i only get the dates returned where there were hits. i need to get all the days returned and where there were no results, i need a zero returned.
I am storing date data in sql server as varchar but I want to make comaparisons on this field in where clause- like this field from 2 days before or after etc
have a table with a transaction date in it. It is set as a timestamp and basically I want on creation of a new record that field automatically inserts the current date. I am using visual studio 2010 and ASP.net SQL not sure how to go about it. Dont need SQL injection protection for this just a simple way of doing it.
i need to insert multiple rows at a time into database table(sqlserver) from datatable or gridview. Actually iam looping through the rows of gridview and inserting each row. Is there any method to insert entire table of rows at a time into database table. Both datatable columns and database table coulmns are similar.
I have a simple form, it gets the date and allows a user to input a 6 digit number. The user then clicks a button, the page needs to take the date and apend the 6 digit number and insert it into a SQL database. So:
1/26/2010 Text Input is : 123456
It appends both, so it would get: 1/26/2010-123456 Then with the button click, it inserts that data into a field in a table. Here is the page (with C# CodeBehind)
I am trying to insert a new record via a SPROC in sql . In my date columns I check for nulls being passed to the SPROC this way Dim BirthDateParam As SqlParameter = New SqlParameter("@DOB", SqlDbType.DateTime) If estateRec.BirthDate Is Nothing Then BirthDateParam.Value = DBNull.Value InsertCommand.Parameters.Add(BirthDateParam) Else BirthDateParam.Value = estateRec.BirthDate InsertCommand.Parameters.Add(BirthDateParam) End If But I am getting an overflow error message about dates, SQL Stack Overflow Isn't this way correct
is there ny data type of date which can hold the date only.....coz i have a field of date in which i have write date manually... i have taken the datatype as DateTime.... and its showing "incorrect datetime value"..
I need to run a simple query to insert a record to sql server that has a date time value.My UI gets the user input parses it to a DateTime variable and sends it to BLL. BLL creates an entity and send it to DAL and DAL calls a stored procedure that runs the insert statement.During this transaction the variable is of type DateTime and I keep getting a sqlDateTime overflow exception.What is the best way to handle date time values?