answersLogoWhite

0

Transact-SQL in an internationally standardised method to create, modify and delete databases and tables, as well as insert, retrieve, modify and delete data stored in a database. With Microsoft SQL Server 2005 you can also author procedures in any managed language such as C# or VB. This is because it is integrated with the CLR which allows you write powerful programs inside stored procedures. All functionality of the .NET Framework BCL (Base Class Library) is available to your stored procedures. This means that developers have access to thousands of pre-built classes and routines which can be accessed. The BCL includes classes that provide functionality for improved string functioning, advanced math operations, file access, cryptography, and more.

User Avatar

Wiki User

17y ago

What else can I help you with?

Related Questions

How do call stored procedure in jsp?

To call a stored procedure in JSP, you typically use JDBC (Java Database Connectivity). First, establish a connection to your database using DriverManager. Then, create a CallableStatement object with the stored procedure's SQL call (e.g., {call procedure_name(?, ?)}) and set any required parameters. Finally, execute the statement using execute() or executeUpdate() and process the results as needed.


What is sql database?

An SQL database is one that implements the use of Structured Query Language to manage data stored in the database. SQL is the most used way of communicating with databases.


Difference between a local procedure and stored procedure?

local procedure wont store in database. Stored procedure store in database permanently and we can use it whenever we require. Other program also can use this stored procedure. And the transaction of stored procedure take care by DBA. But the local procedure transaction is take care by manually only


How do you create site password with JavaScript?

JavaScript is an exceptionally poor choice for password protection. By its very nature it runs on the user's computer, which means an even minutely clever user can see it. If you want passwords that aren't trivial to get around, use a server-side language (PHP or Ruby On Rails might be good choices) to check the passwords against a database (with code properly protected against SQL injection, preferably with stored procedures).


What is the programming language does enovia use?

It's JAVA based on the front end with Html and Javascript for the web interface. The backend can be either Oracle or SQL Server 2005/2008 -- with SQL Server 2008 being be better performance over Oracle on the same hardware and lower cost.


Can you use javascript in Mozilla?

Yes. In fact, you can use JavaScript in any web browser.


What statement is used to execute a procedure?

Just use the name of the procedure. For example, if I have a procedure addEntry(a NUMBER, b OUT NUMBER) then I can call it by: DECLARE x NUMBER; BEGIN addEntry(5, x); END . run;


How do you use SQL?

You use SQL by issuing commands to an SQL server, either directly by you or by a program you are using.


How do you use javascript in aspnet?

Ajax, I believe uses JavaScript + ASP.


How do you get the popup javascript box?

Use confirm or alert in javascript code to get a popup


Use Javascript?

It will help


How do you write javascript code to close a browser window?

If you want to close the current window, use window.close() or simply close() If you want to close a window that is stored in a JavaScript variable, apply the method close() to it. For example: var myWindow=window.open("http:\/\/www.example.com/"); myWindow.close();