What is the equivalent of 'describe table' in SQL Server??

I have a SQL Server database and I want to know what columns and types it has. I'd prefer to do this through a query...

What is the equivalent of 'describe table' in SQL Server??

I have a SQL Server database and I want to know what columns and types it has. I'd prefer to do this through a query...

Tableau – Using Nested Aggregations to Establish a Weekday/Hour Baseline?

Background Information: We have an incident time tracker that tracks how long each user spends with a representative...

white circle in microsoft SQL server management studio 2012?

I'm new in SQL server management studio 2012 now i'm use data from server and it has a white circle on my database ...

Getting white icon for instance in SSMS??

I have registered one new server but showing white icon instead of green. But my other colleagues can able to see gr...

Would you mind sorting through a few Beginner SQL invoice database creation questions??

I'm somewhat new to SQL. I need to make an invoice that can be queried to create a document that looks something li...

Database Design for Invoices With Monthly Installments?

This question is an extension/expansion of an already answered question on StackOverflow: Database Design for Invoic...

Save data in single byte Kana for japanese language?

I have a situation where I am storing bank name for Japanese culture for Japan. So the problem is we found the Bank ...

SQL Server database design users, groups, roles, memebers?

I have the following SQL Server db with one table so far. ---------------- |Users | ---------------- | Use...

Understanding adventureworks2012 db structure?

I go through a tutorial on hierachyid and for their explanation they use the following query on the advantureworks20...

How to ALTER multiple columns at once in SQL Server?

I need to ALTER the data types of several columns in a table. For a single column, the following works fine: ALTER...

How to check if a database exists in SQL Server??

What is the ideal way to check if a database exists on a SQL Server using TSQL? It seems multiple approaches to impl...

Adventure Works Explanation?

I've been looking at Microsoft's Adventure Works 2012 database. I'd be very interested if there's any information ex...

How do I drop table variables in SQL-Server? Should I even do this??

I have a table variable in a script (not a stored procedure). Two questions: How do I drop the table variable? D...

SELECT using Correlated Sub Queries and multiple tables?

I have two tables (Table1 & Table2). One including a date (tDate) column and an ID (tTillNo) column that I would...