Jump to content

Raj Ali

Members
  • Posts

    8
  • Joined

  • Last visited

Raj Ali's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. Raj Ali

    SQL triggers

    create trigger trigger_name on table table_namefor{[update][,][delete][,][insert]}[WITH ENCRYPTION]as sql_statementwhere trigger_name: names The triggertable:names of tables on which tge trigger has to be executedWith Encryption: Prevents other users from viewing the text of the trigger[update][,][delete][,][insert]: Keywords that specify the statements that will invoke the triggerSql_statement:Transact_SQL statements to be executed when the trigger is invokedIf You need Any other other help in triggers you can mail me
  2. hi Every oneI have a table name Employee in which i want to make a column name moblie No.now i want to make a user defined data type in sql through query for column moblie No.now how can i make a user defined data type that it begins with 0......... can any one Help me??????????????
  3. If ur view is based on a single table than it is possible to update o insert into it.Likeinsert into<view_name>values(<column1value>,<column2value>........)update <view_name> set column_name=required condition where column_name=conditionand if view is based on the data which comes from multiple tables than it is not possible to update or insert into it.
  4. if u want to chose top 8 rows which are recently entered then u useselect top8<column_name>from <table_name>or if u want randomly rows from table then u useselect*from <table_name>
  5. Raj Ali

    about sql query

    You use the querySelect top 5 salary from <table name>
  6. Raj Ali

    Sql

    I make a view which gets data from multiple tables through query in SQLNow i want to modify or update values in that view through queryAny one can tell me that how i add or change values in that view which contains data from multiple tables
  7. Raj Ali

    creating Pointer

    my question is about sqlhow i create a pointer in sql by writing query?????Any one knows than tell me Thanx
  8. Sir, How to make a user defined data types by query in sql Thanx Raj Ali
×
×
  • Create New...