Are you running the query in SQL Server 2005 or somewhere in your C# code?
I ran your code in a query on sql server 2008 and it created the table fine. Your syntax isnt at fault; does the table already exist? are you correctly connected to the sql server instance to run the query?
yes i am connected. All is fine because I already made some tables but when I create a column which has date data type, the date data type is not turning into a blue color, and I believe it means that it's not being recognize as a sql data type
I just tried to run the command in MS SQL Server Management Studio Express (2005). create table tbl (orderdate date)
It does not execute giving the Error:
Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #1: Cannot find data type date.
Also, when I use the table designer the only date related types are DateTime and SmallDateTime.
Is this an SQL Express issue or a 2005 v. 2008 issue?
Use a DateTime and ensure that the time is always set to 00:00:00.
When reading/writing a value use the Date property:
Get myDateTime - SomeValue = myDateTime.Date; Set myDateTime - myDateTime = newDateTime.Date; Set to today - myDateTime = DateTime.Today;
Hi. I have a form with list box : lst_product, datagridview : grd_order and button: btn_addline. lst_product has a list of product ids selected from database (MS Acess 2013) , grd_order is by default empty except for 2 headers and btn_addline adds rows to grd_order.
OK, so HostGator for some reason no longer allows gcc/g++ access unless you have a Designated Server account, which is a lot of money to spend just to compile my "Hello World" program. Thus I figured I'd compile at home, then upload. Program is your regular old bare-bones Hello World ...