SQLTeam.com | Weblogs | Forums

Sql server 2008


#1

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


#2

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