Hello, How can i have sql 7.0 automatically assign a datestamp (or time & date stamp) to a field in a table when data is added to the row?? also assuming that this can be done, does the datest...
Hi
I am trying to set up a job on SQL server, however I am getting the message 'Could not find stored procedure master.dbo.xp_regread' when trying to create a new job.
Can anyone advise ...
What is working in a CLUSTERED environment? Or CLUSTERING? Where can I learn this?
I'm trying to duplicate a record which is fine, but i want to hardcode one of the new field values rather th. Here's the code which isn't working:
Set NoCount On
INSERT INTO myTbl (val1, ...
hi all
i have a field which is stored as a varchar(30). I need it as varchar as the value can be characters or numbers etc.
in some case i need to add two of these fields when the tex...
Hi all,
Im desperately trying to convert a hex value into either an int or big int.
The snag is that the hex number is bulk inserted and the sourcefile does not stipulate 0x infront of t...
I know that SQL Server does not support CrossTab queries
What I dont know is how to get around it.
Here is the SQL I need to convert.
TRANSFORM Count(vw_POS_LOC_DFLT_REM.PM_EmpAssigne...
Hello everyone,
I've got a little problem with the Full-Text Search (MSSearch).
If I try to create a ft-catalog trough Enterprise Manager, nothing happens - it populates and populates - no...
Dear All,
We can use following command in Oracle SQL:
CREATE TABLE tblA SELECT * FROM tblB WHERE 1=2
Using above statement, we can copy a table structure in Oracle. But we can't run the...
I have a SQL database and I store all the information on that. I want this database to be accessed from pocket pc's. For this reason I had to convert all my database to a *.sdf file format so ...
I have a re acurring problem with a Sql 2000 database, for some unknown reason the temp database explodes and fills up the disk, subsequently on the same partition the user database backup fai...
HMMM...weird thing happened....now after converting that field to a smalldatetime...when I open the search form I get this error:
[Microsoft][ODBC SQL Server Driver]String data, right trunc...
Review the following query:
SELECT [TBL_FIRM INFO].[FIRM NAME], [TBL_FIRM INFO].FADDRESS, IIf(IsNull([fcity]),Null,[fcity] & ", ") & IIf(IsNull([fstate]),Null,[fstate] & " ") & [fzip] AS CS...
Okay here is goes.
I am developing a web site with dreamweaver MX. Last week I was playing around with Stored Procedures in SQL. I created a stored Procedure to update a table called Product_...
Hello,
Is there any difference between these two select commands?
(from the sample 'Pubs' database in MS SQL Server 2000)
----------------------------------------------------------
s...
Hi Experts,
I did a strore procedure that fetch the date from another timezone.
The only problem for it work is that another simple store procedure that return the getdate() as an output...
my situation is simple.
i have a database table in sql server 2000. this table has some image data (Id, fileName, Width, Height)
i would like to create a select statment that would return...
Hi all.
Can anybody please help I am having trouble selecting distinct days from a datetime field.
I can do it in access ie.
SELECT DISTINCT Format([fldLogTime],"dd/mm/yyyy") AS [Date] FRO...
Using T-SQL how can a date field (mm/dd/yyyy) be converted to a Julian Day Number?
I have made a project using VB and it's DataEnvironment
when I setup my package in some computer, the .exe file returns an error:
"The given type name was unrecognized"
while running ...
Thank you for your input at
http://www.experts-exchange.com/jsp/qManageQuestion.jsp?qid=20268887
Thank you for your input at
http://www.experts-exchange.com/jsp/qManageQuestion.jsp?qid=20268887
Hi all,
I am awarding pretty decent point because I have multiple questions. Since, I am not a SQL guy some questions maybe too basic to all experts out there.
I restored a database (db1...
When I import from Access creating a new sql table Access creates a column typed 'ntext' for fields that had been Memo in Access. My ASP pages refuse (no errors...just no data) to output ntext...
Hi experts,
I understand that 'sp_attach_single_file_db' can automatically create a new log file, if it can't find one. But, what I have observed is it always creating the log file in the s...
