Afternoon All,
Does anyone know of a function as such that i can use to add an automatic date and timestamp in a colum for when a user add a record to the database table?
Regards Betty
I have a table.
Employee
---------------------
EmpID EmpName BookID
1 Mark abc
1 Mark xyz
2 chris mno
I want output as
Employee
---------------------
EmpID EmpName BookID
1 Mark abc,xyz
2 chris mno
Any help/Suggestions are greatly appreciat...
Hi everyone I'm having a problem.
I have two SQL queries that are both returning different results:
SELECT name, capacity, $price, licensed, cost
FROM venue, catering WHERE venue.venue_id = catering.venue_id
AND grade=$grade
AND capacity >= $minCapacity
AND capacity <= $maxCapacity
AND...
I'm trying to set up alerts and notifications in SQL Server 2000, but they are not working. I'm testing them for Agent scheduled jobs, and I get a note saying:
NOTE: Failed to notify '[operatorname]' via email.
Then in the Current Error log, I see an entry like:
[264] An attempt was ma...
This is driving me crazy.
I have a function I am trying to debug, but I can't insert into a table, execute a print statement, or even raise an error from it.
SQL returns the message
Invalid use of a side-effecting operator 'PRINT' within a function.
How can I Debug this, I just want to k...
Nothing. They are equivalent.
I have written a SQL script below and i'm having trouble with the speed it takes to run. It is fine until the section 'Update Buys with Sales Data'. It is taking far to long to update the @Results table. Is there any way i can speed this up?
USE [IV7]
GO
/*-------------------------------------...
Since both a Table Scan and a Clustered Index Scan essentially scan all records in the table, why is a Clustered Index Scan supposedly better?
As an example - what's the performance difference between the following when there are many records?:
declare @temp table(
SomeColumn varchar(50)
)
...
Remember this old picture?
What’s that “Blog” circle supposed to be about, you ask? WHERE’S THE BLOGGING?
Since Stack Overflow launched, we’ve been trying to explain that it’s not just a Q&A platform: it’s also a place where you can publish things that you’ve learned: recipes, FAQs, HOWTOs, walkthroughs, and even bits of product documentation, as long you format it as a question and answer.
As Jeff wrote:
if you have a question that you already know the answer to …
Using SQL Server 2012, I have a table with 7 million rows. PK column is a GUID (COMB GUID). I am trying to test the performance of a query and first need to update a random sampling of data, I want to change a column value (not the PK) of 50,000 rows.
Selecting Top 50,000 Order by NEWID() takes...
