Click here to Skip to main content
15,847,427 members
Home / Discussions / Database
   

Database

 
GeneralRe: user acces spermissions Pin
ranjjj6-Nov-03 18:36
ranjjj6-Nov-03 18:36 
GeneralRe: user acces spermissions Pin
perlmunger7-Nov-03 6:38
perlmunger7-Nov-03 6:38 
GeneralProblem in using OleDbDataReader Pin
sivaramakrishna5-Nov-03 23:14
sivaramakrishna5-Nov-03 23:14 
GeneralRe: Problem in using OleDbDataReader Pin
Mike Dimmick6-Nov-03 3:32
Mike Dimmick6-Nov-03 3:32 
GeneralRe: Problem in using OleDbDataReader Pin
sivaramakrishna7-Nov-03 20:06
sivaramakrishna7-Nov-03 20:06 
Generaldbo Pin
Hugo Hallman5-Nov-03 13:19
Hugo Hallman5-Nov-03 13:19 
GeneralSQL! Pin
Silly Boy5-Nov-03 7:18
Silly Boy5-Nov-03 7:18 
GeneralRe: SQL! Pin
Jeff Varszegi5-Nov-03 8:34
professionalJeff Varszegi5-Nov-03 8:34 
You can't do this in SQL Server, at least with Transact-SQL. Here's a test I just ran:
CREATE TABLE #test (
   dt DATETIME NULL
)

INSERT INTO #test VALUES ('2003-01-01')
INSERT INTO #test VALUES (#2003-01-01#)


On the second value, I get this error:
Server: Msg 128, Level 15, State 1, Line 1
The name '#2003' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.


What language and database are you using?

Thank you.

Jeff Varszegi
GeneralRe: SQL! Pin
andyharman5-Nov-03 12:49
professionalandyharman5-Nov-03 12:49 
GeneralEncoding problem using ADO Stream Pin
Firas Rashid4-Nov-03 3:59
Firas Rashid4-Nov-03 3:59 
GeneralAlternative SQL Queries based on Table Data Pin
Jo Fredrickson3-Nov-03 22:58
Jo Fredrickson3-Nov-03 22:58 
GeneralRe: Alternative SQL Queries based on Table Data Pin
andyharman5-Nov-03 12:35
professionalandyharman5-Nov-03 12:35 
GeneralRe: Alternative SQL Queries based on Table Data Pin
Jo Fredrickson5-Nov-03 15:59
Jo Fredrickson5-Nov-03 15:59 
GeneralMSADO 2.5 Pin
Kant3-Nov-03 16:46
Kant3-Nov-03 16:46 
GeneralRe: MSADO 2.5 Pin
Mike Dimmick5-Nov-03 2:51
Mike Dimmick5-Nov-03 2:51 
GeneralRe: MSADO 2.5 Pin
Kant5-Nov-03 6:01
Kant5-Nov-03 6:01 
GeneralFULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 13:53
devvvy3-Nov-03 13:53 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
Jeff Varszegi3-Nov-03 15:28
professionalJeff Varszegi3-Nov-03 15:28 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 15:30
devvvy3-Nov-03 15:30 
GeneralTrouble Running Sql Script from Code Pin
perlmunger3-Nov-03 12:42
perlmunger3-Nov-03 12:42 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi3-Nov-03 15:54
professionalJeff Varszegi3-Nov-03 15:54 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 4:58
perlmunger4-Nov-03 4:58 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 5:03
professionalJeff Varszegi4-Nov-03 5:03 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 5:54
perlmunger4-Nov-03 5:54 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 6:38
professionalJeff Varszegi4-Nov-03 6:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.