Please check this...

SELECT CONVERT(VARCHAR(11), subscription_date, 106) AS [DD MON YYYY]

Are you looking for this kind of stuff???

http://mssqltipsandtricks.blogspot.in/2012/08/how-to-schedule-auto.html

This is good and easy to understand.

If you want for all tables, just remove the last 'where' clause in the above query. It will give for all the tables in the database.

SELECT f.name AS ForeignKey,

SCHEMA_NAME(f.SCHEMA_ID) SchemaName,

OBJECT_NAME(f.parent_object_id) AS TableName,

COL_NAME(fc.parent_object_id,fc.parent_column_id) AS ColumnName,

SCHEMA_NAME(o.SCHEMA_ID) ReferenceSchemaName,

OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,

COL_NAME(fc.referenced_object_id,fc.referenced_column_id) AS ReferenceColumnName

FROM sys.foreign_keys AS f

INNER JOIN sys.foreign_key_columns AS fc ON f.OBJECT_ID = fc.constraint_object_id

INNER JOIN sys.objects AS o...

Check This.. I am not sure whether you meant the same or not.

Declare @testtable TABLE (MicroTestID INT,TestDate DateTime,Item CHAR(3),CIPType CHAR(10))

Declare @testtable1 TABLE (ID int,MicroTestID INT,TestDate DateTime,Item CHAR(3),CIPType CHAR(10),sequence int)

INSERT INTO...

declare @testtable table (name varchar(25), name1 varchar(max),rate decimal(10,2),Amount int,status varchar(25))

declare @testtable1 table (id int, date1 varchar(max))

declare @date1 varchar(max)

declare @i int =1

insert into @testtable values('Our Corp','Their Company',1.26,100000,'Cleared')

insert into @testtable values('Our Corp','Their...

Pls chk this code...

declare @testtable table (id int, date varchar(max))

declare @testtable1 table (id int, date1 varchar(max))

declare @date1 varchar(max)

declare @i int =1

insert into @testtable values(1,'2011-09-08,2012-09-07')

insert into @testtable values(2,'2011-05-07,2012-07-10,2012-03-14')

insert into @testtable values(3,'2011-12-09,2012-03-14')

insert...

Select distinct F.Facility,Count(ReportedItem) AS [No.of.Items] from Facility F

LEFT OUTER JOIN on ReportItems R

F.Facility = R.Facility

Group By F.Facility

This should work fine

declare @test-2 varchar(10)

set @test-2='A1234'

Select STUFF(@test,4,0,'.')

DECLARE @fullTextString VARCHAR(MAX)

SET @fullTextString = 'application' + CHAR(39) + 's'

SELECT * FROM table_name WHERE CONTAINS(*, @fullTextString)

It won't work. AS I am using exact match. In which, search word should be...

This won't work for us.

Why I am using " " , means search for exact match in the table.

The given example is working fine. But using contains in full text its not giving me the right answer

I have changed the query as below.

SELECT * FROM table_name WHERE CONTAINS(*,...

Just suppose I have table columns like this

1 Application

2 Application's

3 Foreign Application

4 Application's effect

So, if I am running query SELECT * FROM table_name WHERE CONTAINS(*, ' "Application''s" ')

I am putting...

[font="Arial"]Its showing both Application with IDs 3 & 4. I want exact match for apostrophe.[/font]

Please check the summary.txt file which will give the details about the installation of SQL Server. The location is C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG. You will get more details from...