Explain what is cte (common table expression)?
How to search for a string in all stored procedure in sql server?
hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution
what is the output for this query select * from employee where 1=1;
What is a coalesce function?
After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )
3 Answers CarrizalSoft Technologies, iGate,
How many nested transaction can possible in sql server?
What is msdb database? : SQL Server Architecture
What is The Use Of TIMESTAMP DataType in SQL Server 2005?
How to optimize stored procedure optimization?
How many types of system privileges are there, Can we add or delete privileges?
Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance
How many triggers you can have on a table?