Thanks To Participles

According My Need I have a complaint table.

when a new record insert in this table then we want to send message to all user which is using my...

thanks to all for participates

according to my need.

i have a compliant table in my CRM Database.

when a new complaint insert in table . then we want to notify all users...

Thanks

u are right

but we don't want to send mail to all user.

i want to pass a message in message box and want to display on screen of all systems in...

thanks for reply

i using window application develop in .net.

when a row insert in a table.

then we want to provide alert message of all user which is using my application.

in...

In Case Of Insert You do not have old price of product.when you update a record then u can get old and new price

Use Two Condtion With AND LIKE

WHERE table1.UserID = table2.UserID AND table1.PostID= table2.PostID

try like this

System.Data.SqlTypes.SqlDateTime sqlDateTime = new System.Data.SqlTypes.SqlDateTime(System.DateTime.Now);

convert your date to sql date then insert.

Try To Insert Without Convert.

This Database currently in working but we can not take backup.because some file related to full text search (full text catalog) is missing . currently i am not using full...

select partno from table3 where style='34'

intersect

select partno from table3 where stylenumbers='68'

Thanks For All For Participates and Clarify Some Issue.

then you can restore the day 3 diff on top of all without restoring full backup again, but the restriction remains the same the last backup which was restored should...

select adminpermission from appadmin where addId=1

you can add coalesce keyword and take values comma delimited by using a function and can use then .

Can Also Use Top .

It Means Log Backup is The Substitute of Incremental backup In SQL server ?