Dear My Friends,I have a question... If i use the following syntax...SELECT * FROM TableName WHERE LEFT(Field,3)The result is 'J10' for all records....
Hello My Friends, I want to know the SQL Syntax to find the duplicate value in one field of Table. Anybody can help me...? Thank you.
Hello My Friends, I have a field with data type is INT (YES NOT FOR REPLICATION). This field is PrimaryKey. Right now, it almost the end of the...
Hello My Friends, I'm a new member in TechRepublic. I have a question, about SQL Script. I'm Using SQL Server 2008. I have one table, contain 3...
Dear My Friends, I have a question... I just assign a backup schedule to one of database in my server... How can i remove the schedule from the...
Hello My Friends, I'm newbie in SQL... [:P] I have one database, the size of MDF file is only 21 MB. But The LDF File is almost 200 MB. Why...? Is...
Hello My Friends, I have a question about manual backup of sql server 2K database. I have a database. Some users connect to the database via an...
Dear My Friends, I have a question about backup database. i have been create a database and running for more than one month. Suddenly, i have to...
Dear My Friends, I have a question... How many field in table can be inserted? I using Microsoft SQL Server 2000 Thanks & Regards, Fauzan
Dear All, I have a question about digit on decimal number in Microsoft SQL Server 2000. I creating an application. If i input 0.956 from the...
Separate names with a comma.