Answer / anil panwar

SP_help < table_name>

Answer / vidit tyagi

sp_help <tablename>

Answer / krishnaraj

sp_help '<TABLE NAME>'

Answer / erwin suryana

sp_columns <table_name>

Answer / ram

sp_help <table name>

Answer / sathish

how can i view structure of table in sql server? tell me
that query.

Select * from information_schema.columns where table_name =
xyz

Answer / r.rajesh

sp_columns table_name

Answer / sagar

Select TableName and then press ALT+F1 means highlight tablename

Answer / murli manohar

sp_tables @table_type = "'TABLEName'"

Answer / justus

sp_helptext <tablename>

What happens if date-only values are provided as date and time literals?

0 Answers  

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

0 Answers  

What is the maximum rows in sql server table?

0 Answers  

What stored by the tempdb ? : sql server database administration

0 Answers  

what is normalization? Explain different levels of normalization? : Sql server database administration

0 Answers  

What is 2nf in normalization?

0 Answers  

What is similarity and difference between truncate and delete in sql?

0 Answers  

What does select 1 mean?

0 Answers  

Differentiate between mongodb vs. Sql server?

0 Answers  

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

What is indexed views? plz explain with example?

2 Answers