Posted
by loviji
on Stack Overflow
See other posts from Stack Overflow
or by loviji
Published on 2010-03-13T12:35:33Z
Indexed on
2010/03/13
12:45 UTC
Read the original article
Hit count: 267
Can I create a table without colum in MS SQL Server by t-sql?
© Stack Overflow or respective owner
as seen on SQL Authority
- Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL…
>>> More
as seen on Dot net Slackers
- Search for 'Dot net Slackers'
In this post, we will show and explain a small TSQL Sql Server 2008 procedure that deletes all rows in a table that are older than some specified date. That is, say the table has 10,000,000 rows in it the accumulated over the past 2 years. Say you want to delete all but [...]...Did you know that…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
i am very confused
please help to clarify these differences!
are they all completely different languages? what is the overlap?
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
The Microsoft SQL Server protocol documentation provides detailed technical specifications for Microsoft proprietary protocols (including extensions to industry-standard or other published protocols) that are implemented and used in Microsoft SQL Server to interoperate or communicate with Microsoft…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
About an year ago, I had posted SQL Server related Interview Questions and Answers. It was very well received in community. I have received many comments, suggestions and emails on this subject. I am planning to upgrade the Interview Questions and Answers and take it to next level.
Here, I need your…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a big stored procedure on a MSSQL 2008 Express SP2 database that gets run about every 200 ms. Normal execution time is about 50ms. What I am seeing is large inconsistencies in this run time. It will execute for while, say 50-100 times at 40-60ms which is expected, then seemingly at random…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Can I create a table without colum in MS SQL Server by t-sql?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm using MSSQLExpress named instance in my Silverlight 4 application.
The database located in the web application data folder. I attached the db via VS2010.
The program works, but the db doesn't show up in Management Studio Express.
If I delete the connection from within VS2010, and Try to attach…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello, I have an ASP.NET 2.0 application that I made to keep track of disruption reports about our public transport system. The architecture is pretty straight-forward; an MSSQL Express 2008 database, ADO.NET and a DataSet/DAL with a few methods to access the database. There is a set of .aspx pages…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Hi
Running Windows Server 2008, 74GB raptor drive and noticed we only had about 500MB left - yikes!
So deleted some old backups we don't need, but can't track down where about 30GB seems to be taken up. If I go to C: and select all folders and go to properties, this comes to around 30GB but in My…
>>> More
