Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pal.subnhamoy
Starting Member
2 Posts |
 Posted - 2009-01-30 : 01:09:00
|
| For a particular project on SQl server, i need to modularize the entire funtionalities in a structured format (like DDL, DML, SELECT, STORED PROC, PL/SQL BLOCK etc..).What else can be included here. I have some ideas like 1.Different Data types 2.Transaction management 3.Any supported Utilities 4.SET commands (if available) 5.SHOW (if available) Please help. |
|
|
Raibeart
Starting Member
8 Posts |
Posted - 2009-01-30 : 10:46:24
|
| It is going to be tough to do pl/sql in SQL server.What is the purpose of doing what you are trying to do? |
 |
|
|
oldmanben
Starting Member
3 Posts |
Posted - 2009-01-31 : 13:13:49
|
| Hi,In SQL Server you will need to use TSQL. While SQL Server is progressively getting more and more compliant with ANSI SQL Standard both Oracle and SQL server have unique (and inconsistent with each other) language features. I don't want to engage in flame wars as to which language/product is better or more compliant. But if you want to do what you mentioned you have to dance with the girl that bought you i.e. if you are working in SQL Server you have to use TSQL. You can do everything you mentioned in TSQL. I don't remember what show does in PL/SQL but it is probably very different in SQL Server. You may mean print.old man ben |
|
|
|
|
|
|
Modularizing SQL functionalities