Latest Answer : Data objects are basic runtime entities. ...
Assume that I have created a employees table which has 10 records. How to create a stored procedure to export all the records into the log file.
Latest Answer : Clustered Index ...
Latest Answer : CREATE TABLE dbo.SalesByQuarter ( Y INT, Q INT, sales INT, PRIMARY KEY (Y,Q) ) GO INSERT dbo.SalesByQuarter(Y,Q,Sales) SELECT 2003, 2, 479000 ...
How do I lock a column, once records are entered into the table they can not be edited. Also how can I lock the field where only certain values are accepted?
Latest Answer : May be you can use Constraints. ...
How to use the pivot option in MS SQL Server 2005 and How to convert the regular columns into pivoted columns explain with an example
Latest Answer : We can copy the Table structure also from one table to another tableExample: CREATE table emp1 as ...
Latest Answer : select * into new table name from old table name where 1=0 ...
How we can pulish the connectivity of SQL query to the HTML file or web page? Please Explain.
Latest Answer : Normally connection of SQL file to a web page can be done in two ways1. Through the code2. In web config fileIf we give through the code, we need to alter the relevant pages, where as if we give through web config , this will be a common file and will ...