NO it is not like Home work or some thing else i just hiding my business logic and giving you a simple thing so that you can understand

Try

CREATE TABLE MYTABLE (Name Varchar(60),IPDate DATETIME DEFAULT GETDATE())

INSERT INTO MYTABLE (Name) VALUES('MYName' )

Select * from MYTABLE

you will be getting the date and time when a new record is inserted...

DECLARE @Person TABLE (Status INT,Name Varchar(20))

DECLARE @NumberTbl TABLE (Numbers INT,Status INT)

INSERT INTO @NumberTbl

SELECT 1,2 UNION

SELECT 2,5 UNION

SELECT 3,3 UNION

SELECT 4,0

Select * from @NumberTbl

INSERT INTO @Person...

I am getting this error when i run with my path details

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)"

Hi

If i am Writing 70-431,70-443,70-444 of 2005 what i have to write for 2008.

Whether i have to write 70-431 if i write 2005 for Admin

I want to Wite Admin ...

Hi

This is local developement one thats why planned as weekly to reduce the harddisk size

There is no other way to protect the data other than Backup and Log....

Hi

Actually datas are populated yesterday only i am having the backup on weekly basis thats why i could not able to get the data.

How to find which user has...

Hi

At present i am working with 2005 only having more Knowledge on Admin(DBA) than Developer so i would first go in DBA.

Whether i have to update 2005 to 2008 (in...

Hi thanks

I am asking this because in a table i am having the same record and i am returning the value from that table If it...

First you create a temp table as you said there are 5000 records.

Generate 5000 records

SET NOCOUNT ON

CREATE Table #Temp (RID INT)

CREATE Table #YourTable (ID INT)

DECLARE @I INT

SET @I=1

WHILE...

Hi

Even though if we use Trigger is it is possible to get the data who inserted/deleted from which machine(PC) you have to use only SQL no...

433--Could not find CHECK constraint for '%.*ls', although the table is flagged as having one.

8433--The message body may not be NULL. A zero-length UNICODE or binary string is allowed.

Hi

Try this

SET @FromTIME ='2009-12-01 13:01:00'

SET @ToTime = '2009-12-01 13:59:00'

select @a= min(FTIME),@b=max(TTIME) from @TEMP

select @a,@b,@FromTIME,@ToTime

select case

when...

lmu92 (12/2/2009)

---

You could declare two variables holding min and max time

declare @a datetime,

@b-2 datetime

select @a= min(FTIME),@b=max(TTIME) from @TEMP

select case

when...

coffeejs (11/28/2009)

---

Hi everyone,

I'm trying to compare two tables and figure out which column for a specific record changed.

Here's an example:

Let's say farmer Joe uses a database to...