How to execute stored procedure and set temp table in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Explain filtered indexes?
How do clustered indexes store data?
What are the features of Embedded SQL
How do you manipulate data?
how we can store the value like that 001,003,023 etc in sql server 2005
In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2
What type of locking occurs during the snapshot generation? : sql server replication
what are the types of indexes? : Sql server database administration
About Indexed Views? with example? plz reply...
What it means to be triggered?
Explain what are partitioned views and distributed partitioned views?
How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)