SQLTeam.com | Weblogs | Forums

Sql server 2008

i have questions can you solve please

  1. how to create database diagrams?

  2. procedures for insert, update, delete and write query for call procedures

  3. how to create a new database in MS SQL SERVER 2008

4)write cursor query/ procedure

  1. write transaction quesry/ procudere

they are very urgent can you plz help me friends

in SSMS, open the database node, right click and select the first item (diagrams)

That's pretty general. but as easy as:

create proc foo as
insert into bar(a,b,c)
select 1,2,3

use EXEC foo to call

in SSMS right-click on databases and select "New Database"

Why? avoid cursors at all costs!

not sure what you mean. transactions are like

BEGIN TRAN
do something
COMMIT