Alter Query

To add a column in a table, use Alter Query the following syntax: ALTER TABLE table_name ADD column_name datatype. To delete a column in a table, use the following syntax (notice that some database systems don't allow deleting a column) ALTER TABLE table_name DROP COLUMN column_name. To change the data type of a column in a table, use the following...

Read More

CHECK WHETHER DUPLICATE EATERY IF((SELECT COUNT(*) FROM TableName WHERE ColumnName=@ColumnName AND ColumnName1=@ColumnName1) > 0) BEGIN     SELECT '! Exit' return END  ELSE SELECT '! Not Exit'   Write this code then we can't face duplicate ent...

Read More

The INSERT INTO statement is used to insert new records in a table. Syntax:-   INSERT INTO table_name (column1,column2,column3,...)  VALUES (value1,value2,value3,...);  The DELETE statement is used to DELETE  records in a table. Syntax:-   DELETE FROM table_name  WHERE some_column=some_value;  The UPDATE ...

Read More

SQL SELECT Query The SELECT statement is used to select data from a database. Query SELECT * FROM TABLE NAME. Use this query we get All data of Table. And we Want to particular data then use Select Column Name Example. SELECT column_name,column_name FROM table_name; &nbs...

Read More

How To Timer Work in Asp.net

Using a Timer Control Inside an UpdatePanel Control When the Timer control is included inside an UpdatePanel control, the Timer control automatically works as a trigger for the UpdatePanel control. You can override this behavior by setting the ChildrenAsTriggers property of the UpdatePanel control to false. For Timer controls inside an UpdatePanel ...

Read More